The basic way to copy a formula down or across

To copy a formula in Excel, select the cell containing the formula, copy it (Ctrl+C on Windows, Cmd+C on Mac), then select the range where you want it to go and paste (Ctrl+V or Cmd+V). Excel automatically adjusts the cell references in the formula for each new location — so if your original formula adds A1 and B1, the copy in the next row will add A2 and B2 instead.

The faster method is to use the fill handle: click the cell with your formula, then drag the small square at the bottom-right corner of the cell down or across to fill adjacent cells. This does the same thing as copy-paste but in one motion. If you want to fill a large range quickly, select your starting cell, then hold Shift and click the last cell in the range you want to fill, and press Ctrl+D (Windows) or Cmd+D (Mac) to fill down.

Key Takeaways

  • Excel changes cell references automatically when you copy a formula — A1 becomes A2, A3, and so on as you move down rows.
  • Use the fill handle (the small square at the cell's corner) to drag a formula across or down without opening the copy menu.
  • Absolute references (written as $A$1) stay the same when copied, while relative references (A1) change based on the new location.
  • Paste Special lets you copy only the formula result as a number, or only the formatting, without changing how the formula works.

When to use absolute references so formulas don't change

Sometimes you want a formula to refer to the same cell no matter where you copy it. Use an absolute reference by putting a dollar sign before the column letter and row number: $A$1 instead of A1. When you copy this formula, that reference stays locked to A1 in every copy.

A common example: you have a tax rate in cell E2 that you want to multiply against many different amounts. Write your formula as =A1*$E$2, then copy it down. The A1 part changes to A2, A3, A4 as you go down, but $E$2 always points to the tax rate. If you used =A1*E2 instead, the E2 would shift to E3, E4, E5 and your formula would break.

You can also lock just the column or just the row: $A1 keeps the column fixed but lets the row change, and A$1 keeps the row fixed but lets the column change. This is useful when copying formulas both down and across at the same time.

Copying formulas without changing the results

If you want to copy a formula but turn it into a plain number so it no longer updates automatically, use Paste Special. Copy your formula cell, then right-click where you want to paste and select "Paste Special" (or press Ctrl+Shift+V on Windows, Cmd+Shift+V on Mac). Choose "Values" and click OK. The formula disappears and only the result stays behind as a number.

Paste Special is also useful if you want to copy only the formatting (colors, fonts, borders) without the formula itself. Select "Formats" instead of "Values" to copy the look of a cell without changing what's inside the destination cell. This saves time when you want many cells to look the same but contain different data.

Fixing formulas that break after copying

If a formula stops working after you copy it, the most common cause is that cell references shifted when they shouldn't have. Open the cell and look at the formula bar at the top of the screen — check whether the references point where you expect them to. If a reference should have stayed fixed but didn't, add dollar signs to make it absolute.

Another common problem: you copied a formula to a cell that already had data, and now you're not sure which is which. Press Ctrl+Z (Cmd+Z on Mac) to undo the paste, then try again. If you need to see what changed, select a cell with a formula and look at the formula bar — it shows exactly which cells the formula is reading from. Click any cell reference in the formula bar and Excel will highlight that cell on the spreadsheet so you can verify it's correct.

Copying formulas between different sheets

You can copy a formula from one sheet to another the same way you copy within a sheet: copy the cell, switch to the other sheet, and paste. Excel keeps the formula intact and adjusts references based on the new sheet's layout. If your formula refers to a cell on a different sheet (like =Sheet1!A1), that reference stays the same when you copy to another sheet.

If you want to copy a formula and have it refer to the same cell on every sheet, you need to write the reference differently. Instead of =A1, write =Sheet1!A1 to explicitly name the sheet. When you copy this formula to Sheet2, it will still point to Sheet1's A1, not Sheet2's A1. This is useful when you have the same data structure on multiple sheets and want one formula to pull from a single source.

Copying formulas from other people's spreadsheets

When you copy a formula from someone else's file into yours, Excel usually adjusts the references to match your spreadsheet's layout. If the original file had a formula that added column A, your copy will also add column A — but it will be your column A, not theirs. This works smoothly most of the time.

The exception is when the original formula refers to named ranges (custom names for cells or ranges that the creator set up). If you copy a formula that uses a named range you don't have, Excel will show an error. Ask the person who created the file what the named range refers to, then either create the same named range in your file or edit the formula to use regular cell references instead.

Frequently Asked Questions

Why did my formula change when I copied it?

Excel automatically adjusts cell references when you copy a formula to a new location. If you want a reference to stay the same, add dollar signs: change A1 to $A$1. If only some references should stay fixed, use $A1 or A$1 depending on whether you want to lock the column or row.

Can I copy a formula to a different sheet?

Yes. Copy the cell, switch sheets, and paste. Excel keeps the formula and adjusts references to match the new sheet's layout. If you want the formula to always refer to a specific sheet, write the reference as SheetName!A1 instead of just A1.

How do I copy just the result of a formula, not the formula itself?

Copy the cell with the formula, right-click where you want to paste, select Paste Special, choose Values, and click OK. The result becomes a plain number that won't change if the original data updates.

What's the fastest way to copy a formula to many cells?

Select the cell with the formula, then drag the small square at the bottom-right corner of the cell down or across. For very large ranges, select the starting cell, hold Shift, click the last cell you want to fill, then press Ctrl+D (Windows) or Cmd+D (Mac).

Why does my copied formula show an error?

Check the formula bar to see which cells it's referring to. The most common causes are that a reference shifted when it shouldn't have (fix it by adding dollar signs), or the formula refers to a named range that doesn't exist in your file. Edit the formula or recreate the named range to fix it.