How to use the Excel Shortcuts Cheat Sheet
- 1. Search or browseType what you want to do, or pick one section of the Excel Shortcuts cheat sheet.
- 2. CopyEvery entry has its own Copy button, so it goes straight into your editor or notes.
- 3. DownloadSave the whole Excel Shortcuts cheat sheet as plain text or Markdown for offline revision.
What's in it
The list is for Excel on Windows (Microsoft 365 and recent desktop versions). On a Mac most shortcuts swap Ctrl for Cmd, but several are different, so check Excel's Help on a Mac. The 44 shortcuts are organised into 8 sections: Navigation, Selection, Editing, Formatting, Formulas, Rows, columns & sheets, Data & analysis, Files & view.
Example
Say you have 5,000 rows of sales data starting at A1. Instead of scrolling, press Ctrl + Down arrow to land on the last filled row, then Ctrl + Shift + Up arrow to select the whole column back to the top. Ctrl + T turns the block into a Table, and Ctrl + Shift + L toggles the filter arrows. Writing =B2*$F$1? Type B2*F1, click on F1 in the formula and press F4 once to lock it as $F$1.
Tips for using it
- Learn five at a time. Ctrl + Arrow, Ctrl + Shift + Arrow, Ctrl + T, F4 and Alt + = cover a lot of daily work.
- Shortcuts written with commas, like Alt, H, O, I, are pressed one after another, not together. They follow the letters shown on the ribbon when you tap Alt.
- Some laptops need the Fn key for F1–F12. If F2 or F4 changes your volume or brightness, try Fn + F2.
A quick look, one entry per section
- Navigation:
Ctrl + Arrow key(jump to the edge of the current block of data) - Selection:
Ctrl + Shift + Arrow key(select to the edge of the data block) - Editing:
F2(edit the active cell with the cursor at the end) - Formatting:
Ctrl + 1(open Format Cells) - Formulas:
Alt + =(autoSum the cells above or to the left) - Rows, columns & sheets:
Ctrl + + / Ctrl + -(insert / delete cells, rows or columns) - Data & analysis:
Ctrl + T(turn the range into an Excel Table) - Files & view:
Ctrl + S / F12(save / Save As)
Search the box above for the rest of the Excel Shortcuts entries, or download the full sheet.
Frequently asked questions
Do these work in Google Sheets?
Many do (Ctrl + Arrow, Ctrl + Shift + Arrow, Ctrl + B), but Sheets has its own list; press Ctrl + / inside Sheets to see it.
Why does Ctrl + Shift + 0 not unhide columns?
Windows can reserve that combination for switching keyboard layouts. Use right-click → Unhide, or Alt, H, O, U, L.
Is the Excel Shortcuts cheat sheet free?
Yes. You can search, read and copy every entry in the Excel Shortcuts cheat sheet without signing up. The first time you download it, we ask once for your name and WhatsApp number; after that downloads and every other Uncodemy tool open straight away.