The fastest way to copy a formula
To copy a formula in Excel, select the cell with the formula, copy it (Ctrl+C on Windows or Command+C on Mac), then select where you want it to go and paste (Ctrl+V or Command+V). Excel automatically adjusts the cell references in the formula for each new location — so if your original formula adds A1+B1, the copy in the next row will add A2+B2 instead.
This automatic adjustment is what makes copying formulas useful. Without it, you would have to type each formula by hand. Excel assumes you want the references to shift along with the formula, and in most cases that is exactly what you need.
Key Takeaways
- Copy a formula with Ctrl+C (Windows) or Command+C (Mac), then paste it with Ctrl+V or Command+V into the cells where you need it.
- Excel changes the cell references automatically when you paste — A1+B1 becomes A2+B2 in the next row — so you do not have to rewrite the formula.
- Use the fill handle (the small square at the bottom right of a selected cell) to drag a formula down or across multiple cells at once.
- If you want the formula to reference the same cell every time you copy it, add a dollar sign before the column letter and row number — for example, $A$1 stays fixed while A1 shifts.
Using the fill handle to copy down a column
The fastest way to copy a formula to many cells at once is the fill handle. Click the cell with your formula, then look at the bottom right corner of the cell — you will see a small square. Click and drag that square down (or across) to fill the cells below with the same formula.
As you drag, Excel shows you how many cells you are filling. When you release the mouse, the formula copies to all those cells and the references shift automatically. This method is much faster than copy-paste when you need the formula in 10 or 20 cells in a row.
If the fill handle is hard to see, make sure the cell is selected first. Sometimes the square is small enough that it takes a moment to spot it at the corner of the cell.
When to use absolute references (the dollar sign)
Most of the time, you want Excel to shift the cell references when you copy a formula. But sometimes you want a formula to always reference the same cell, no matter where you copy it. That is when you use an absolute reference — a dollar sign before the column letter and row number.
For example, if you have a tax rate in cell E2 and you want every formula in column C to multiply by that rate, write the formula as =A1*$E$2. When you copy this formula down, A1 becomes A2, A3, and so on, but $E$2 stays the same. Without the dollar signs, the formula would try to reference E3, E4, and beyond, which is wrong.
You can also use a partial absolute reference: $E2 keeps the column fixed but lets the row shift, or E$2 keeps the row fixed but lets the column shift. This is useful when you are copying a formula both down and across and only one direction should stay fixed.
Copying a formula to non-adjacent cells
If the cells you want to fill are not next to each other, copy-paste is your only option. Select the cell with the formula, copy it, then hold Ctrl (Windows) or Command (Mac) and click each cell where you want the formula to go. When you have selected all of them, paste once and the formula appears in every cell you selected.
This method is slower than the fill handle but necessary when your target cells are scattered across the spreadsheet. Excel still adjusts the references automatically, so each copy gets the right cell references for its location.
Pasting without changing the formula
Sometimes you copy a formula but realize you do not want the references to shift. Use Paste Special instead of regular paste. Press Ctrl+Shift+V (Windows) or Command+Shift+V (Mac) to open the Paste Special dialog.
In the dialog, you will see options for what to paste. If you want the formula exactly as it is without any reference changes, click the "Formulas" option and then paste. If you want only the result (the number the formula produces) without the formula itself, choose "Values" instead.
Paste Special also lets you paste only the formatting, only the comments, or combine the formula with existing formatting in the cell. It is a more advanced tool, but it solves the problem when a regular paste does not give you what you need.
Troubleshooting when a copied formula gives the wrong answer
If you copy a formula and the result looks wrong, the most common cause is that the cell references shifted when they should not have. Open the cell and look at the formula bar at the top — you will see exactly what the formula is referencing. If it is referencing the wrong cells, add dollar signs to lock the references that should not move.
Another common problem is copying a formula that references cells outside the range you are filling. For example, if you copy a formula from row 5 down to row 100, and the formula references a cell in row 3, that reference will shift too. Check whether the formula should reference a fixed cell (use $) or whether it should shift with each row.
If you are not sure whether a formula is correct, click a cell with the formula and look at the formula bar. You can also click the cells the formula references — Excel highlights them in color so you can see exactly what the formula is using.
Frequently Asked Questions
What is the difference between copying a formula and copying a value?
When you copy a formula, you copy the calculation itself — the formula bar shows =A1+B1, and when you paste it, the references shift. When you copy a value, you copy only the result — the number that appears in the cell. Use Paste Special and choose "Values" if you want to paste only the number without the formula.
Can I copy a formula from one spreadsheet to another?
Yes. Copy the cell with the formula, switch to the other spreadsheet, and paste. The formula works the same way, but the cell references now point to cells in the new spreadsheet. If the new spreadsheet does not have data in those cells, the formula may show an error or zero.
Why does my formula show an error after I copy it?
The most likely reason is that the formula is now referencing cells that do not contain the right data. Open the cell and check the formula bar to see what it is referencing. If the references shifted when they should not have, add dollar signs to lock them in place.
How do I copy a formula to every cell in a column without selecting them all first?
Copy the cell with the formula, select the entire column by clicking the column header, and paste. Excel fills every empty cell in that column with the formula, adjusting references as it goes. If the column has data in some cells, select only the range you want to fill instead.
Can I copy a formula and have it reference the same cells in a different order?
Not automatically. If you copy a formula that adds A1+B1 and you want the copy to add B2+A2 instead, you have to edit the formula by hand or write a new one. Excel copies formulas exactly as they are, only shifting the references based on where you paste.