The fastest way to repeat a formula across cells
To copy a formula in Excel, select the cell containing the formula, then drag the small square at the bottom-right corner of that cell down or across to the cells where you want the formula to repeat. 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 is the core reason spreadsheets save time. Instead of typing the same calculation fifty times, you type it once and let Excel handle the repetition. The adjustment happens automatically because Excel uses relative references by default, which means the formula updates based on its new location.
There are three ways to copy a formula: the drag method (fastest for small ranges), the copy-paste method (works anywhere on the sheet), and the fill-down method (best when you have a large block selected). Each one produces the same result — the choice depends on how many cells you're filling and where they are.
Key Takeaways
- Dragging the fill handle (the small square at the cell's corner) down or right copies the formula and automatically adjusts cell references for each new row or column.
- Copy the cell with Ctrl+C, select the range where you want it, and paste with Ctrl+V to fill multiple cells at once, even if they're not adjacent.
- If you want the formula to reference the same cell every time it copies, add a dollar sign before the column letter and row number — for example, $A$1 stays fixed while A1 changes.
- Excel shows you a preview of what the formula will look like in each cell as you drag, so you can see the adjustment happening before you release the mouse.
Dragging the fill handle for quick copying
The fill handle is the small square at the bottom-right corner of any selected cell. When you click and drag it, Excel copies the formula down or across and adjusts the references automatically. This is the fastest method when you're filling a small range — usually up to 20 or 30 cells in one direction.
Click the cell with your formula to select it. Move your cursor to the bottom-right corner until you see a small plus sign (+). Click and drag downward to fill cells below, or drag to the right to fill cells across. As you drag, Excel shows a preview of the range you're selecting. Release the mouse, and the formula appears in every cell you dragged across, with references updated for each row or column.
If you need to fill a large range — say, 500 rows — dragging becomes tedious. Double-click the fill handle instead. Excel will automatically fill down to the last row that has data in the adjacent column, saving you from dragging all the way down manually.
Using copy and paste for non-adjacent cells
When the cells you want to fill aren't next to each other, or when they're scattered across the sheet, copy and paste is faster than dragging. Select the cell with the formula and press Ctrl+C (or Cmd+C on Mac). Then select the range where you want the formula to go — this can be a continuous block, or you can hold Ctrl and click individual cells to select multiple separate locations.
Once you've selected all the destination cells, press Ctrl+V to paste. Excel fills every selected cell with the formula, adjusting references automatically in each one. This method also works if you want to copy a formula from one sheet to another — just copy from the source sheet, switch to the destination sheet, select your range, and paste.
You can also right-click the cell with the formula, choose Copy, then right-click the destination range and select Paste. The result is identical, but the keyboard shortcut is faster if you're doing this repeatedly.
Understanding relative and absolute references
By default, Excel uses relative references, which means the cell addresses in your formula change based on where the formula moves. If you write =A1+B1 in cell C1 and copy it down to C2, it automatically becomes =A2+B2. This is usually what you want — it's why copying formulas saves time.
Sometimes you need a cell reference to stay the same no matter where the formula copies to. This is called an absolute reference, and you create it by adding a dollar sign ($) before the column letter and row number. For example, =$A$1 always refers to cell A1, even if you copy the formula to a different row or column.
You can also mix the two. =$A1 keeps the column fixed but lets the row change, while =A$1 keeps the row fixed but lets the column change. This is useful when you're copying a formula across a row and want it to always reference a specific column, or vice versa. As you drag or paste, Excel shows you exactly which cells the formula will reference in each location, so you can verify the references are correct before you finish.
Copying formulas across rows and columns at the same time
If you have a formula in one cell and need it to fill both down and across — creating a grid of formulas — select the cell with the formula, then drag to select the entire rectangular range you want to fill. For example, if your formula is in A1 and you want it in a 5-by-5 grid, click A1 and drag to E5.
With the range selected, use Ctrl+D to fill down (which fills all selected cells with the formula from the top row) or Ctrl+R to fill right (which fills all selected cells with the formula from the leftmost column). Excel adjusts all references automatically as it fills the grid. This is much faster than copying and pasting multiple times.
What to do when the formula doesn't adjust the way you expect
If you copy a formula and the results look wrong, the most common cause is that you used absolute references ($) when you meant to use relative references, or vice versa. Check the formula bar — click one of the cells where you pasted, and look at the formula at the top of the screen. If the cell references didn't change when they should have, add or remove dollar signs as needed.
Another common issue is copying a formula that references cells outside the range you're filling. For example, if your formula is =SUM(A1:A10) and you copy it down to row 20, the formula becomes =SUM(A2:A11), =SUM(A3:A12), and so on — the range shifts with each copy. If you want the range to stay fixed, use =SUM($A$1:$A$10) instead.
If you accidentally copy over data you wanted to keep, press Ctrl+Z when ready to undo. Excel will restore the overwritten cells and you can try again with a different range or method.
Copying formulas between sheets and workbooks
You can copy a formula from one sheet to another the same way you copy within a sheet — Ctrl+C to copy, then switch sheets, select your range, and Ctrl+V to paste. Excel adjusts the references automatically, and if your original formula referenced cells on the same sheet, those references stay the same on the new sheet.
If you want to copy a formula from one workbook to another, open both files, copy the formula from the source workbook, switch to the destination workbook, select your range, and paste. The formula copies exactly as it was, with the same cell references — so if the destination workbook has different data in those cells, the formula will calculate based on the new data.
Frequently Asked Questions
Why does my formula change when I copy it?
Excel uses relative references by default, so cell addresses shift when you copy. If you want a reference to stay the same, add dollar signs: =$A$1. If the formula is calculating wrong results after copying, check the formula bar to see what references changed, then add or remove dollar signs as needed.
Can I copy a formula to every cell in a column without dragging?
Yes. Copy the cell with Ctrl+C, click the column header to select the entire column, and paste with Ctrl+V. Excel fills the whole column. You can also select just the range you need (like A1:A100), paste, and it fills only that range without affecting cells below.
What's the difference between copying a formula and copying a value?
When you copy a formula, Excel copies the calculation itself — so if the source data changes, the copied formula updates too. When you copy a value, you're copying only the result. To paste only the value, use Ctrl+Shift+V (Paste Special) and choose Values Only.
Can I copy a formula from one workbook to another?
Yes. Open both files, copy the formula from the source workbook with Ctrl+C, switch to the destination workbook, select your range, and paste with Ctrl+V. The formula copies with its references intact, so it will calculate based on the cells in the destination workbook.
How do I copy a formula without changing the cell references?
Use absolute references by adding dollar signs: =$A$1 instead of =A1. This keeps the reference fixed no matter where you copy the formula. You can also use mixed references like =$A1 (column fixed, row changes) or =A$1 (row fixed, column changes) depending on what you need.