How to Copy a Formula in Excel to Other Cells Safely

To copy a formula in Excel, select the cell that contains it, then drag its fill handle into the cells you want to fill, or copy the cell and paste it elsewhere. Excel adjusts relative cell references as the formula moves, so check the destination cells when a formula needs to keep referring to a fixed row or column.

These steps are for Microsoft Excel for Microsoft 365 on Windows. You can also use the same basic fill and copy methods in Excel for Mac and Excel for the web, though keyboard shortcuts and some ribbon details can differ. Copying a formula is useful for repeating a calculation down a list or across a table without typing the formula again in every cell.

What You’ll Need

An Excel workbook with a formula already entered in a cell.
A destination range that is empty or contains data you are prepared to replace.
If you are copying a formula that refers to other cells, a quick understanding of whether those references should move or stay fixed.

Step-by-Step

Enter and check the starting formula. Select the cell with the formula and look at the formula bar above the worksheet. Confirm that the formula calculates correctly before copying it. For example, with quantity in A2 and price in B2, and with A2 containing 4 and B2 containing 3, enter =A2*B2 in C2. The result in C2 is 12. Keeping the formula in C2 selected, you can see that it refers to the cells in the same row.
Choose the destination cells. Decide whether the formula needs to go down a column, across a row, or into a separate range. Make sure you will not overwrite information you need. If you are filling a continuous range, note the last cell you want to fill; if you are copying to a distant location, use ordinary copy and paste instead of dragging across a large area.
Use the fill handle for a nearby range. Select the source formula cell. Find the small square at the bottom-right corner of its selection border; this is the fill handle. Point to it until the pointer becomes a small black plus sign, then click and drag down or across the cells to fill. Release the mouse button when the highlighted range reaches the intended last cell. Excel copies the formula and normally adjusts its relative references for each destination.
Double-click to fill down alongside a data list. If a neighboring column has a continuous list of entries, select the formula cell and double-click its fill handle. Excel extends the formula down beside that list. This is convenient for long tables, but the stopping point depends on nearby data: gaps or an unexpectedly short adjacent list can make Excel stop early. Inspect the last filled row, especially when the columns beside the formula contain blanks.
Copy and paste when you want more control. Select the formula cell and press Ctrl+C on Windows. Select the destination cell or range, then press Ctrl+V. To copy one formula into several cells, select the whole destination range before pasting. The formula is copied into each selected cell, with relative references adjusted for each position. On Mac, use Command+C and Command+V. In Excel for the web, use the ribbon or the browser-supported keyboard shortcuts if a browser intercepts a shortcut.
Fill a selected range with a keyboard shortcut. To fill down, select a range that includes the source formula cell at the top and the cells below it, then press Ctrl+D on Windows. Excel copies the top cell’s contents down through the selected range. To fill right, select the source cell at the left of the range and the cells to its right, then press Ctrl+R. On Mac, Control+D and Control+R are the usual fill-down and fill-right shortcuts; if your keyboard or Excel settings behave differently, use the ribbon commands instead. On the ribbon, choose Home > Fill > Down or Home > Fill > Right.
Check the copied formulas, not just the displayed numbers. Select a few destination cells and look at the formula bar. With the earlier example, if row 3 has quantity 5 in A3 and price 2 in B3, filling C2 down one row changes its formula to =A3*B3, which returns 10. Check the first and last filled rows and one in the middle. This catches formulas that stopped at the wrong row or shifted toward an unintended column.
Use formula-only paste if you do not want to copy formatting. Copy the source cell, select the destination range, and choose Home > Paste > Formulas. This pastes the formulas without bringing over the source cell’s formatting. It is useful when the destination cells already have the number format, fill color, or borders you want to keep. The ordinary Ctrl+V command may also copy formatting, comments, and other cell content, so use the Formulas option when you need a narrower paste.

Common Mistakes

Assuming every reference stays the same. A reference such as A2 is relative: when a formula moves down one row, Excel usually changes it to A3. That is often exactly what a row-by-row calculation needs. But if every copied formula should refer to one fixed rate or assumption, a relative reference may drift and produce wrong results.

For example, suppose quantities are in A2:A10 and a fixed rate is in F1, with F1 containing 0.1. If the formula is entered in B2, copying it downward should multiply each row’s quantity by the same F1 cell. Use =A2*$F$1 in B2; with A2 equal to 50 and F1 equal to 0.1, the result is 5. The dollar signs lock both the column and row of F1. A reference such as $F1 locks only the column, while F$1 locks only the row.

Dragging the wrong part of the selection. Dragging the selection border moves or copies cells; dragging the small fill handle extends their contents. Check that the pointer is over the tiny square before dragging. Also avoid filling over cells that contain information you need, because a fill operation can replace their contents.

Copying results when you meant to copy a formula. A cell can display a number while containing a formula. Check the formula bar before copying. If you copy a value-only cell, the destination will not recalculate when its input data changes. Likewise, a copied formula can show a value that looks correct once but still refer to the wrong source cells.

Expecting a copied formula to behave like a fixed text string. Relative references change by design. If a formula refers to the wrong cells after filling, changing the reference type or using a carefully selected destination range is better than repeatedly editing every copied formula by hand.

Tips

Use the fill handle for short, continuous ranges. It is usually the quickest method for a formula that repeats down adjacent rows. For a very long list, double-clicking can save time, but verify where Excel stopped.
Use fill commands for a known range. Selecting the exact destination range and choosing Home > Fill > Down or Right makes the intended extent clear. It also avoids dragging past the last row you need.
Decide which references should move before filling. Relative references adjust, absolute references marked with dollar signs stay fixed, and mixed references lock either the row or the column. Plan for the direction you are copying: a reference designed for copying down may need different anchoring when copied across.
Use the Auto Fill Options button when Excel offers it. After dragging the fill handle, a small Auto Fill Options button may appear beside the filled range. Its choices vary with the operation. For formula copying, choose the option that copies cells if you want the formula and formatting, or the option that fills without formatting when you want to preserve destination formatting.
Keep a source formula in a clear, consistent row. In a structured list, put the formula at the top of the calculated column and fill only through rows that belong to the list. This makes it easier to audit the formula and notice an accidental gap.

Troubleshooting

The fill handle is missing. Check that the cell is selected and look at its lower-right corner. If the handle is unavailable throughout Excel, open File > Options > Advanced and, under Editing options, enable “Enable fill handle and cell drag-and-drop.” The exact display can vary slightly by Excel build. On Mac, check Excel > Preferences or Settings for the editing options; if you cannot find the setting, use copy and paste or the Home > Fill commands.

The formula did not fill as far as expected. If you used a double-click, Excel may have stopped at a blank in the neighboring column or at the end of its data. Drag the handle to the required final row, or select the full range yourself and use Home > Fill > Down. Confirm that the destination range includes the starting formula cell.

The results look wrong after copying. Select a destination cell and compare its formula with the source formula. Look for references that shifted to the wrong row or column. Add dollar signs to references that need to remain fixed, then fill again. If the formula text is correct but a result has not updated, check whether calculation is set to Automatic under Formulas > Calculation Options. You can also press F9 to recalculate the workbook on Windows; on Mac, use the recalculation command available for your keyboard and Excel version.

The destination shows the formula text instead of a result. The cell may be formatted as Text, or the formula may have been entered with an apostrophe before the equals sign. Change the cell format to General, then edit and re-enter the formula by pressing F2 and Enter on Windows. On Mac, use the equivalent edit-and-confirm keys for your keyboard. Check that “Show Formulas” is not turned on from the Formulas tab.

Formatting changed unexpectedly. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if the fill just happened and you have not made other changes since. Then repeat the fill and choose the Auto Fill option that excludes formatting, or use Home > Paste > Formulas after copying. Undo may not be available after closing the workbook or after certain other operations, so inspect the destination formatting before continuing.

Frequently Asked Questions

How do I copy a formula down an entire column?
Select the formula cell and double-click its fill handle to fill beside neighboring data, or select the complete range and press Ctrl+D on Windows. Review the bottom of the range because double-click filling can stop at a blank or the end of adjacent data.

How do I copy a formula without changing its references?
Make the references absolute by adding dollar signs to the row and column you want to lock. For example, $F$1 stays fixed when the formula is copied in any direction. Alternatively, copy the formula as text only when you specifically need identical formula text, and check that the resulting references still make sense.

Can I copy a formula to nonadjacent cells?
Yes. Copy the formula cell, hold Ctrl on Windows (or Command on Mac) while selecting separate destination cells or ranges, then paste. Excel may show a prompt or behave differently depending on the selected areas; if the selection is awkward, paste into each destination range separately and verify the adjusted references.

What is the difference between copying and filling?
Both can reproduce a formula, but filling is designed to extend content through a neighboring range. Copy and paste gives you more control over a distant or separate destination and offers paste choices such as formulas only. In either case, relative references can adjust to the destination location.

Can I copy a formula in Excel for the web?
Yes. Select the formula cell and use the fill handle, copy and paste, or the available Home ribbon fill commands. Some keyboard shortcuts may be intercepted by the browser, so use the ribbon or context menu if a shortcut does not work. Check the resulting formulas just as you would in the desktop app.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.