How to Fill Down a Formula in Excel (Ctrl+D)

Ctrl+D takes whatever is in the top cell of a selected range and replicates it down across the rest of the selection — quicker and less error-prone than a manual copy-and-paste when a formula or value needs to run down a column. **Exact mechanics**: Select a range starting with the cell that has the content you want to propagate (for example, B2 with a formula in it) down through the empty cells below it (say B2:B500), then press Ctrl+D. Excel fills every cell in the selection with the content of B2, adjusting any relative cell references exactly as it would if you'd dragged the fill handle — so a formula like =A2*1.1 in B2 becomes =A3*1.1 in B3, =A4*1.1 in B4, and so on down the column. **Why it's better than copy-paste for this specific task**: Copying a cell and pasting it into a large range risks overwriting formatting in the destination cells (borders, fills, number formats) unless you specifically use Paste Special to paste formulas only. Ctrl+D fills the formula/value while generally preserving the destination's existing formatting better in most cases, and critically, it's a single keystroke rather than copy-select-paste, which matters when you're repeating this action across many columns in a wide table. **Speed at scale**: For very long columns, you don't need to scroll to the bottom and shift-click. Instead, select the starting cell, then use the Name Box to type a range like B2:B10000 and press Enter to select it instantly, then Ctrl+D. This avoids manual scrolling entirely and is the standard technique for filling formulas down tables with thousands of rows. **Common gotcha**: If the selected range's top cell is blank, Ctrl+D fills the rest of the range with nothing, effectively clearing it — a frequent accidental-data-loss scenario when someone selects one row too high before pressing the shortcut. Always confirm the top cell of your selection actually has the content you intend to propagate. **Related shortcuts**: Ctrl+R is the horizontal equivalent, filling rightward from the leftmost cell in a selection instead of downward. F4 (while editing the source formula beforehand) is often used in combination — lock any reference that shouldn't shift as you fill (like a tax rate in a fixed cell) with F4 before invoking Ctrl+D, so the fill behaves correctly across the whole range. **Filling down across a filtered range**: Ctrl+D behaves differently when applied to a range that includes filtered-out (hidden) rows — depending on the Excel version and exact selection method, it can either skip hidden rows correctly or inadvertently include them, so it's worth double-checking results after filling down across any range where a filter is currently active, rather than assuming it behaves identically to an unfiltered fill. **Mistake to avoid**: selecting a range that's taller than your actual dataset (say, filling down to row 10,000 when your real data ends at row 500) doesn't cause an error, but it does create formulas in hundreds of rows that reference blank cells, often producing a wall of zero or error values below your real data that can confuse anyone reviewing the sheet later — it's worth trimming the selection to match your actual data extent, or using Ctrl+Shift+End first to find exactly where your data really stops. **Filling down text and formatting only**: Ctrl+D isn't limited to formulas — it works identically on plain text values, dates, and even cell formatting alone if that's all the source cell contains, making it a general-purpose 'copy this cell's exact content down' tool rather than something specific to formula propagation.