How to Carry a 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. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “carry a formula down in excel”. Start on a copy or a tiny sample, keep the affected formula visible, and compare the result with the outcome you expected before you touch the real workbook. 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. The point is a calculation you can defend to a CFO or an auditor, but the practical win is that someone else can open the file and understand what happened without asking you.

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. A practical tip: try it on a copy of the sheet or a handful of sample rows first and check the result before you apply it to the real data. That one habit catches almost every surprise while it is still cheap to reverse.

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. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. Treat “carry a 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