How to Copy Formulas Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to copy a formula down a column in Excel.

Quick summary

Copying formulas in Microsoft Excel lets you instantly apply the same calculation across multiple rows by using the fill handle or a double-click shortcut, saving time and reducing manual data entry errors.

Steps

Select the cell containing the formula (e.g., G3), then hover over its bottom-right corner until the cursor changes to a plus sign.
Click, hold, and drag the fill handle down through the rows where you want to copy the formula, then release the mouse button.
Alternatively, double-click the fill handle with the left mouse button to copy the formula automatically.
Excel will automatically fill the formula down the column to match the adjacent data in the neighboring column.

📌 Why this matters

Knowing how to copy formulas down a column in Microsoft Excel is a foundational productivity skill that eliminates repetitive manual entry across large datasets. Using the fill handle or double-click shortcut, users can instantly apply consistent calculations to hundreds of rows in seconds. This technique ensures formula accuracy, reduces human error, and is essential for anyone working with structured data, financial models, or reporting spreadsheets. Mastering Excel formula copying helps teams work faster and maintain data integrity across their workbooks.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel