Copy Formula in Excel Without Dragging: 6 Ways

To copy a formula in Excel without dragging, copy and paste it, use Ctrl+D to fill down, or use Home > Fill commands. For a short column beside data, double-click the fill handle; for a row, Ctrl+R fills right. These methods work in Excel for Microsoft 365 on Windows and let you choose how far the formula should go.

Before copying, check that the formula is correct in its first cell and decide whether its cell references should change as it moves. The methods below cover columns, rows, menu commands, and entering one identical formula in several cells.

What You’ll Need

A workbook open in Excel, with the formula you want to copy.
A destination range where it is safe to place the copied formula. Existing values or formulas in that range can be overwritten.
For the example below, assume quantities are in B2:B4, unit prices are in C2:C4, and you want totals in column D. In D2, enter =B2*C2. With 3 in B2 and 4.50 in C2, the result is 13.50.

Step-by-Step

Check the source formula and destination. Select the cell containing the formula and read it in the formula bar. Confirm that it calculates the intended result, then identify the last cell or range that needs a copy. In the example, D2 contains the first row’s total, and D3:D4 are the destination. Keep the source cell in place; most fill methods use it as the starting point.
Copy and paste for a specific destination. Select the source formula cell and press Ctrl+C on Windows. Select the destination cell or range, then press Ctrl+V. For the example, copy D2, select D3:D4, and paste. Excel normally adjusts relative references for each row, so the formula in D3 refers to B3 and C3, while the formula in D4 refers to B4 and C4. Press Esc after pasting if the animated copy border remains and you want to clear it.
Use Ctrl+D to fill a column down. Select the range from the formula cell through the last cell to fill, including the source at the top. For example, select D2:D4, then press Ctrl+D. Excel fills the selected cells below the top cell using its formula and adjusts relative references row by row. This is often the quickest choice for a continuous block in one column. Make sure the selection starts with the correct source formula; otherwise, Excel will copy from the wrong cell.
Use Ctrl+R to fill across a row. Put the formula in the leftmost cell, select that cell and the cells to its right, then press Ctrl+R. Excel copies the leftmost cell across the selection and updates relative column references. For example, if a formula in F2 refers to cells in column B, filling right through H2 adjusts the relative references for columns G and H. Use this for horizontal calculations rather than selecting each destination individually.
Use the Fill command on the ribbon. Select the source cell and the cells below it. On Windows, go to Home > Editing > Fill > Down. For a horizontal range, select the source cell at the left plus the cells to fill, then choose Home > Editing > Fill > Right. The menu does the same kind of fill as Ctrl+D or Ctrl+R, so the top cell supplies the formula for a downward fill and the leftmost cell supplies it for a rightward fill. This option is useful when you do not remember the shortcut.
Double-click the fill handle for an adjacent list. Select the formula cell and point to the small square at its lower-right corner. When the pointer becomes a thin black plus sign, double-click. Excel uses nearby continuous data to estimate how far down to fill the formula. In the example, a populated list in column B or C can provide the stopping point for a formula in D2. This is not dragging, but it does depend on suitable neighboring data, so inspect the last filled row afterward.
Use Ctrl+Enter to enter the same formula in multiple cells. Select the cells that should contain the formula, type the formula, and press Ctrl+Enter instead of Enter. Excel places the same formula entry in every selected cell. This is useful when each cell should deliberately refer to the same fixed location, or when the formula has no row-specific references. It is not equivalent to filling down: relative references are not adjusted separately for each cell. If you need changing row references, use Ctrl+D or copy and paste instead.

On a Mac, use Command+C and Command+V for copying and pasting. Excel for Mac also supports Control+D for Fill Down and Control+R for Fill Right; the Home tab’s Fill commands are available if a shortcut behaves differently with your keyboard setup. In Excel for the web, the ribbon commands can be a dependable alternative when browser shortcuts conflict.

Common Mistakes

Filling the wrong range: Ctrl+D uses the top cell in the selected range, and Ctrl+R uses its leftmost cell. Include the intended source and check that the selection ends at the right row or column.
Expecting every reference to stay fixed: Ordinary references such as B2 move when a formula is copied. To keep a reference fixed, use dollar signs. For example, assuming B2:B4 contains quantities and F1 contains a fixed multiplier of 1.1, the formula in C2 can be =B2*$F$1. Copying it down changes B2 to B3 and B4 while keeping F1 fixed. With B2 equal to 3, the result in C2 is 3.3.
Using Ctrl+Enter for a changing calculation: It puts the same formula entry in every selected cell. If each row should refer to its own inputs, fill or paste the formula instead.
Overwriting data or formatting: Copy and paste and Fill commands can replace existing cell contents, and they may also copy formatting. Check the destination first, especially in a shared or established worksheet.
Copying when you meant to move: Ctrl+C makes a copy. Cutting with Ctrl+X moves cell contents and can change references elsewhere, so do not use it if the original formula must remain.

Tips

Choose the method by shape: Ctrl+D for a column, Ctrl+R for a row, and copy and paste when you want to specify the destination directly.
Use absolute references, such as $F$1, for a rate or constant that should not shift. A reference like B$2 keeps row 2 fixed but lets the column change; $B2 keeps column B fixed but lets the row change.
After filling, select one of the new cells and inspect the formula bar. This quickly confirms that references shifted as intended and that the formula reached the correct rows.
If a table has a consistent calculated column, enter the formula in the table column and Excel may extend it automatically to other rows. Check the result, since automatic behavior can depend on the workbook’s settings and the table structure.
For long lists, filter or sort the data only after checking that the formula range covers the intended records. A fill operation copies through the selected range; it does not decide which rows are meaningful.
Save before making a large change if the workbook is important. Ctrl+Z can undo many fill and paste actions, but a quick check before the operation reduces the chance of replacing valuable data.

Troubleshooting

The formula did not fill to the last row: If you double-clicked the fill handle, check for blank cells or breaks in the adjacent data that Excel used to determine the fill length. Select the exact destination range and use Ctrl+D or Home > Editing > Fill > Down instead.

Every copied row shows the same result: The formulas may contain fixed references, or the cells may have been filled with Ctrl+Enter. Select a result cell and inspect its formula. If the references should move by row, replace unnecessary dollar signs or repeat the operation with Ctrl+D or copy and paste from the correct source.

The results look wrong after copying: Check whether the formula uses relative, absolute, or mixed references as intended. For example, a reference to a fixed rate should usually have dollar signs around both its column and row. Also check that the source formula points to the intended input cells and that the destination cells are on the expected rows.

Excel refuses to fill or paste: Confirm that the sheet is not protected against editing and that the destination does not contain merged cells that conflict with the selected range. If a paste operation is active, press Esc and select the range again. You can also try the ribbon’s Fill command, which avoids some shortcut conflicts.

A shortcut opens something else or does nothing: On Windows, Ctrl+D fills down and Ctrl+R fills right in Excel, but browser shortcuts or a different app can intercept keys in some circumstances. Use Home > Editing > Fill > Down or Right. On Mac, use the corresponding Control key shortcuts for Fill and Command for copy and paste.

Frequently Asked Questions

What is the fastest way to copy a formula down in Excel?
Select the formula cell and the cells below it, then press Ctrl+D. Include the source formula at the top of the selection. For a nearby continuous list, double-clicking the fill handle can be faster because Excel estimates the ending row.

Can I copy a formula without changing its cell references?
Yes. Use absolute references by adding dollar signs to the row and column you want to hold still, such as $F$1. When you copy a formula, relative references can still adjust while that absolute reference remains fixed.

How do I copy a formula across columns without dragging?
Place the formula in the leftmost cell, select it together with the destination cells to its right, and press Ctrl+R. You can also use Home > Editing > Fill > Right.

Does copying a formula also copy its formatting?
Standard copy and paste can copy both the formula and cell formatting. Fill commands can also copy formatting from the source. If you need only the formula, use Paste Special and choose Formulas; on Windows, open the Paste Special options from Home > Paste or right-click the destination and choose Paste Special.

Why does double-clicking the fill handle stop early?
Excel looks at adjacent data to decide how far the formula should extend. A blank or interrupted neighboring column can make it stop before the end you expected. Select the full destination range yourself and use Ctrl+D when you need an exact endpoint.

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.