How to Copy Formulas in Excel by Dragging the Fill Handle

To copy a formula in Excel by dragging, select the cell with the formula, point to the small square at its lower-right corner, then drag the fill handle across or down the cells you want to fill. Excel copies the formula and adjusts relative cell references for each destination. Before you start, check that the cells you plan to fill are clear, because filling them can replace existing contents.

What You’ll Need

An Excel workbook with a formula already entered in a cell.
A destination range where you want the copied formula to appear.
A visible fill handle. In Excel for Microsoft 365 on Windows, it is the small square at the bottom-right corner of the selected cell.

You do not need a special tool or add-in. The instructions below apply to Excel for Microsoft 365 on Windows. The fill handle works similarly in Excel for Mac and Excel for the web, although the ribbon and settings can look different.

Step-by-Step

Set up your source formula. Choose a cell that contains the calculation you want to repeat. For example, with quantities in A2:A20 and unit prices in B2:B20, enter the formula in C2. If A2 contains 3 and B2 contains 12, the formula returns 36:

With quantity in A2 and unit price in B2, enter this in C2: =A2*B2

Make sure the formula is correct in the first row before copying it. Check that it points to the intended input cells and returns a sensible result. Dragging repeats the formula pattern; it does not check whether the calculation itself is right.
Select the cell with the formula. Click C2 in the example. You should see a border around the selected cell, and the formula should appear in the formula bar. If you are still editing the formula, press Enter first, then select the cell again. The fill handle appears only when the cell is selected and you are not actively typing inside it.
Locate the fill handle. Look at the bottom-right corner of the selected cell’s border. A small square sits there. Move the pointer over that square until the pointer changes to a thin black plus sign. Do not grab the middle of the cell border; dragging the border can move the cell instead of copying its contents.
Drag through the destination cells. To fill down, press and hold the mouse button on the handle, drag from C2 to the last cell you need, such as C20, and release. To fill across, drag to the right or left instead. The selected range usually becomes outlined or shaded during the drag. Include the final destination cell in the range before releasing.
Check the copied formulas and results. Click one of the filled cells, such as C3. Since the references in the example are relative, Excel adjusts the formula to the new row. With quantity in A3 and unit price in B3, the formula in C3 becomes =A3*B3. If A3 contains 5 and B3 contains 8, C3 returns 40. Check the first, a middle, and the final filled row to confirm the references follow the intended pattern.
Use the fill options if the appearance changes. After filling, Excel may show an Auto Fill Options button beside the range. Select it if you want to choose how the fill behaves or adjust the formatting. Depending on the workbook and version, options can include copying cells, filling without formatting, or filling a series. The formula and the cell’s appearance are separate concerns: a copied formula can be correct even if the number format or border is not what you want.
For a long column, try a double-click. If the formula is beside a continuous column of data, you can double-click the fill handle instead of dragging to the bottom. Excel uses the neighboring data to estimate how far to fill. For example, if C2 contains the formula and B2:B20 has uninterrupted entries, double-clicking C2’s fill handle will commonly fill the formula down alongside that data. Inspect the last filled row: blank cells in the neighboring column can cause Excel to stop early, and the result depends on the surrounding layout.

Dragging down or across applies the same basic rule: references that are relative move with the formula, while fixed references stay anchored. With a tax rate of 8% in F1 and a subtotal in C2, the following formula in D2 returns 2.88 when C2 is 36 and is intended to keep using F1 as it is filled down:

With subtotals in C2:C20 and the tax rate in F1, enter in D2: =C2*$F$1

The dollar signs make F1 an absolute reference. When you drag D2 down, C2 changes to C3, C4, and so on, but $F$1 remains fixed. If you omit the dollar signs, the tax-rate reference can shift to another cell as the formula is filled.

Common Mistakes

Dragging the cell border instead of the handle. The fill handle is the tiny square in the lower-right corner. If the pointer looks like a four-headed arrow or the cell moves, undo the action and try again directly on the square.
Using relative references for a value that should stay fixed. Excel normally adjusts references when a formula moves. This is useful for row-by-row calculations, but a tax rate, commission rate, or other shared input may need an absolute reference such as $F$1. Decide which references should move before filling.
Filling the wrong range. A drag that ends one row too soon leaves a blank result; one that goes too far can put formulas in unused rows or overwrite existing data. Check the range outline while dragging and review the last destination cell afterward.
Assuming formatting will stay unchanged. The fill operation can carry formatting as well as the formula. A destination cell might inherit a border, color, or number format from the source. Use Auto Fill Options or format the cells separately if the result looks different from the original range.
Expecting a double-click to find every row. Excel’s double-click fill uses nearby data to estimate the end of the range. A gap or an empty neighboring column can make it stop before the bottom of your list. Drag to a specific endpoint when you need more control.

Tips

Keep the source formula in the first row of the data and copy it down from there. This makes it easier to compare each row’s inputs with its result.
Use relative references for values that should change by row or column, absolute references for values that must stay put, and mixed references when only the row or column should remain fixed. For example, $A2 fixes column A but allows the row to change; A$2 fixes row 2 but allows the column to change.
For a formula that should fill exactly to the last record, select that endpoint carefully rather than relying on double-clicking. You can also select the source and destination cells, then use Home > Fill > Down for a vertical fill. That is an alternative to dragging, not a requirement.
Use Ctrl+Z on Windows to undo an unintended fill. On Mac, use Command+Z. Undo promptly if the fill replaced data, then verify the original values have returned.
If you are working in an Excel table, entering a formula in a calculated column may cause Excel to fill the formula through the column automatically. Review the resulting rows; you may not need to drag the handle in that situation.

Troubleshooting

The fill handle is missing. In Excel for Microsoft 365 on Windows, go to File > Options > Advanced. Under Editing options, make sure Enable fill handle and cell drag-and-drop is selected, then choose OK. Select a worksheet cell again. On Mac or in Excel for the web, settings and available controls differ by version; check that you have selected one cell and are not editing its contents.

The formula appears unchanged in every filled cell. Check whether the formula uses absolute references, which have dollar signs before the column and row, such as $A$2. Those references are designed not to move. If only one part should stay fixed, revise the reference type in the source formula and fill again. Also confirm that Excel is calculating formulas rather than displaying formula text: if the cell shows the formula characters, check the cell’s number format and whether a leading apostrophe was entered.

The result is wrong even though the formula copied. Select a filled cell and inspect its formula bar. Compare its references with the row or column it belongs to. A reference that shifted unexpectedly may need dollar signs; one that stayed fixed may need to be relative. Also check for blank or unexpected source cells and confirm the formula in the original cell returns the right result.

The drag moves the cell or does nothing. Make sure the pointer is on the tiny lower-right square, not the cell’s edge or center. If cell dragging is disabled, enable the fill-handle setting described above. If the worksheet is protected or the destination cells are merged, Excel may prevent the fill; unprotect the sheet if you have permission and avoid merged destination cells.

The fill stops too soon or goes too far. For a manual drag, undo if necessary and repeat while watching the range outline, releasing on the intended last cell. For a double-click, use a continuous neighboring data column or drag to the endpoint yourself. If existing values were replaced, use Undo immediately and confirm they are restored before trying again.

Frequently Asked Questions

Does dragging copy the formula or the displayed result?
It copies the formula, not just the displayed value. Excel recalculates it in each destination cell, using adjusted references where appropriate. If you need fixed results rather than formulas, copy the range and use Paste Special > Values.

Why do cell references change when I drag a formula?
References are relative by default, so Excel updates them to match the formula’s new position. For a reference that must stay fixed, add dollar signs to make it absolute, such as $F$1. Mixed references can lock only the row or column.

Can I drag a formula horizontally as well as vertically?
Yes. Drag the fill handle to the left or right to fill across columns. Check the resulting references because Excel adjusts relative column references as well as row references.

Can I copy a formula into nonadjacent cells by dragging?
Dragging fills a continuous range from the source cell to the endpoint. For separate, nonadjacent cells, copy the formula and paste it into each target, or fill each continuous section separately. Check the adjusted references in every section.

Will dragging copy the cell’s formatting too?
It can. If the formula is correct but the format is not, use the Auto Fill Options button when it appears to choose a fill behavior, or apply the desired number format and styling to the destination cells afterward.

Can I use the fill handle in Excel for Mac or the web?
Yes, the same general method is available in current Excel for Mac and Excel for the web: select the formula cell and drag its fill handle. The interface and settings for enabling the handle can vary, so use the ribbon or application settings available in your version if it is not visible.

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.