Excel Shortcuts: The Essential List for Faster Work

Most Excel work is not typing formulas — it is moving around, selecting, copying, and formatting. The mouse does all of that slowly. A small set of keyboard shortcuts does the same jobs in a fraction of the time, and they work in every modern version of Excel. Learn ten of these and you will feel the difference the same day; learn the full list and the mouse starts to feel like a detour.

Move without the mouse

• Ctrl + Arrow key — jump to the edge of a block of data in that direction. Hold Shift as well (Ctrl + Shift + Arrow) to select everything on the way there.
• Ctrl + Home — jump back to cell A1. Ctrl + End — jump to the last used cell on the sheet.
• Ctrl + Page Up / Page Down — switch to the previous or next worksheet.
• Tab — move one cell right; Shift + Tab — one cell left; Enter — one cell down. After typing a value, Enter confirms it and moves on.

Select in seconds

• Ctrl + Space — select the whole column. Shift + Space — select the whole row.
• Ctrl + A — select the current data region; press it again to select the entire sheet.
• Shift + Arrow keys — extend the selection one cell at a time in any direction.

Edit and enter data faster

• Ctrl + C / Ctrl + X / Ctrl + V — copy, cut, paste. Ctrl + Z undoes the last action; Ctrl + Y redoes it.
• F2 — edit the selected cell in place, instead of retyping its whole contents.
• Ctrl + D — fill down: copy the cell above into the selected cells. Ctrl + R — fill right.
• Ctrl + ; (semicolon) — insert today’s date. Ctrl + Shift + : (colon) — insert the current time.
• Alt + Enter — start a new line inside the same cell, for multi-line labels.

Format and calculate

• Ctrl + 1 — open Format Cells, the one dialog for number formats, fonts, borders, and alignment.
• Ctrl + B / Ctrl + I / Ctrl + U — bold, italic, underline.
• Alt + = (equals) — insert AutoSum, which totals the numbers above or beside the selected cell.
• Ctrl + Shift + L — turn AutoFilter on or off for the selected data.
• F9 — recalculate all formulas, useful when a sheet is set to manual calculation.

On a Mac

Most shortcuts are identical with Cmd in place of Ctrl: Cmd + C, Cmd + V, Cmd + Z, and so on. Two exceptions to remember: Ctrl + 1 for Format Cells becomes Cmd + 1, and F2 to edit a cell is Ctrl + U on Mac Excel. Everything else in this list transfers directly.

How to actually learn them

Do not try to memorize the whole list at once. Pick the three you use most — usually Ctrl + Arrow, Ctrl + Shift + Arrow, and Ctrl + D — and use only those for a week until they are automatic. Then add three more. Shortcuts only pay off once your fingers know them, and that happens through repetition on real work, not through reading a list twice.

Quick recap

Ctrl + Arrow moves, Ctrl + Shift + Arrow selects, Ctrl + Space and Shift + Space select columns and rows, Ctrl + D fills down, Ctrl + 1 formats, and Alt + = sums. Start with three, add three a week, and the mouse becomes the slow way to work in Excel.