The fastest way to copy a formula

To copy a formula in Excel, select the cell containing the formula, then drag the small square in the bottom-right corner of that cell down or across to the cells where you want the formula to appear. Excel automatically adjusts the cell references as it copies — so if your original formula adds A1 and B1, the next row will add A2 and B2 without you having to change anything.

This small square is called the fill handle. When you position your cursor over it, the cursor changes to a thin crosshair. That's your signal you can drag. If you're working with many rows, you can also double-click the fill handle instead of dragging — Excel will copy the formula down to the last row that has data in the adjacent column.

If dragging feels awkward or you're copying to cells far away, use the copy-and-paste method instead: click the cell with the formula, press Ctrl+C (or Cmd+C on Mac), select the range where you want it, and press Ctrl+V. The result is identical.

Key Takeaways

  • The fill handle — the small square at the bottom-right corner of a selected cell — lets you drag a formula to adjacent cells without typing it again.
  • Excel automatically changes cell references when you copy a formula, so A1+B1 becomes A2+B2 in the row below without extra work.
  • Double-clicking the fill handle copies a formula down to match the length of data in the next column, saving you from counting rows.
  • If a formula should not change its references when copied, you can lock them with dollar signs — $A$1 stays the same in every copy.

Understanding how Excel changes references when you copy

When you copy a formula, Excel treats most cell references as relative — meaning they shift based on where you paste. If you copy a formula one row down, every cell reference moves down one row. If you copy it three columns to the right, every reference moves three columns right. This is usually what you want, because it means you write the formula once and Excel does the repetitive work.

Sometimes, though, you want a reference to stay put. For example, if you're calculating sales tax and the tax rate lives in cell D1, you don't want that reference to change when you copy the formula down. To lock a reference in place, add a dollar sign before the column letter and before the row number: $D$1. Now when you copy the formula anywhere, D1 stays D1. You can also lock just the column ($D1) or just the row (D$1) if you want one part to move and the other to stay fixed.

Copying formulas across columns instead of down rows

The fill handle works the same way whether you drag right or down. Select the cell with the formula, position your cursor over the fill handle in the bottom-right corner, and drag to the right. Excel copies the formula and adjusts the references column by column. If your original formula references column A, the next column will reference column B, and so on.

This is useful when you have data arranged horizontally — for instance, monthly sales figures across columns, and you want to calculate a total or average for each month using the same logic. Write the formula for January, then drag it across to February, March, and beyond. Each copy adjusts automatically.

What to do when the fill handle doesn't appear

If you don't see the small square at the bottom-right corner of your selected cell, it's usually because the fill handle feature is turned off in your settings. Go to File, then Options (or Preferences on Mac), then Advanced. Look for the section called Editing Options and check the box next to "Enable fill handle and cell drag-and-drop." Click OK and try again.

If the fill handle is on but still not visible, make sure you've actually selected a cell — not a range of cells. Click a single cell, and the fill handle should appear. If you've selected multiple cells at once, the fill handle won't show.

Copying a formula to a large range quickly

If you need to copy a formula down 100 rows or more, dragging is impractical. Instead, select the cell with the formula, then select the entire range where you want it to go. The easiest way is to click the cell, then hold Shift and click the last cell in the range you want to fill. Now press Ctrl+D (or Cmd+D on Mac), and Excel fills the entire selection with the formula, adjusting references as it goes.

Another method: click the cell with the formula, copy it (Ctrl+C), then select the range and paste (Ctrl+V). Both methods produce the same result. The keyboard shortcut Ctrl+D is faster if you're already selecting a range, but copy-and-paste works if the cells you want to fill aren't adjacent to the original formula.

Pasting a formula without changing the references

Occasionally you want to copy a formula to a new location but keep all the cell references pointing to the original cells — not adjusted versions. This is rare, but it happens when you're building a template or reusing logic in a different part of the sheet. Use Paste Special instead of regular paste: copy the cell (Ctrl+C), then right-click where you want to paste and choose Paste Special. A dialog box opens. Make sure "Formulas" is checked and click OK.

If you want to paste only the values that the formula calculated — not the formula itself — use Paste Special and choose "Values" instead. This is useful when you want to lock in a result before you change the data the formula depends on.

Copying formulas between different sheets

You can copy a formula from one sheet to another the same way you copy within a sheet: select the cell, copy it (Ctrl+C), navigate to the other sheet by clicking its tab at the bottom, select where you want to paste, and paste (Ctrl+V). Excel adjusts the references, but it keeps them pointing to the original sheet unless the cell references in your formula specifically named the sheet.

If your formula references another sheet — for example, =Sheet2!A1+B1 — copying it to a third sheet will keep the reference to Sheet2 but adjust B1 based on where you paste. This is usually the behavior you want. If you need the reference to stay exactly as written, use dollar signs to lock it: =Sheet2!$A$1+$B$1.

Frequently Asked Questions

Why does my formula show a different result after I copy it?

The formula itself copied correctly, but the cell references changed to match the new location. If that's not what you wanted, undo the copy (Ctrl+Z) and add dollar signs to lock the references that should stay the same. For example, change =A1+B1 to =$A$1+B1 if you want A1 to stay fixed but B1 to adjust.

Can I copy a formula to non-adjacent cells?

Yes. Copy the cell (Ctrl+C), then select the first cell where you want to paste, hold Ctrl, and click each additional cell. Now paste (Ctrl+V) and the formula goes to all selected cells. This works when the cells aren't next to each other.

What's the difference between copying a formula and copying its value?

Copying a formula means the new cell contains the same calculation, adjusted for its location. Copying a value means the new cell contains only the number the formula produced — if the original data changes, the value doesn't update. Use Paste Special and choose "Values" to paste only the result.

Does copying a formula to another sheet change what it calculates?

Only if the references in your formula are relative. If you copy =A1+B1 to another sheet, it becomes the same formula but references that sheet's A1 and B1. If you want it to keep referencing the original sheet, your formula must say so: =Sheet1!A1+Sheet1!B1.