How to Use the AutoFill Handle (Small Square) in Excel to Copy and Extend Data

You need to quickly copy formulas or fill a series of dates across many rows in Excel. Manually typing each entry is slow and prone to errors. The AutoFill handle is the small square in the bottom-right corner of a selected cell. This article shows you how to use it to copy data and extend lists automatically.

What the AutoFill Handle Does

The AutoFill handle is a core Excel tool for data entry. It appears as a small black square when you select one or more cells. Dragging this handle tells Excel to fill adjacent cells based on the pattern it detects in your selection. You can use it for simple copying or for extending complex series. The feature works with text, numbers, dates, times, and formulas.

Before using AutoFill, ensure your data is set up correctly. The handle needs a clear starting pattern. For a custom series, you may need to select at least two cells to establish the step value. AutoFill also respects cell formatting, which it copies by default unless you specify otherwise.

Steps to Copy and Extend Data with AutoFill

The primary method is to click and drag the fill handle. For more control, use the right-click menu or double-click for a quick fill.

1. Select your starting cell or range
   Click the cell containing the data you want to copy. To extend a series like 1, 2, 3, select at least the first two cells of the pattern.
2. Locate the fill handle
   Move your cursor to the bottom-right corner of the selection. The pointer will change from a white cross to a thin black cross.
3. Click and drag to fill
   Hold down the left mouse button and drag the handle in the direction you want to fill. A tooltip will show the preview value for the last cell.
4. Release the mouse button
   Excel fills the cells. A small AutoFill Options button appears next to the filled range. Click it to change the fill type.

Using the Double-Click Shortcut

1. Select the cell with your data or formula
   Click the cell you want to copy down a column.
2. Double-click the fill handle
   Move to the cell’s bottom-right corner and double-click the small square. Excel will fill the cells down until it reaches the end of contiguous data in the column to the left.

Using Right-Click for Special Options

1. Select and right-drag the handle
   Select your starting cell, then click and drag the fill handle using the right mouse button.
2. Release and choose an option
   When you release the button, a context menu appears. Select an option like Copy Cells, Fill Series, or Fill Formatting Only.

Common AutoFill Mistakes and Limitations

AutoFill Copies Values Instead of Creating a Series

Excel copies a single cell by default. To create a series like months, you must provide a pattern. Enter “Jan” in one cell and “Feb” in the next. Select both cells, then drag the fill handle. Excel will continue the series with Mar, Apr, and so on.

Double-Click Fill Does Not Work

The double-click method requires a clear guide column. Excel fills down until it hits an empty cell in the adjacent column to the left. If your left column has gaps, the fill will stop at the first gap. Ensure the guide column has continuous data.

Formulas with Relative References Change Incorrectly

This is the intended behavior for relative references. When you drag a formula like =A1+B1, the row numbers increase. To keep a reference fixed, use absolute references with the dollar sign, like =$A$1+$B$1.

AutoFill Handle Methods Compared

Item	Left-Click and Drag	Double-Click	Right-Click and Drag
Primary Use	Extending a series or copying over a short, specific range	Quickly filling formulas down a long column next to existing data	Accessing special fill options like formatting control
Speed	Manual control over range	Fastest for column fills	Slower, but offers menu
Best For	Small ranges and custom patterns	Data tables where a left column acts as a guide	When you need to copy values but not formatting
Limitation	Can be tedious for hundreds of rows	Requires a contiguous guide column	Requires extra mouse clicks

You can now use the AutoFill handle to copy values and extend lists without manual typing. Try the double-click method next time you need to copy a formula down a long column. For advanced patterns, create a custom list in File > Options > Advanced > Edit Custom Lists to teach Excel your own series.