Excel Drag Fill: Shortcut Keys and How to Use Them

To drag-fill in Excel, select a cell, point to the small square at the lower-right corner of its selection, then drag the fill handle across or down the cells you want to fill. There is no keyboard shortcut that performs that mouse drag; on Windows, use Ctrl+D to fill selected cells down or Ctrl+R to fill them to the right instead.

What drag fill does in Excel

Drag fill is Excel’s way of extending or copying cell contents by pulling the fill handle across a range. It can repeat a value, extend a recognizable series, copy a formula, or carry cell formatting into neighboring cells. The result depends on what is in the starting cell and, in some cases, on the choices you make after dragging.

The fill handle is the tiny square at the bottom-right corner of the active cell or selected range. When the pointer is positioned over it, it changes to a thin black cross. Dragging from the middle of a cell selects cells; dragging from the handle fills them, so starting at the exact corner matters.

For example, if A1 contains Monday and you drag its handle down through A7, Excel can continue the weekday sequence. If A1 contains a standalone label such as Budget, dragging it usually copies that text into the destination cells. Excel tries to infer a useful pattern rather than treating every entry identically.

How to drag the fill handle

Enter a value, date, formula, or starting pattern in a cell. If the sequence needs two starting values to reveal its step, enter both in adjacent cells.
Select the source cell or the two-cell pattern, as appropriate.
Move the pointer to the small square at the lower-right corner of the selection until it becomes a black cross.
Hold the mouse button and drag down or across the destination cells, then release.
Check the filled results. If Excel chose a different pattern or formatting than you wanted, use the Auto Fill Options button that appears beside the filled range, when available.

To extend 2, 4, 6, enter 2 and 4 in adjacent cells, select both, and drag the handle. Excel can infer an increase of two. Starting with only 2 may instead repeat 2, because one value alone does not tell Excel which numerical sequence you intend. The same principle applies to custom intervals in dates and other series.

Keyboard shortcuts instead of dragging

For a quick fill without a mouse, select the range to receive the contents and use Excel’s fill shortcuts. The source cell must be at the appropriate edge of the selection so Excel knows which contents to extend.

Ctrl+D on Windows: Fill Down copies the top cell’s contents and formatting into the selected cells below it.
Ctrl+R on Windows: Fill Right copies the leftmost cell’s contents and formatting across the selected cells.
Mac: Command+D fills down and Command+R fills right in Excel for Mac. Keyboard mappings can vary with the keyboard and system settings; use the Home ribbon’s Fill commands if a shortcut is intercepted.

For example, enter a formula in B2, select B2:B20, and press Ctrl+D in Windows Excel. Excel fills the formula down through the selection, adjusting relative references as it goes. To fill across, put the source in the leftmost cell, select the row range, and press Ctrl+R. These shortcuts fill a selected range; they do not infer a numbered or dated series in the same way a drag operation can.

In desktop Excel, the ribbon alternative is Home > Editing > Fill > Down or Home > Editing > Fill > Right. The commands are useful when you cannot use a mouse or when a browser or system shortcut conflicts. In Excel for the web, keyboard behavior can depend on the browser and operating system, so the ribbon command or fill handle is a practical fallback.

What Excel can extend or copy

Excel recognizes many common patterns, but it cannot always know what you mean from one cell. A single value such as 10 may be copied or extended depending on the context and Auto Fill settings. Two starting values provide a clearer interval: select 10 and 15 together, then drag to continue 20, 25, 30. Excel can also extend familiar weekday and month names, dates, and some formatted number patterns.

Formulas are generally copied with their references adjusted to the new position. If a formula in C2 refers to A2, filling it down one row changes the corresponding relative reference to A3. This is often what you want when calculating a result for every row. Absolute references, marked with dollar signs, stay fixed when copied; mixed references lock either the row or the column. Check the filled formula results if the calculation depends on a fixed rate, tax cell, or other constant.

Drag fill can also extend formatting, such as a number format or cell color. That may be useful when building a consistently formatted report, but inconvenient when filling values into cells that already have carefully chosen formatting. The Auto Fill Options menu provides choices such as copying cells, filling a series, filling formatting only, and filling without formatting. The available choices depend on the content and operation.

Copying cells versus extending a series

A frequent source of confusion is that filling and copying are not always the same action. Copying repeats the source content. Extending a series calculates later members of a pattern. Dragging a cell containing a name usually repeats the name; dragging a recognized date or a selected two-number pattern may extend it instead.

After a drag, click the Auto Fill Options button beside the filled area if Excel’s choice is not right. Choose Copy Cells to repeat the original entry, or Fill Series to continue the pattern when that option is offered. Choose Fill Without Formatting to keep the destination cells’ existing appearance, or Fill Formatting Only when you want the look without replacing their contents.

Excel may also let you switch between copying and series behavior with a modifier key while dragging. The exact modifier and result can depend on the starting content and platform, so the Auto Fill Options menu is the clearest way to inspect the available choices. Do not assume that holding a key will always produce the same result for text, dates, formulas, and numbers.

Common drag-fill problems and fixes

The fill handle is missing: In Windows desktop Excel, check File > Options > Advanced, under Editing options, and make sure Enable fill handle and cell drag-and-drop is selected. If the setting is off, Excel will not show the usual handle.
The cell selects instead of filling: Aim for the tiny square at the selection’s lower-right corner, not the cell’s edge or center. Wait for the pointer to change to a black cross before dragging.
Excel repeats a number instead of counting: Enter two values that establish the interval, select both, and drag. Alternatively, use Auto Fill Options and choose Fill Series if that option appears.
A formula gives unexpected results: Check whether its references should move or remain fixed. Relative references shift as a formula is filled; absolute references with dollar signs remain anchored. A formula that works in the first row may need a fixed reference to a constant elsewhere.
Existing formatting changes: Open Auto Fill Options and select Fill Without Formatting, if available. This fills the content or series while retaining destination formatting.
The range is large or hard to drag precisely: Select the source and destination range, then use Ctrl+D or Ctrl+R on Windows. That avoids dragging across a long worksheet.

If Excel will not let you edit or fill cells, also check whether the worksheet is protected or whether the destination area contains merged cells. Those conditions can limit editing or make a rectangular fill behave differently than expected. Resolve the restriction or choose a suitable unmerged destination before trying again.

Filling formulas in a table or worksheet

For ordinary worksheet ranges, dragging a formula is a convenient way to apply a calculation to nearby rows. For instance, a per-row calculation can be entered in the first result cell and filled down. Before relying on the copied results, review a few rows, especially the first and last, to confirm that references have shifted as intended and that no cells were skipped.

Excel tables behave differently from plain ranges in useful ways. When you enter a formula in a table column, Excel often propagates it through the calculated column automatically. If that happens, there may be no need to drag. Tables also expand as you add rows, which can help keep formulas consistent. If a formula does not fill as expected, check whether the cells are part of a table and whether calculated-column behavior is enabled for the workbook.

Fill Down and Fill Right copy the contents of the first cell in the selected direction, while drag fill can use a multi-cell selection to infer a pattern. That distinction matters when continuing a series. To create a sequence, establish the pattern with starting entries and drag the handle; to repeat a formula or value through a known range, select the range and use the keyboard shortcut.

Choosing the right fill method

Use the fill handle when you want to extend a visible sequence, choose a direction interactively, or inspect Auto Fill Options immediately. It is especially handy for dates, repeated labels, and short formula ranges. Use Ctrl+D or Ctrl+R when you already know the exact destination range and want a quick, precise copy without dragging.

For larger or more structured data, consider whether a table formula or a built-in series command is more suitable. A table can propagate formulas as rows are added, while the fill handle is flexible for one-off ranges. If you need a special sequence that Excel cannot infer from the starting cells, you may need to enter more examples or use the appropriate worksheet feature rather than expecting drag fill to guess the rule.

Frequently Asked Questions

What is the shortcut for drag fill in Excel?

There is no keyboard shortcut for the literal mouse action of dragging the fill handle. On Windows, Ctrl+D fills down and Ctrl+R fills right in a selected range. On Mac, the corresponding shortcuts are Command+D and Command+R.

How do I drag a formula down in Excel?

Select the cell containing the formula, drag its lower-right fill handle down over the destination cells, and release. Or select the source and destination cells together and press Ctrl+D on Windows. Check whether relative and absolute references are set up correctly.

How do I make Excel continue a number series?

Enter at least two numbers that show the intended step, select both cells, and drag the fill handle. For example, selecting 3 and 6 before dragging tells Excel to continue by threes. If Excel copies instead, use Auto Fill Options and choose Fill Series when available.

Why can’t I see the fill handle?

In Windows desktop Excel, go to File > Options > Advanced and enable Enable fill handle and cell drag-and-drop under Editing options. Also check that the worksheet allows editing and that you are looking at the selection’s lower-right corner.

Can I drag-fill without copying the original formatting?

Yes. After dragging, open the Auto Fill Options menu and choose Fill Without Formatting if Excel offers it. This keeps the destination cells’ existing formatting while filling their contents or a series.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.