How to Copy Formulas in Excel on a MacBook Without Errors

To copy a formula in Excel on a MacBook, select the cell containing it, press Command+C, select the destination cell or range, and press Command+V. You can also drag the fill handle at the source cell’s lower-right corner to copy the formula into nearby cells. Excel adjusts relative references as it copies, so check the result when your formula uses specific cell references.

What You’ll Need

A MacBook with Excel for Microsoft 365 or a recent desktop version of Excel installed.
A workbook containing a formula you want to copy, plus the destination cell or cells where you want the results.
A keyboard, mouse, or trackpad. The steps below use Mac keyboard shortcuts; ribbon commands are available if a shortcut does not work with your keyboard setup.

Step-by-Step

Open the workbook and find the formula. Open your file in the Excel desktop app for Mac. Click the cell that already contains the formula. The formula bar above the worksheet displays the full formula, while the cell itself usually displays its calculated result. If you are unsure whether the selected cell contains a formula, click it and look for an equals sign at the beginning of the formula bar content.
Copy the source cell. Press Command+C. You should see a moving dashed outline around the copied cell. You can also choose Home > Copy on the ribbon, or use the Edit menu if you prefer menus. Leave the source selected until you have copied it; clicking elsewhere before copying would change which cell is selected.
Select the destination. Click the cell where the copied formula should go. To copy into a block of cells, select the whole destination range by dragging across it, or click the first cell and Shift-click the last cell. For example, if you are copying a formula from D2 into D3 through D10, select D3:D10 after copying D2. Avoid selecting the source cell as part of the destination unless you intend to overwrite or replace it.
Paste the formula. Press Command+V. Excel copies the cell contents and formatting, and normally adjusts relative references for the new location. The moving outline may remain around the copied source; press Escape when you are finished copying to clear that outline. Click a pasted cell and inspect the formula bar if you want to confirm how its references changed.
Check how relative references move. Suppose your worksheet has quantity in B2 and unit price in C2, with 4 in B2 and 12 in C2. The formula in D2 is =B2*C2, so D2 returns 48. When you copy D2 to D3, Excel ordinarily changes the references to B3 and C3, because they are relative references. That is usually useful when a formula calculates a result for each row. Check that the destination row contains the values the copied formula should use.
Fill a neighboring range by dragging. Select the formula cell, then move the pointer to the small square at the lower-right corner of its selection border. When the pointer changes to a small black plus sign, press and drag the fill handle down or across the cells to fill. Release when the outline covers the intended destination. This is convenient for a continuous column or row; look over the filled cells afterward to confirm that the formulas and references follow the pattern you intended.
Fill down or right with a command. For a vertical range, enter or copy the formula in the first cell, select that cell and the cells below it, then choose Home > Fill > Down. For a horizontal range, select the first formula cell and the cells to its right, then choose Home > Fill > Right. In Excel for Mac, Control+D fills down and Control+R fills right on supported keyboard setups. If a shortcut behaves differently on your Mac, use the ribbon command instead. The fill command copies the formula pattern from the first cell in the selected range.
Keep a reference fixed when needed. A copied formula does not always need every reference to move. For example, suppose B2 contains 4 and F1 contains a fixed rate of 1.1. If the formula in C2 is =B2*$F$1, it returns 4.4. When copied down, B2 changes to B3, but $F$1 stays fixed. The dollar signs make the column and row absolute. If you need this behavior, add the dollar signs to the reference in the formula bar before copying, then verify the copied formula still points to the intended fixed cell.
Copy a formula without copying its formatting. If you want to preserve the destination cells’ existing appearance, copy the source cell, select the destination, and open the Paste menu on the Home tab. Choose Formulas if that option is available in your Excel version. This pastes the formula rather than the source cell’s full formatting. If you want both formula and formatting, use the regular Command+V paste instead.

Common Mistakes

Copying a value instead of a formula: A cell may display a number even though it contains a formula. Click the cell and inspect the formula bar before copying. If the formula bar shows only a number or text, the cell may contain a fixed value, not a formula that will recalculate.
Expecting every reference to stay the same: Relative references change based on the destination. This is normal when filling a calculation down a list, but it can cause errors if a formula must keep pointing to one input cell. Use dollar signs for references that should remain fixed, and check a pasted formula before filling a large range.
Selecting the wrong destination range: Pasting over cells replaces their contents. Before you paste, confirm the selection border covers only the intended cells. If the destination contains important data, consider copying the workbook or saving a separate version first.
Dragging the cell border instead of the fill handle: The fill handle is the tiny square at the lower-right corner of the selected cell. Dragging from elsewhere on the border may move the cell rather than extend its formula. If the cells move unexpectedly, undo immediately with Command+Z and try again using the corner handle.
Filling through blank rows unintentionally: Double-clicking the fill handle may use adjacent data to decide how far to fill, and gaps or neighboring columns can affect the result. For a precise endpoint, drag the handle yourself or select the exact destination range and use Home > Fill > Down.

Tips

Use Command+C and Command+V for a quick one-time copy, and use the fill handle or Home > Fill commands when you need to extend a formula pattern through multiple rows or columns.
After filling a range, click a cell near the end of it and inspect the formula bar. Checking both the first and last destination formulas can reveal an incorrect reference pattern before you rely on the results.
Use mixed references when only part of a reference should remain fixed. For example, a dollar sign before the column letter fixes the column, while a dollar sign before the row number fixes the row. An ordinary reference with no dollar signs can adjust in either direction.
If a worksheet is formatted as an Excel table, entering a formula in a calculated column may cause Excel to fill it through that table column automatically. Review the resulting cells rather than filling the same column again without checking.
To copy a formula to a nonadjacent cell, use copy and paste rather than dragging. You can copy the source, click the distant destination, and paste; Excel adjusts relative references according to the distance and direction between the two cells.

Troubleshooting

The formula did not copy: Make sure the source cell was copied before selecting the destination. Try clicking the source, pressing Command+C, clicking one destination cell, and pressing Command+V. If the keyboard shortcut is intercepted by another Mac feature or does not respond, use Home > Copy and Home > Paste.
The copied result is wrong: Click the destination cell and inspect its formula bar. If a reference shifted when it should have stayed fixed, edit that reference to include the necessary dollar signs, then copy the corrected formula again. If a reference should shift but did not, check whether it has dollar signs that are locking its row or column.
The same result appears in every copied cell: Check whether the source formula contains absolute references, such as a reference with dollar signs before both the column and row. Absolute references are deliberately kept unchanged when copied. Remove the dollar signs from any reference that should move with each row or column.
The fill handle is missing: Confirm that you selected a cell, not an entire row or column, and look closely at the selection’s lower-right corner. If you still cannot use the handle, select the destination range and choose Home > Fill > Down or Home > Fill > Right. Ribbon commands provide an alternative when dragging is difficult with a trackpad.
Excel shows a formula instead of its answer: The cell may be formatted as Text, or formulas may be displayed across the worksheet. Check the cell’s number format and change it to General if it is set to Text; then re-enter the formula. Also check the Formulas tab for the Show Formulas setting, which toggles between displaying formulas and their calculated results.
The paste overwrote something: Press Command+Z immediately to undo the paste if it was the last action. If other edits have happened since, undo carefully and verify the worksheet after each step. When pasting a formula over a selected range, Excel replaces the contents of that range, so make the selection precise.

Frequently Asked Questions

What is the Mac shortcut for copying a formula in Excel?

Use Command+C to copy the formula cell, select the destination, and press Command+V to paste. These are the standard copy-and-paste shortcuts in Excel for Mac. You can also use the Home tab’s Copy and Paste commands.

Will copying a formula change its cell references?

Usually, yes. Relative references adjust to the formula’s new location. Absolute references, marked with dollar signs, stay fixed. Check the formula bar after copying if the difference matters to your calculation.

How do I copy a formula down a column on a MacBook?

Copy and paste into the cells below, drag the fill handle down, or select the source and destination range and choose Home > Fill > Down. Control+D can also fill down in Excel for Mac on supported keyboard setups.

Can I copy only the formula and not the cell formatting?

Yes. Copy the source cell, select the destination, then open the Paste menu on the Home tab and choose Formulas if that option is shown. This avoids applying the source cell’s full formatting to the destination.

Why does my formula show as text after I paste it?

The destination may be formatted as Text, or the formula may have been entered with a leading apostrophe. Set the cell format to General and re-enter the formula. If formulas are visible throughout the sheet, check whether Show Formulas is enabled on the Formulas tab.

Can I copy a formula to cells that are not next to each other?

Yes. Copy the formula cell, then select a separate destination and paste. Excel adjusts relative references based on the new cell’s position. For multiple distant destinations, paste into each one separately and inspect the references to make sure they still point where you intend.

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.