Cheat sheets / Excel Shortcuts

Excel Keyboard Shortcuts for Windows

The 72 Excel shortcuts that save the most time on Windows, grouped by what you are doing. Type in the filter to find one fast.

This page also works as a hotkey overlay. Hold Ctrl+Space to see it, let go to hide it. What is this?

Essentials

  • Save Ctrl+S
  • Undo, redo Ctrl+Z/Y
  • Find Ctrl+F
  • Find and replace Ctrl+H
  • Edit the cell F2
  • Print Ctrl+P

Move around

  • Jump to the edge of the data Ctrl+Arrow
  • Go to cell A1 Ctrl+Home
  • Go to the last used cell Ctrl+End
  • Next / previous sheet Ctrl+PgDn/PgUp
  • Go to a cell or name Ctrl+G
  • One screen right / left Alt+PgDn/PgUp

Select

  • Select the whole table Ctrl+A
  • Select the row Shift+Space
  • Select the column Ctrl+Space
  • Extend to the edge of the data Ctrl+Shift+Arrow
  • Extend by one cell Shift+Arrow
  • Extend to the last used cell Ctrl+Shift+End

Rows and columns

  • Insert rows or columns Ctrl+Shift+Plus
  • Delete rows or columns Ctrl+Minus
  • Hide rows Ctrl+9
  • Hide columns Ctrl+0
  • Unhide rows Ctrl+Shift+9
  • Group / ungroup Alt+Shift+→/←

Enter data

  • Fill all selected cells Ctrl+Enter
  • New line inside a cell Alt+Enter
  • Fill down Ctrl+D
  • Fill right Ctrl+R
  • Insert today's date Ctrl+;
  • Insert the current time Ctrl+Shift+;

Copy and paste

  • Copy, cut, paste Ctrl+C/X/V
  • Paste Special Ctrl+Alt+V
  • Paste values only Ctrl+Shift+V
  • Flash Fill Ctrl+E
  • Copy the formula from above Ctrl+'
  • Cancel the copy Esc

Formulas

  • AutoSum Alt+=
  • Lock the reference with $ F4
  • Show all formulas Ctrl+`
  • Recalculate F9
  • Insert a function Shift+F3
  • Accept the suggested function Tab

Format cells

  • Format Cells dialog Ctrl+1
  • Bold, italic, underline Ctrl+B/I/U
  • Number with 2 decimals Ctrl+Shift+1
  • Currency Ctrl+Shift+4
  • Percent Ctrl+Shift+5
  • Date Ctrl+Shift+3

Tables, filters, charts

  • Turn the range into a table Ctrl+T
  • Filters on / off Ctrl+Shift+L
  • Open the filter menu Alt+↓
  • Quick Analysis Ctrl+Q
  • Chart from the selection Alt+F1
  • Chart on a new sheet F11

Sheets and workbooks

  • New sheet Shift+F11
  • Rename the sheet AltthenHthenOthenR
  • New workbook Ctrl+N
  • Open a workbook Ctrl+O
  • Save As F12
  • Close the workbook Ctrl+W

View

  • Show / hide the ribbon Ctrl+F1
  • Freeze panes AltthenWthenFthenF
  • Zoom in / out Ctrl+Scroll
  • Expand the formula bar Ctrl+Shift+U
  • Next open workbook Ctrl+F6
  • Show the ribbon key tips Alt

Notes, names, macros

  • Add or edit a note Shift+F2
  • Insert a link Ctrl+K
  • Check spelling F7
  • Name Manager Ctrl+F3
  • Run a macro Alt+F8
  • Open the VBA editor Alt+F11

These are for Excel on Windows. Shortcuts written with commas, like Alt, H, O, R, are pressed one key after another, not together. On a Mac most of them use Cmd in place of Ctrl.

Skip the browser tab

Keep this cheat sheet on a hotkey

BrainRAM is a small free app for Windows. Hold Ctrl+Space and this page appears on top of whatever you are doing. Let go and it's gone. Glance, let go, carry on.

Every group sits in the same place each time, so after a few days you stop reading and just glance at the spot.

  1. Download BrainRAM Free, no account, works offline. The installer isn't code-signed yet, so Windows shows a blue warning: click More info, then Run anyway.
  2. Add this page to BrainRAM Opens BrainRAM with this page ready to import.

BrainRAM runs on Windows today. The macOS and Linux versions are on the way.

Email me when mine is ready
This page as BrainRAM shows it while you hold the hotkey.

More cheat sheets

🔀 Git Cheat Sheet Commit, branch, sync, merge and undo. The 36 commands you use every week. 🐳 Docker Cheat Sheet Images, containers, logs, Compose and cleanup, in 36 commands. 🐧 Linux Commands Cheat Sheet Files, logs, search, permissions, processes and SSH in 36 commands. ⚡ PowerShell Cheat Sheet Files, search, filtering output, processes and network in 36 commands. 🗄️ SQL Cheat Sheet SELECT, WHERE, JOIN, GROUP BY and changing data, as 36 examples. 🔎 Regex Cheat Sheet Character classes, quantifiers, groups, lookarounds and ready-made patterns. ⌨️ VS Code Keyboard Shortcuts for Windows 72 default shortcuts for Windows: multi-cursor, navigation, terminal, debugging. 📝 Vim Cheat Sheet 72 commands: modes, moving, editing, search and replace, text objects. 📊 Excel Formulas Cheat Sheet XLOOKUP, SUMIFS, IF, text and dates, as 30 examples you can paste. 🪟 Windows 11 Keyboard Shortcuts 72 shortcuts: snapping, desktops, screenshots, clipboard, File Explorer.