Excel's real power is doing something once and repeating it across thousands of rows in a click.
Repeating patterns of data filled down a long spreadsheet
The small square at the bottom-right of a selection is the fill handle. Drag it to copy or extend.
| Drag this | Result |
|---|---|
| A formula | Copies it (references adjust) |
Jan | Feb, Mar, Apr… |
Mon | Tue, Wed… |
1, 2 (both selected) | 3, 4, 5… |
2026 | copies 2026 (need a pattern for a series) |
Instead of dragging to the bottom of a 5,000-row dataset, double-click the fill handle. Excel fills down automatically to match the length of the adjacent column.
CtrlC then CtrlV copies everything. Often you want only part of a cell. Use Paste Special (CtrlAltV):
| Paste option | Keeps |
|---|---|
| Values | Results only (drops formulas) |
| Formulas | The formula, no formatting |
| Formats | The look, no data |
| Transpose | Flips rows ↔ columns |
Paste Values is the #1 trick:
turn live formulas into static numbers
so they stop changing.
Flash Fill (CtrlE) detects a pattern from your example and fills the rest.
A (Full Name) B (you type) → Flash Fill the rest
Ada Lovelace Ada Grace, Alan, Katherine…
Grace Hopper
Type the first first-name, press CtrlE, and Excel extracts every first name. Great for splitting names, emails, and codes without a single formula.