Copy a Formula in Excel: Keyboard Shortcuts

To copy a formula in Excel on Windows, select its cell and press Ctrl+C, select the destination cell or range, then press Ctrl+V. To copy the top cell’s formula down a selected range, use Ctrl+D; to fill to the right, use Ctrl+R. These shortcuts copy formulas quickly, and Excel adjusts relative cell references when you use standard copy-and-paste or fill commands.

What You’ll Need

A workbook open in Microsoft Excel for Microsoft 365 on Windows, with a formula already entered in a cell.
A clear destination cell or range. If you want references such as B2 to change to B3 as a formula is copied down, make sure the formula uses relative references where appropriate.
On a Mac, use Command+C and Command+V for standard copy and paste. Fill commands may use Control+D and Control+R; if a shortcut is intercepted by macOS or differs on your keyboard, use the Home ribbon commands described below.

Step-by-Step

Find a working formula. Click the cell containing the formula you want to reuse. Check the formula bar above the worksheet to confirm that you selected the formula cell, rather than a nearby result, label, or blank cell. For a simple example, assume prices are in B2:B10, quantities are in C2:C10, and the total for the first item belongs in D2. With a price of 12 in B2 and a quantity of 3 in C2, enter =B2*C2 in D2; the result is 36. This example assumes those cell locations and values.
Choose the copying method that fits your layout. Use Ctrl+C and Ctrl+V when copying to a different or non-adjacent location, or when you want to decide exactly where the formula goes. Use Ctrl+D when the formula is at the top of a contiguous range and you want to fill downward. Use Ctrl+R when the formula is in the leftmost cell and you want to fill right. These fill shortcuts work on a selected range, so select the full destination area before pressing the shortcut.
Copy and paste a formula to one cell. With the formula cell selected, press Ctrl+C. A moving dashed border usually appears around the copied cell. Click the destination cell and press Ctrl+V. Excel pastes the formula and, for ordinary relative references, shifts the references according to the destination. In the example, copying D2 to D3 changes the row reference so the next total uses the values in row 3.
Copy and paste to several cells. Select the formula cell and press Ctrl+C. Then select the destination range, such as D3:D10, and press Ctrl+V. Excel places a copy in each selected cell. Check the first and last results, especially if the range includes a subtotal, blank row, or a different type of data. If the destination range includes cells you need to keep, select only the intended cells instead of pasting across them.
Fill a formula down with Ctrl+D. Select the range that starts with the cell containing the formula and extends through the cells to fill. For example, select D2:D10 when D2 has the formula and D3:D10 are blank. Press Ctrl+D. Excel copies the top cell down through the rest of the selection, adjusting relative references row by row. On the ribbon, the equivalent command is Home > Fill > Down. On Mac, try Control+D; if that key combination does not work in your Excel setup, use the ribbon command.
Fill a formula to the right with Ctrl+R. Select a range that begins with the formula cell on the left and extends across the cells to fill, then press Ctrl+R. Excel copies the leftmost cell across the selection. For example, if a formula is in B5 and you select B5:E5, the fill copies it into C5:E5 and adjusts relative column references. The ribbon equivalent is Home > Fill > Right. On Mac, try Control+R or use the ribbon if the shortcut conflicts with your setup.
Use the formula-from-above shortcut only when you want an exact copy. In Excel for Windows, Ctrl+’ (the apostrophe key) copies the formula from the cell directly above into the active cell. This is handy for a single cell directly below a formula. Unlike filling down, this shortcut copies the formula as written; it does not make the usual relative-reference adjustment. If each row needs to refer to its own data, use Ctrl+D or copy and paste instead. The shortcut may vary with keyboard layout; on a Mac, use copy and paste or the fill command if you cannot enter it reliably.
Finish the copy and check the result. Press Esc to remove the moving copy border when you are done. Click one or two destination cells and inspect their formulas in the formula bar. Confirm that the references point to the intended row or column and that the displayed results make sense. If a copied formula shows an error or an unexpected value, undo immediately with Ctrl+Z and review the reference types and selected range before trying again.

Common Mistakes

Confusing copying with filling: Ctrl+’ copies the formula from directly above without the normal relative-reference shift. Ctrl+D fills a selection and adjusts relative references. For a column of row-by-row calculations, Ctrl+D is usually the better shortcut.

Selecting the wrong range: Ctrl+D takes the content of the top cell in the selected range and fills downward. If you accidentally include a heading or an existing result at the top, that content may be copied over the cells below it. Before using a fill shortcut, check both the first and last cells in the selection.

Overlooking absolute references: A dollar sign locks a reference when a formula is copied. For instance, references written with dollar signs stay fixed in the specified row or column, while ordinary relative references move with the copied formula. That is useful for a constant such as a tax rate, but a reference that was locked accidentally may make every copied calculation use the wrong input.

Pasting over existing work: Ctrl+V replaces the contents of the selected destination cells. If those cells contain formulas or important entries, undo the paste with Ctrl+Z and select a smaller destination range. Pasting a copied cell may also bring formatting along, so check the appearance as well as the calculations.

Expecting a formula to appear but seeing a number: The destination may be formatted to display a result, and that is normal. Click the cell and look at the formula bar to verify that the formula is there. If the cell shows the formula text instead, check whether the cell is formatted as Text or whether the formula was entered with a leading apostrophe.

Tips

For a contiguous column, enter and verify the first formula, select from that cell through the last destination, and press Ctrl+D. This avoids copying each row individually.
Double-click the small fill handle at the lower-right corner of a formula cell to fill down alongside a neighboring column of data. Excel uses the adjacent data to determine how far to fill; inspect the bottom of the filled range because gaps in the neighboring data can affect the result.
Use F4 while editing a cell reference in a formula to cycle among relative, absolute, and mixed reference styles. The exact sequence helps when you need one part of a reference to stay fixed as the formula is copied.
If you need to copy a formula without carrying over the source cell’s formatting, use Paste Special. Copy the formula, select the destination, then choose Home > Paste > Formulas. This pastes formulas rather than the full cell contents and formatting.
For a non-adjacent destination, copy the formula cell, hold Ctrl while selecting the other destination cells, and paste if your selection is accepted by Excel. For a more predictable result, paste into each destination separately or use a contiguous helper range.
On a laptop, you may need to hold the Fn key to use function keys, but Ctrl+C, Ctrl+V, Ctrl+D, and Ctrl+R do not require a function key. If a shortcut triggers another application or operating-system action, use the ribbon command rather than assuming the formula or workbook is at fault.

Troubleshooting

The formula did not copy: Confirm that the source cell was copied before you selected the destination. If the moving dashed border disappeared, press Ctrl+C again and paste. If you are filling, verify that the selected range includes the original formula cell at the top for Ctrl+D or at the left for Ctrl+R.

The copied result is wrong: Click the destination and inspect the formula bar. If the cell references moved when they should have stayed fixed, edit the source formula to use the appropriate absolute or mixed references, then copy it again. If the references did not move but should have, you may have used Ctrl+’; undo and use Ctrl+D, Ctrl+R, or standard copy and paste.

The cell displays the formula as text: Select the cell and check Home > Number Format. If it is set to Text, change it to General, then edit the cell and press Enter so Excel evaluates the entry. Also remove any apostrophe typed before the equals sign. Changing the format alone may not convert a formula that Excel already stored as text.

The shortcut does something else: Check that Excel has focus and that you are not typing inside a cell or dialog box. On a Mac, standard copying uses Command+C and Command+V, while fill shortcuts may depend on the keyboard setup. In Excel for the web, browser shortcuts can sometimes interfere; use Home > Fill > Down or Home > Fill > Right instead.

The filled cells have unexpected formatting: Undo, then try Home > Paste > Formulas for a paste operation, or use the fill command and check the result. When copying to a different area, Paste Special options can separate formulas from formatting. If you have already continued editing, review the affected cells carefully before making further changes.

Frequently Asked Questions

What is the fastest shortcut to copy a formula in Excel?
For a simple copy, use Ctrl+C, select the destination, and press Ctrl+V. For a formula at the top of a selected column range, Ctrl+D is often faster because it fills all selected cells at once.

Does copying a formula change its cell references?
Usually, yes. Standard copy and paste, Ctrl+D, and Ctrl+R adjust relative references based on the destination. Absolute references with dollar signs remain fixed. Ctrl+’ copies the formula from above without the usual reference shift.

How do I copy a formula down without dragging?
Select the formula cell and the blank cells below it, then press Ctrl+D. The formula cell must be the top cell in the selection. You can also choose Home > Fill > Down.

How do I copy a formula across a row?
Select the formula cell and the cells to its right, then press Ctrl+R. The formula must be in the leftmost cell of the selection. Use Home > Fill > Right if the shortcut is unavailable.

What is the Excel shortcut for copying a formula from the cell above?
On Windows, press Ctrl+’ (apostrophe) to copy the formula from the cell directly above into the active cell. It is best for an exact repeat; use Ctrl+D when relative references need to change for the new row.

Do these shortcuts work in Excel for Mac?
Copy and paste use Command+C and Command+V on Mac. Fill commands may use Control+D and Control+R, but shortcuts can differ by keyboard layout and Excel setup. The Home > Fill commands are a reliable alternative when a shortcut does not work.

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.