The fill handle is the small square at the bottom-right corner of a selected cell that lets you copy data or formulas across multiple cells at once

When you select a cell in Excel, you'll see a tiny square in the bottom-right corner of the cell border. That square is the fill handle. Click and drag it across adjacent cells, and Excel copies whatever is in the original cell — whether that's a number, text, or a formula — into each cell you drag across. If the cell contains a formula, Excel automatically adjusts the cell references as it copies, so each new cell calculates based on its own row or column.

This is one of the most time-saving features in Excel because it eliminates the need to type the same formula or data over and over. Instead of manually entering a calculation in 50 rows, you can write it once and drag the fill handle down to row 50 in seconds.

Key Takeaways

  • The fill handle is the small square at the bottom-right corner of any selected cell; drag it to copy the cell's contents across or down.
  • When you drag a formula, Excel adjusts the cell references automatically — if you copy a formula that adds A1+B1 down one row, the next row becomes A2+B2.
  • Double-clicking the fill handle auto-fills down to the last row of data in an adjacent column, saving you from counting rows manually.
  • The fill handle works with numbers, text, dates, and formulas, and can even recognize patterns like "Monday, Tuesday, Wednesday" and continue them.

How to use the fill handle to copy formulas down a column

Start by clicking the cell that contains the formula or data you want to copy. You'll see the cell border highlight, and the fill handle appears as a small square in the bottom-right corner. Position your cursor directly over that square until the cursor changes to a crosshair or plus sign.

Click and hold the mouse button, then drag downward to the last cell where you want the formula to appear. As you drag, Excel shows you a blue highlight covering all the cells you're selecting. Release the mouse button, and the formula copies into every cell in that range. Each copy automatically adjusts its cell references — if the original formula was =A1+B1, the cell below becomes =A2+B2, and so on.

How to use the fill handle to copy data across columns

The fill handle works the same way horizontally as it does vertically. Click the cell with your data or formula, position your cursor over the fill handle square, and drag to the right instead of down. Excel copies the contents across each column, adjusting cell references as it goes.

This is useful when you have a formula that needs to explore to multiple columns of data. For example, if you have sales data in columns A and B and you want to calculate the total in column C, you can write the formula once in C1, then drag the fill handle to the right to explore it across as many columns as you need.

Using the double-click shortcut to fill down automatically

If you have a long list of data and don't want to count how many rows to drag, use the double-click method. Click the cell with your formula, then position your cursor over the fill handle and double-click. Excel automatically fills down to the last row that has data in the column when ready to the left.

This works best when you have a complete column of data next to the cell you're filling. For example, if column A has 100 rows of customer names and you write a formula in B1, double-clicking the fill handle in B1 will fill down through B100 automatically. If there's a gap in the adjacent column's data, the fill stops at the gap.

How Excel adjusts cell references when you use the fill handle

Excel uses relative references by default, which means the cell addresses in your formula change based on where you copy them. If you write =A1*2 in cell B1 and drag down to B5, each row's formula adjusts: B2 becomes =A2*2, B3 becomes =A3*2, and so on. This is usually what you want because it applies the same calculation to each row's data.

If you need a cell reference to stay the same when you copy, use an absolute reference by adding dollar signs. Write =$A$1*2 instead, and that reference to A1 stays locked no matter where you copy the formula. You can also mix them: =$A1*2 locks the column but lets the row change, or =A$1*2 locks the row but lets the column change. This matters when you're copying a formula that needs to reference a single cell — like a tax rate or a conversion factor — while calculating different rows of data.

Recognizing and extending patterns with the fill handle

Excel can recognize some patterns and continue them when you use the fill handle. If you type "Monday" in one cell and "Tuesday" in the cell below, then select both cells and drag the fill handle down, Excel continues the pattern: Wednesday, Thursday, Friday, and so on. The same works for months, numbered sequences, and custom lists you've created in Excel settings.

This feature is less reliable than formulas, so don't count on it for critical data. If Excel doesn't recognize your pattern, it just copies the last cell's value instead. You can always undo and try a different approach if the pattern doesn't work as expected.

When the fill handle doesn't appear or won't work

If you don't see the fill handle, check your Excel settings. Go to File > Options > Advanced, and look for the option "Enable fill handle and cell drag-and-drop." Make sure it's checked. Some versions of Excel hide this option in different menus, so search for "fill handle" in the Options window if you can't find it when ready.

The fill handle also won't work if you've selected multiple non-adjacent cells or if you're in edit mode (typing inside a cell). Click outside the cell to exit edit mode, then select a single cell and try again. If you're trying to fill across a very large range, Excel sometimes stops responding — in that case, use the keyboard method instead: select the range you want to fill, then press Ctrl+D to fill down or Ctrl+R to fill right.

Frequently Asked Questions

What's the difference between the fill handle and copy-paste?

The fill handle is faster for adjacent cells and automatically adjusts formulas as it copies. Copy-paste gives you more control — you can paste the same formula into non-adjacent cells, paste only the values without formulas, or paste only the formatting. For a quick fill down a column, the fill handle is usually quicker; for complex copying tasks, copy-paste is more flexible.

Can I use the fill handle to copy text that isn't a pattern?

Yes. If you have text like "Invoice" in a cell, you can drag the fill handle down and it copies "Invoice" into every cell below. Excel won't try to create a pattern — it just repeats the same text. This is useful for labeling columns or rows with the same category.

What happens if I drag the fill handle over cells that already have data?

Excel overwrites whatever was in those cells. If you accidentally drag too far, press Ctrl+Z to undo and try again. There's no warning, so be careful when dragging over a large range.

Why does my formula show the same result in every cell after I use the fill handle?

This usually means you used an absolute reference (with dollar signs) when you meant to use a relative reference. Check your formula and remove the dollar signs if you want the cell references to change as you copy down. If the formula is correct but the results look wrong, verify that the data in each row is what you expect.

Can I use the fill handle to copy formulas across both rows and columns at the same time?

Not with a single drag. Select the cell with your formula, drag down to fill the column, then select that entire filled range and drag right to fill across columns. Or select the range where you want the formula to appear, type the formula in the first cell, then press Ctrl+D to fill down and Ctrl+R to fill right.