*What follows is a field-tested workflow I use every time I need to fill a column fast — no fluff, no mouse dragging involved.*
—
You know the drill: 500 rows, a formula to copy, and your hand hovers over the mouse to drag down. It takes longer than it should. Ctrl + D eliminates that whole dance — one keystroke, done.
*If you fill columns in Excel more than a few times a week, this one’s for you.*
## The Shortcut: Ctrl + D (or Ctrl + Enter for Non-Contiguous)
Here’s the move:
1. **Type your first value or formula** in the starting cell (e.g., `=B2*10` or `January`).
2. **Select the entire range** you want to fill — click the first cell, then Shift + Click the last cell in that column.
3. **Press Ctrl + D.** Done.
Ctrl + D copies the content of the topmost selected cell down through every cell below it. For a column of 1,000 rows, it takes about one second. For a column of 10 — still one second.
### What about Ctrl + Enter?
If your range has gaps or isn’t a clean contiguous block, use **Ctrl + Enter** instead. Select your range first, type your value or formula, then Ctrl + Enter fills every selected cell at once. This is a hidden gem for scattered ranges — you can fill dozens of non-adjacent cells with a single keystroke.
## Real Example: Filling a Year’s Worth of Dates
Let’s say column A has “01/01/2026” in A2, and you need every day of the year down to A367.
1. Put `01/01/2026` in A2.
2. Put `=A2+1` in A3.
3. Select A3.
4. Hold **Shift**, scroll down to A367, and click A367.
5. Press **Ctrl + D**.
6. Watch Excel fill all 365 days in the time it takes you to exhale.
The same works for formulas — if A3 has a formula, Ctrl + D copies and adjusts that formula down the entire selection. Relative references update automatically. No dragging required.
## Flash Fill: The Smart Alternative
Sometimes you don’t have a formula to copy — you just have a pattern. That’s where **Flash Fill** shines. Introduced in Excel 2013, it watches what you’re doing and guesses the rest.
Say column A has full names (`John Smith`) and you need first names only in column B. Type `John` in B1, press Enter, then start typing in B2. If Excel detects the pattern, it will suggest filling the rest — press **Enter** to accept, or **Ctrl + E** to trigger it manually.
Flash Fill handles email extraction, reformatting, date parsing, and more — all without a single formula. It’s not perfect, but when it works, it feels like magic.
## The Fill Handle: Drag, Double-Click, or Extend
The **fill handle** is that small square at the bottom-right corner of a selected cell. Hover over it and your cursor turns into a plus sign. You have three ways to use it:
– **Drag down** — click and drag to fill as many cells as you like. Works for any pattern.
– **Double-click** — the fastest method for columns with adjacent data. Double-click the fill handle and Excel auto-fills based on the pattern in the adjacent column. If A has 500 rows of dates and you need B filled with formulas, double-click B’s fill handle and Excel stops at row 500 automatically.
– **Extend with a series** — if you only fill a few cells first (like three months: Jan, Feb, Mar), you can drag the fill handle further and Excel extends the series. This works for months, days, quarters, numbered sequences, and even custom lists you’ve defined.
**Pro tip:** Right-drag instead of left-drag and you’ll get a menu to choose the fill behavior — copy cells, fill series, fill formatting only, or fill without formatting.
## Ctrl + R: Fill Across Columns
Horizontal equivalent of Ctrl + D. Select a range across columns, press **Ctrl + R**, and the leftmost cell’s content fills right through the selection. Useful for filling a row of identical formulas across months, or propagating a label across a wide table.
## Ctrl + Shift + Arrow Keys: Select Fast Before You Fill
Before you can Ctrl + D efficiently, you need to select fast. That’s where **Ctrl + Shift + Arrow Keys** shine:
– **Ctrl + Shift + ↓** — selects from your current cell to the last used cell below (or the edge of continuous data).
– **Ctrl + Shift + →** — same idea, horizontally.
– Combine with **Ctrl + D** for a two-keystroke fill of any size column.
If you’re in cell A3 and press Ctrl + Shift + Down Arrow, Excel jumps to the last consecutive filled cell below. Combine that with Ctrl + D and you’ve filled 10,000 rows in under three seconds.
## Series Filling: Numbers, Dates, and Custom Lists
Auto-fill isn’t just for copying. Excel can **extend a series** intelligently:
– **Numbers:** Type `1` in A1 and `2` in A2, select both, drag the fill handle — Excel continues the sequence (3, 4, 5…). Type `1` and `3` (skipping one), select both, drag — Excel fills with odd numbers.
– **Dates:** Type a date, drag — Excel increments by one day by default. Right-drag to choose “Fill Months” or “Fill Years.”
– **Custom lists:** If you go to File → Options → Advanced → Edit Custom Lists, you can define your own. Many people add department names, product categories, or project codes once, then use them forever with auto-fill.
## Formula Copying: Relative vs. Absolute References
When you fill a formula down with Ctrl + D, Excel adjusts **relative references** automatically. That means `=B2*10` in row 1 becomes `=B3*10` in row 2, `=B4*10` in row 3, and so on. That’s exactly what you want — unless it’s not.
If you need a reference to stay locked on a specific cell (say, a tax rate in A1 that applies to every row), use an **absolute reference**: `$A$1`. The dollar signs freeze the reference — `=$A$1*B2` filled down stays locked on A1 while B2 becomes B3, B4, and so on. Mixing relative and absolute references (like `=$A$1*B2` or `=B$1*$A2`) gives you precise control over what changes and what stays fixed when you fill.
**When Ctrl + D copies the formula vs. the value:** If the top cell contains a plain number or text, Ctrl + D copies the value. If it contains a formula, Ctrl + D copies and adjusts the formula. If you want just the resulting value copied (not the formula), copy the cell, then use **Paste Special → Values**. Ctrl + D always propagates formulas when the source cell has one.
## Gotchas and Edge Cases
Auto-fill is powerful, but it has quirks:
– **Flash Fill doesn’t auto-update.** If your source data changes, Flash Fill results don’t recalculate. You need to re-trigger Ctrl + E or retype a sample cell.
– **Ctrl + D only fills downward.** It copies the top cell down — it won’t fill upward or sideways. For upward filling, use Ctrl + Shift + Up Arrow to select the range above, then Ctrl + D.
– **Protected sheets block auto-fill.** If a sheet is protected, you can’t fill cells — even with shortcuts.
– **Merged cells break fill handles.** The fill handle stops working near merged cells. Unmerge first if you need bulk filling.
– **Hidden rows** — if rows are filtered or hidden, Ctrl + D still fills all selected cells including hidden ones. Watch out if your filter is active.
– **Tables (Ctrl + T) vs. normal ranges** — when your data is inside an Excel Table, auto-fill behaves slightly differently. Ctrl + D fills the formula down the entire column within the table, which is actually great. But the fill handle may not extend beyond the table’s last row unless you add new rows to the table first.
## The Bottom Line
Stop dragging. Stop copy-pasting into 500 cells. Ctrl + D fills a whole column in one keystroke, Ctrl + Enter handles scattered ranges, Flash Fill reads your mind, and the fill handle is your fast-fill workhorse. They’ve all been in Excel for years. Use them.
—
**Want more Excel shortcuts that actually save time?** My free guide — **20 Excel Shortcuts for People Who Fill Columns Daily** — covers the key combos I use every day, from instant formula copying to fast multi-select. Stop dragging, start typing.