Copy Formulas in Excel Across Rows: A Simple Guide

To copy a formula horizontally, select its cell and drag the small fill handle at the lower-right corner across the destination cells; to copy it down a column of rows, drag the handle downward. Excel adjusts relative cell references as it fills. You can also select the source and destination range and use Home > Fill > Right, or press Ctrl+R on Windows. First decide whether you want references to shift or stay fixed.

What You’ll Need

An Excel workbook with a formula already entered in a cell. Check that it calculates correctly before copying.
A clear destination range: the cells to the right for a horizontal fill, or below for a vertical fill.
Microsoft Excel for Microsoft 365 on Windows for the steps below. Excel for Mac has the same fill commands in the ribbon; its keyboard shortcuts can differ. Excel for the web also supports dragging the fill handle and using ribbon commands, though some interface details may vary.

Step-by-Step

Decide which direction you mean. Copying across a row means moving horizontally from one column to the next, such as from B2 toward C2, D2, and E2. Copying a formula down rows means moving vertically, such as from B2 to B3 and B4. The same fill-handle method works in either direction, but confirm the direction before you start so you do not overwrite neighboring data.
Check the source formula and its references. Click the cell that contains the formula and look at the formula bar. In a basic reference such as A2, Excel normally treats both the column and row as relative: they change when the formula is copied. A reference such as $A$2 is absolute and stays fixed. A mixed reference such as $A2 keeps column A fixed but allows the row number to change; A$2 keeps row 2 fixed but allows the column to change. Use the reference style that matches what each copied formula should calculate.
Try a small horizontal example. With 100 in A2 and a 10% increase intended in each cell, enter this in B2: =A2*1.1. B2 returns 110. Dragging the fill handle from B2 to C2 changes the reference to B2, so C2 returns 121. Continue to the right only if each new result should be calculated from the previous cell. If each month should instead refer to a separate source cell, build the formula around that layout before filling.
Locate the fill handle. Select the formula cell. A small square appears at the lower-right corner of the selected cell or range; this is the fill handle. Move the pointer over the square until it changes to a thin black cross. If you do not see the square, check Excel’s settings for the fill handle: go to File > Options > Advanced and, under Editing options, make sure Enable fill handle and cell drag-and-drop is selected. On Mac, look in Excel > Preferences or Settings > Edit, depending on the release.
Drag across the destination cells. Hold the left mouse button on the fill handle and drag right over the cells where you want the copied formulas. For a vertical fill, drag down instead. Release the button when the intended range is highlighted. Excel fills the selected cells and adjusts relative references for each position. If a small Auto Fill Options button appears beside the filled range, you can use it to choose a different fill behavior, such as copying cells or filling without formatting.
Use Fill Right when you want a precise horizontal range. Select the source formula cell and all the cells to be filled, with the source at the left edge of the selection. Choose Home > Fill > Right. On Windows, Ctrl+R fills the selected range from its leftmost cell to the right. For example, select B2:F2 when B2 contains the formula. On Mac, use Home > Fill > Right if the Windows shortcut does not apply to your keyboard setup. To fill downward, select the source and cells below it, then choose Home > Fill > Down; Ctrl+D is the Windows shortcut.
Check the copied formulas and results. Click a few filled cells and inspect the formula bar. Confirm that references moved by the intended number of columns or rows and that fixed references stayed fixed. Compare the results with a hand-calculated example or known total. If the fill changed formatting you did not want, use the Auto Fill Options button or undo immediately with Ctrl+Z on Windows; on Mac, use Command+Z.

For a vertical example, suppose B2 contains 3 items and C2 contains a price of 12, with the next rows holding the corresponding quantities and prices. Enter =B2*C2 in D2; it returns 36. Fill D2 down one row and Excel changes the formula to use B3 and C3. If the next row contains 4 and 12, D3 returns 48. This is the usual pattern for calculating a result separately for each record.

When every copied formula must use one constant cell, lock that reference before filling. With an amount in A2 and an 8% rate in F1, enter =A2*(1+$F$1) in B2. If A2 is 100 and F1 is 8%, the result is 108. Copying to the right or down keeps F1 fixed, while A2 adjusts. To add or remove dollar signs while editing a reference, select the reference in the formula bar and press F4 on Windows; on some laptops you may need Fn+F4. Mac keyboards and Excel settings vary, so typing the dollar signs directly is a reliable alternative.

Common Mistakes

Filling in the wrong direction: Dragging right changes column references; dragging down changes row references. A formula that is correct when copied down may not make sense when copied sideways. Check the intended layout first, especially if adjacent cells contain input data.

Forgetting to lock a constant: If each result should use the same tax rate, exchange rate, or target stored in one cell, an ordinary reference will shift as the formula fills. Make that reference absolute with dollar signs. Conversely, locking every reference can make copied formulas repeatedly point to the original row or column, producing repeated or incorrect results.

Overwriting existing information: Filling replaces the contents of destination cells. Before dragging, verify the selected range and make sure it does not include notes, values, or formulas you need. If you accidentally overwrite something, undo before making other edits.

Copying formatting unintentionally: A normal fill can carry formats as well as formulas, such as borders, number formats, or shading. Use the Auto Fill Options control after filling to choose Fill Without Formatting where available, or copy formulas through Home > Paste > Formulas when you want to preserve the destination formatting.

Tips

Use the formula bar or press F2 to inspect a source formula before filling. On Windows, F2 edits the selected cell; Mac keyboards may require the Fn key or a different function-key setting. Press Esc if you only meant to inspect the formula and do not want to change it.

When you have a long, uninterrupted list to fill down, double-click the fill handle instead of dragging. Excel generally fills down alongside the neighboring column’s data. This is convenient for a continuous list, but it may stop early or fill farther than expected if the adjacent column has blanks or a different length. Check the final row afterward. Double-click fill is primarily useful vertically; for a horizontal row, drag or use Fill Right.

If you want formulas but not the source cell’s formatting, copy the source, select the destination, then use Home > Paste > Formulas. On Windows, Ctrl+C and Ctrl+V copy and paste; on Mac, use Command+C and Command+V. The Paste dropdown lets you choose the formulas-only option. Pasting formulas still adjusts relative references according to the destination cells.

For repeated calculations in a structured list, consider converting the range to an Excel table with Insert > Table. A formula entered in a table column often fills down that calculated column automatically when the table expands. This is useful for records added over time, but it is not a substitute for checking whether horizontal copying is appropriate for your sheet.

Do not use a fill operation to extend a dynamic-array formula into cells where it is already spilling. Dynamic-array results occupy a spill range automatically, and typing or filling into that range can produce a #SPILL! error. Also note that a sheet protected against editing may prevent filling cells unless the relevant cells are unlocked or the sheet permissions allow the change.

Troubleshooting

The fill handle is missing: Check the fill-handle setting described in Step 4. If the worksheet is protected, unprotect it if you have permission. Also make sure you selected a normal cell rather than a chart, shape, or table object.

The formula appears unchanged or returns an unexpected value: Click the destination cell and inspect its formula bar. If a reference should have moved but did not, it may contain dollar signs. If a reference moved but should have stayed fixed, make it absolute. Also verify the order of the selected range when using Fill Right or Fill Down: the original formula needs to be at the top or left edge.

The cell displays the formula instead of its result: The cell may be formatted as Text, or the formula may have a leading apostrophe. Change the cell format to General, then re-enter the formula or press F2 and Enter. If formulas are showing throughout the sheet, toggle Show Formulas from the Formulas tab. On Windows, Ctrl+` toggles this display; the key is usually above Tab and may vary by keyboard.

The result looks stale: Excel may be set to manual calculation. Choose Formulas > Calculation Options > Automatic, then recalculate if needed. Check the source values and number formats too: a value displayed as a rounded number can still contain more decimal places than it shows.

Excel refuses to fill the destination: Check for merged cells, protected cells, or a dynamic-array spill range in the target area. Unmerge cells only if doing so fits the sheet layout, or choose a clear destination range. If a fill overwrote valid data, use Undo immediately, then repeat with a narrower selection.

Frequently Asked Questions

How do I copy a formula across a row without dragging?
Select the source formula and the cells to its right, keeping the source at the left edge. Choose Home > Fill > Right. In Excel for Windows, Ctrl+R is the shortcut for Fill Right.

How do I copy a formula down several rows?
Select the formula cell and the destination cells beneath it, then choose Home > Fill > Down or press Ctrl+D on Windows. You can also drag the fill handle downward. Check that the formula references update for each row.

Why does a copied formula change its cell references?
Excel adjusts relative references to match the formula’s new position. This is expected behavior. Use dollar signs to lock a row, a column, or both when a reference must remain fixed.

Can I copy only the formula and keep the destination formatting?
Yes. Copy the source, select the destination, and choose Home > Paste > Formulas. The destination’s formatting is retained, while references adjust to the new location.

Will copying a formula also copy its displayed result?
Normally Excel copies the formula, not a fixed result, so the destination recalculates using its own references. To paste a static result instead, use the Paste Values option. That replaces the formula with its current value, so use it only when you no longer need the destination to update.

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.