Excel Data Entry & Editing Shortcuts
Most of the time spent in Excel isn't building formulas from scratch — it's filling existing patterns down a column, fixing typos, and repeating the same formatting action across dozens of non-adjacent cells. These shortcuts target that repetitive middle layer of spreadsheet work, where small time savings compound because you're doing the same motion fifty times in a row. Two more everyday editing basics round out the toolkit: undoing a recent mistake, and clearing a cell's content while deliberately leaving its formatting untouched.
| Action | Windows | Mac | Description |
|---|---|---|---|
| Fill down | Ctrl+D | Cmd+D | Copies the content and formula of the top cell in a selection down through the rest of it — faster than copy-paste when you've already selected the target range. |
| Fill right | Ctrl+R | Cmd+R | Same as fill down but horizontally; handy for dragging a formula across monthly columns. |
| AutoSum | Alt+= | Shift+Cmd+T | Drops in a SUM formula and takes its best guess at which adjacent cells belong in the range. That guess is genuinely just a guess, not magic, so it's worth double-checking the highlighted range before hitting Enter, especially near merged cells or existing subtotal rows. |
| Repeat last action | F4 or Ctrl+Y | Cmd+Y or Fn+F4 | Reapplies whatever you just did — inserting a row, applying bold, deleting a column — without reopening any dialog. Extremely useful when formatting many non-adjacent cells one at a time. |
| Edit the active cell | F2 | Control+U or Fn+F2 | Drops you into in-cell editing mode at the end of the existing content, equivalent to double-clicking the cell, without risking an accidental drag. |
| Insert current date | Ctrl+; | Ctrl+; | Stamps today's date as a static value (not a live formula like TODAY()), so it won't change when the file is reopened later. |
| Insert current time | Ctrl+Shift+; | Cmd+Shift+; | Same idea as the date shortcut but for the current time, also a static value rather than a formula. |
| Undo last action | Ctrl+Z | Cmd+Z | Reverts the most recent action, with Excel maintaining a deep undo history covering typed entries, formatting changes, row/column operations, and most other edits in the order they were performed. |
| Clear cell contents | Delete | Delete or Backspace | Clears the value or formula from the selected cell(s) without removing any formatting applied to them, distinct from Ctrl+Minus which removes the row/column structure itself entirely. |
Ctrl+D (fill down) and Ctrl+R (fill right) are the two shortcuts that save the most clicks once you internalize them. Instead of the usual copy-then-paste-into-a-range approach, which can clobber formatting you never meant to touch, just select the source cell along with the destination range and press Ctrl+D. The formula or value fills downward, with relative references adjusting exactly as if you'd dragged the fill handle. This matters especially with formulas: dragging the fill handle with the mouse is precise but slow over long ranges, while selecting A2:A5000 and hitting Ctrl+D fills five thousand rows instantly.
F4 does double duty in Excel and which behavior you get depends on context. While editing a formula with your cursor positioned next to a cell reference, F4 cycles that reference through absolute and relative states: A1, then $A$1, then A$1, then $A1, then back to A1. This saves manually typing dollar signs, which matters when you're locking a reference (like a tax rate or exchange rate cell) before filling a formula across many rows. Outside of formula editing, F4 instead repeats your last action — if you just bolded a cell, F4 bolds the next selected cell; if you just inserted a row, F4 inserts another. This dual behavior trips people up until they realize F4's meaning depends entirely on whether you're mid-formula or not.
F2 drops you into in-cell edit mode at the end of the cell's existing content, which is safer than double-clicking when you're not sure exactly where your mouse will land — a slightly-off double-click can start a drag instead of an edit. Once in edit mode, Home and End jump to the start/end of the cell's text, and Ctrl+Left/Right jump by word, exactly like a text editor.
For static date and time stamps, Ctrl+; and Ctrl+Shift+; insert today's date and the current time as fixed values rather than live formulas. This distinction matters in logs or audit trails — if you used =TODAY() instead, every previously logged date would silently update to today's date every time the file recalculates, which is almost never what you want for a record of when something actually happened.
Undo (Ctrl+Z / Cmd+Z) reverts your most recent action, and Excel maintains a genuinely deep undo history spanning typed values, formula edits, formatting changes, and structural operations like row insertion or deletion, all in the exact order they were performed — worth knowing that undo history is cleared the moment you close and reopen a workbook, so an editing mistake discovered in a later session can't be undone the same way a mistake caught within the same active session can.
Clearing cell contents (Delete) removes only the value or formula from selected cells, leaving any applied formatting — fill color, borders, number format — completely intact, which is a meaningfully different action from deleting the row or column structure itself with Ctrl+Minus. This distinction matters when you want to reuse a formatted cell for new data later without needing to reapply its formatting from scratch, versus genuinely wanting to remove the row or column's presence in the sheet entirely.