The fastest way to copy a formula down is the fill handle

Click the cell with the formula you want to copy. Look at the bottom-right corner of that cell — you'll see a small square. Click and drag that square downward to the last row where you want the formula to appear. Excel automatically adjusts the cell references as it copies.

For example, if your formula in cell B2 says =A2*10, dragging down to B10 creates formulas that say =A3*10, =A4*10, and so on. Each row's formula points to the cell in that same row. This is called a relative reference, and it's what you usually want.

The fill handle works for any number of rows. If you're copying down 100 rows, you can double-click the fill handle instead of dragging — Excel will automatically fill down to the last row that has data in the adjacent column.

Key Takeaways

  • The fill handle (small square at the bottom-right of a cell) is the fastest way to copy a formula down multiple rows.
  • Double-clicking the fill handle automatically fills down to match the data in adjacent columns, saving time on large spreadsheets.
  • Excel adjusts cell references automatically when you copy down, so A2 becomes A3, A4, and so on in each row.
  • If you need the formula to always point to the same cell, use a dollar sign ($) before the column or row number to lock it in place.
  • Copy and paste works for formulas too and gives you more control over which rows receive the formula.

Using copy and paste for more control

Click the cell with the formula. Press Ctrl+C (or Cmd+C on Mac) to copy it. Then select the range of cells where you want the formula to go — click the first cell and drag to the last one, or click the first cell and Shift+click the last one. Press Ctrl+V to paste.

This method is useful when you want to copy a formula to non-consecutive rows, or when you want to be certain exactly which cells receive the formula before you paste. It also works if the fill handle is hard to grab on your screen.

Locking cell references with dollar signs

Sometimes you want a formula to always point to the same cell, even when you copy it down. Use a dollar sign ($) before the column letter or row number to lock it.

If your formula is =A2*$B$1, the A2 will change to A3, A4, and so on as you copy down, but $B$1 will always point to cell B1. You can also lock just the column ($B2) or just the row (A$2) if you only need one part to stay fixed.

This is common when you have a single value — like a tax rate or a discount percentage — that you want to multiply or divide by in every row. Put that value in one cell, lock it with dollar signs, and copy the formula down.

Copying formulas across columns instead of down

The same methods work left to right. Use the fill handle by dragging to the right, or select a range of cells to the right and paste. Excel adjusts the column letters the same way it adjusts row numbers.

If you have a formula in B2 that says =A2+C2, dragging the fill handle to the right creates a formula in C2 that says =B2+D2, and one in D2 that says =C2+E2. The columns shift, but the row stays the same.

What to do when the fill handle doesn't work

If double-clicking the fill handle doesn't fill down as far as you expected, it usually means the adjacent column has gaps in its data. Excel stops filling when it hits an empty cell next to your formula. Copy and paste is more reliable in this situation — select exactly the range you want and paste.

If the fill handle is hard to see or grab, you can also select the cell with the formula, then select the entire range you want to fill (formula cell plus all the cells below it), and press Ctrl+D. This fills down from the top cell to all the cells you selected.

Checking your formulas after copying

After you copy a formula down, click one of the new cells and look at the formula bar at the top of the screen. You'll see the actual formula in that cell. Check that the cell references changed the way you expected — if they didn't, you may need to undo and add dollar signs to lock the references you want to keep.

A quick way to spot problems is to look for formulas that reference cells outside your data range, or that reference empty cells when they shouldn't. If something looks wrong, press Ctrl+Z to undo and try again.

Frequently Asked Questions

Why did my formula change when I copied it down?

Excel automatically adjusts cell references when you copy a formula. If A2 becomes A3 in the next row and that's not what you wanted, you need to lock that reference with a dollar sign. Change A2 to $A$2 if it should always point to the same cell.

Can I copy a formula to every other row?

Yes, but you have to do it manually. Copy the formula, then click each cell where you want it and paste. Or copy the formula down to all rows, then delete the ones you don't need. There's no built-in way to skip rows automatically.

What's the difference between dragging the fill handle and double-clicking it?

Dragging lets you choose exactly how far down to copy. Double-clicking automatically fills down to match the data in the column next to your formula, which is faster if your data is continuous but can stop too early if there are gaps.

How do I copy a formula to hundreds of rows at once?

Select the cell with the formula, then select from that cell down to the last row you need. Press Ctrl+D to fill down. Or copy the cell, select the entire range, and paste. Both work for any number of rows.

Can I copy a formula to a different sheet?

Yes. Copy the cell with the formula, go to the other sheet, and paste it. The formula will adjust its references, but if it references cells from the original sheet, you may need to edit it to include the sheet name (like Sheet1!A2) so it still points to the right place.