Dragging the Fill Handle

Once you write a formula, you rarely want to retype it for every row. The fill handle lets you copy a formula across many cells in seconds.

Select a cell and look at its bottom-right corner. You will see a tiny green square. That square is the fill handle. When you hover over it, your cursor changes from a thick white plus to a thin black plus.

Dragging that black plus copies the formula to wherever you drag.

Imagine a simple order sheet. Column A has quantities and column B has unit prices. You want column C to show the total for each row.

• A2 = 3, B2 = 10
• A3 = 5, B3 = 4
• A4 = 2, B4 = 25

In C2 you write a formula to multiply quantity by price. You only want to type it once, then fill it down to C3 and C4.

Click cell C2 and type =A2*B2, then press Enter. The cell shows 30 (3 times 10).

This single formula is your template. The fill handle will copy its pattern down the column, not just the number 30. That is the key idea: you are copying the recipe, not the result.

Click C2 again so it is selected. Move your mouse to the small square at the bottom-right corner until the cursor becomes a thin black plus.

Now click and hold, drag straight down to C4, and release.

Excel and Google Sheets instantly fill C3 and C4 with copied formulas. C3 becomes 20 and C4 becomes 50. You wrote one formula and got three correct answers.

Dragging is fine for a few rows, but tedious for hundreds. There is a faster trick.

Select C2, then double-click the fill handle. The formula fills down automatically, stopping where the data in the neighboring column (column A or B) ends.

This is the go-to method for long lists. No scrolling, no precise dragging. The spreadsheet detects the bottom of your data and fills exactly that far.

The fill handle works sideways too. Suppose row 1 holds monthly budgets in B1, C1, D1 and you want each multiplied by 1.1 in row 2.

Type the formula in B2, then drag the fill handle to the right across C2 and D2.

Each cell gets its own copy, pointing at the column directly above it. Filling right shifts the column letters; filling down shifts the row numbers.

The fill handle is just a friendly shortcut. You can get identical results with copy and paste.

• Click C2 and press Ctrl+C (Cmd+C on Mac).
• Select C3:C4.
• Press Ctrl+V (Cmd+V).

The formula is copied and adjusts for each row exactly as dragging would. Use whichever method feels natural.

You can also fill without touching the mouse. Select the cell with your formula plus the empty cells below it, all in one selection. For example, highlight C2:C4 with C2 holding the formula.

Then press Ctrl+D to fill down, or Ctrl+R to fill right.

These shortcuts copy the top-left formula into the rest of the selection, adjusting references along the way.

When you fill, the spreadsheet copies the formula's structure, not its literal text. The formula =A2*B2 really means "multiply the two cells just to my left."

Drag it down one row and that meaning becomes =A3*B3. The relationship stays the same; the addresses shift to match the new position.

This automatic shifting is what makes the fill handle so powerful, and it is the topic of the next lesson.

Suppose column B has daily sales. You want column C to show the running total. In C2 set the first day equal to its sale, then in C3 add the day's sale to the total above.

Write the formula in C3, then fill it down with a double-click. Every row keeps adding the new day to the prior total, building a clean cumulative column with one filled formula.

If you cannot find the fill handle, it may be turned off. In Excel, go to File, Options, Advanced and make sure Enable fill handle and cell drag-and-drop is checked.

In Google Sheets the handle is always available; just be sure exactly one cell or range is selected. A handle only appears on a single selection, not on disconnected cells held with Ctrl.

Test what you learned about the fill handle.

You learned how to copy formulas the fast way:

• The fill handle is the small square at a cell's bottom-right corner.
• Drag it down or across to copy a formula; double-click it to auto-fill to the end of your data.
• Ctrl+D fills down and Ctrl+R fills right with the keyboard.
• Filling copies the formula's pattern, so references adjust to each new position automatically.

Next you will see exactly how those references adjust as you copy.