X Excel
Excel keyboard shortcuts: the complete cheat sheet
From selecting a whole table in one keystroke to the reference-locking shortcut almost nobody uses on purpose.
By the Hidden Ribbon staff · Updated September 2026 · 4 min read
These are for Excel on Windows. On a Mac, most combinations swap Ctrl for Cmd, though a handful (like F4) stay the same either way.
General Shortcut What it does Ctrl + N / O / S / P New / Open / Save / Print Ctrl + Z / Y Undo / Redo Ctrl + ` Toggle showing formulas instead of results
Navigation & selection Shortcut What it does Ctrl + Arrow key Jump to the edge of the current data region Ctrl + Home / End Jump to A1 / the last used cell Ctrl + Page Up / Down Switch between sheet tabs Ctrl + Space Select the entire column Shift + Space Select the entire row Ctrl + Shift + 8 Select the current region (the whole table at once)
Formulas Shortcut What it does F4 Toggle a cell reference between relative and absolute (adds/removes $) Alt + = AutoSum the selected range Ctrl + E Flash Fill — finish a pattern automatically F2 Edit the active cell directly
Data entry & editing Shortcut What it does Ctrl + D Fill down from the cell above Ctrl + R Fill right from the cell to the left Ctrl + ; Insert today’s date as a fixed value Ctrl + Shift + ; Insert the current time as a fixed value Alt + Enter Start a new line inside the same cell
Formatting Shortcut What it does Ctrl + 1 Open Format Cells Ctrl + B / I / U Bold / Italic / Underline Ctrl + Shift + $ Apply currency format Ctrl + Shift + % Apply percentage format
This week's find
PowerPoint's eyedropper can pick a color from anywhere on your screen, not just your current slide.
Read the trick →
Growing fast
52 hidden tricks documented so far.