How to Copy Formula Down in Excel

What this does

Copying a formula repeats the logic while Excel adjusts relative cell references. A formula in C2 such as =A2*B2 becomes =A3*B3 when filled down to C3. Absolute references with dollar signs stay fixed, mixed references lock only the row or column, and Paste Special ▸ Formulas copies the formula without copying formatting. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “copy formula down in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected formula change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a workflow that saves repeating the same clicks every week useful in real work: repeatable, auditable, and not dependent on memory or luck.

A worked example

C2 contains =A2*B2 for quantity times price. Drag the fill handle from C2 to C20 and Excel writes =A3*B3, =A4*B4 and so on. If every row must multiply by a tax rate in F1, write =A2*B2*$F$1 before filling down so the F1 reference does not move. Fast, correct formula copying is core spreadsheet work. It turns one tested row into a reliable model and prevents subtle reference drift across hundreds of rows. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “copy formula down in excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.

Common mistakes

• Forgetting absolute references, so lookup tables, rates or assumptions shift while copying.
• Copying formatting along with formulas and accidentally changing the report style.
• Filling into rows with gaps, where double-clicking the fill handle may stop early.
• Pasting formulas over existing manual overrides without checking dependencies.

Frequently asked questions