The fill handle is the small square at the bottom-right corner of a selected cell that lets you copy data or formulas down or across a spreadsheet without typing them repeatedly.
When you click on a cell in Excel, a tiny box appears at the lower-right corner of that cell's border. That box is the fill handle. Click and drag it downward or to the right, and Excel copies whatever is in the original cell into all the cells you drag across. If the cell contains a formula, Excel adjusts the formula for each new row or column automatically. If it contains a pattern — like 1, 2, 3 or January, February, March — Excel recognizes the pattern and continues it.
The fill handle saves time on repetitive work. Instead of typing the same formula into fifty cells, you type it once and drag the fill handle fifty times. Instead of manually entering month names down a column, you type two months and let Excel finish the sequence.
Key Takeaways
- The fill handle is the small square at the bottom-right corner of any selected cell in Excel.
- Dragging the fill handle down or across copies the cell's contents and adjusts formulas automatically for each row or column.
- Excel recognizes straightforward patterns like numbers or month names and continues them when you drag the fill handle.
- Double-clicking the fill handle fills down to the last row that has data in an adjacent column, which is faster than dragging manually.
- The fill handle works the same way whether you are copying text, numbers, formulas, or dates.
How to use the fill handle to copy a formula down
Click the cell that contains the formula you want to copy. Look at the bottom-right corner of that cell — you will see a small square. Position your cursor directly over that square until the cursor changes to a plus sign. Then click and drag downward to select all the cells where you want the formula to appear.
As you drag, Excel shows you how many rows you are selecting. When you release the mouse, the formula appears in all those cells. Excel automatically changes the cell references in each row. If your original formula was =A1+B1, the second row will show =A2+B2, the third row will show =A3+B3, and so on.
This automatic adjustment is why the fill handle is useful for formulas. You do not have to rewrite the formula for every row — Excel does it for you.
Recognizing and continuing patterns with the fill handle
Excel can recognize certain patterns and continue them when you use the fill handle. If you type 1 in one cell and 2 in the cell below it, then select both cells and drag the fill handle down, Excel will continue the sequence: 3, 4, 5, and so on. The same works for months (January, February, March) or days of the week (Monday, Tuesday, Wednesday).
To use this feature, you need to give Excel at least two examples of the pattern. Type the first item, then the second item in the next cell. Select both cells together, then drag the fill handle. Excel will recognize what you are doing and fill in the rest of the sequence.
If you only select one cell and drag the fill handle, Excel will straightforward copy that cell's contents rather than continue a pattern. That is why starting with two examples matters.
The double-click shortcut for filling down quickly
Instead of dragging the fill handle all the way down a column, you can double-click it. Excel will automatically fill down to the last row that contains data in the column when ready to the left or right. This is much faster than dragging when you have hundreds of rows.
For example, if column A has data in rows 1 through 500, and you select a cell in column B with a formula, double-clicking the fill handle will copy that formula down to row 500 automatically. Excel stops at the last row with adjacent data, so you do not have to count rows or drag manually.
This shortcut only works if there is data in an adjacent column. If the columns around your formula are empty, double-clicking the fill handle will only fill the next cell down.
Filling across columns instead of down rows
The fill handle works the same way to the right as it does downward. Select a cell, position your cursor over the fill handle, and drag to the right instead of down. Excel will copy the cell's contents across to all the cells you select. Formulas adjust their column references just as they adjust row references when filling down.
This is useful when you have a formula that needs to explore across multiple columns. For instance, if you are calculating totals for each month in a row, you can write the formula once and drag it across to explore it to all twelve months.
When the fill handle does not work as expected
Sometimes the fill handle copies a cell exactly instead of adjusting the formula. This usually happens when the cell reference in your formula uses absolute references — a dollar sign before the column letter or row number, like $A$1. An absolute reference does not change when you copy the formula, so every cell will contain the exact same formula.
If you want the formula to adjust for each row, use a relative reference (no dollar sign), like A1. If you want only the column to stay the same but the row to change, use $A1. If you want only the row to stay the same but the column to change, use A$1.
Another common issue is that the fill handle may not appear if the cell is not properly selected. Click the cell once to make sure it is active, and the fill handle should appear at the bottom-right corner.
Fill handle versus copy and paste
The fill handle and the copy-paste method both accomplish the same goal, but they work differently. The fill handle is faster for small jobs because you do not have to open a menu or use keyboard shortcuts. Copy and paste gives you more control — you can copy a cell and paste it into non-adjacent cells, or paste only the values without the formulas.
For most everyday spreadsheet work, the fill handle is the quicker choice. For more complex tasks where you need to paste formulas into scattered cells or paste only values, copy and paste is more flexible. Learning both methods means you can choose the right tool for each situation.
Frequently Asked Questions
Why is the fill handle not showing up on my cell?
The fill handle only appears when a cell is selected. Click the cell once to select it, and the small square should appear at the bottom-right corner. If you still do not see it, check that your cursor is positioned directly over the cell border, not inside the cell itself.
Can I undo a fill handle action if I made a mistake?
Yes. Press Ctrl+Z (or Cmd+Z on Mac) when ready after using the fill handle to undo the action. This works the same as undoing any other change in Excel.
What happens if I drag the fill handle over cells that already have data?
The fill handle will overwrite whatever is in those cells. If you accidentally drag over cells you wanted to keep, use Ctrl+Z to undo and try again with a smaller selection.
Does the fill handle work with text that is not a pattern?
Yes, but it will straightforward copy the text exactly into each cell. The fill handle only recognizes and continues patterns like numbers, months, and days of the week. For other text, it behaves like a straightforward copy function.
Can I use the fill handle to copy formulas across multiple columns and down multiple rows at the same time?
No, the fill handle works in one direction at a time — either down or across. To fill both directions, select the cell with the formula, drag it down to fill the rows you need, then select the entire range you just filled and drag to the right to fill the columns.