Updated May 2026 · 8 min read
Excel Keyboard Shortcuts: Complete Cheat Sheet (Windows & Mac)
Excel has one of the richest keyboard shortcut systems of any application. These shortcuts are the difference between analysts who grind through spreadsheets slowly and those who process data at machine speed. This guide covers every category — navigation, selection, formulas, formatting, and pivot tables — for both Windows and Mac.
For the full interactive reference with every shortcut, see the Excel shortcuts cheat sheet.
The 10 Excel Shortcuts You Use Every Day
| Action | Windows | Mac |
|---|---|---|
| AutoSum selected range | Alt + = | ⌘ + Shift + T |
| Fill Down | Ctrl + D | ⌘ + D |
| Insert current date | Ctrl + ; | Ctrl + ; |
| Toggle bold | Ctrl + B | ⌘ + B |
| Open Format Cells dialog | Ctrl + 1 | ⌘ + 1 |
| Select entire column | Ctrl + Space | Ctrl + Space |
| Select entire row | Shift + Space | Shift + Space |
| Find & Replace | Ctrl + H | ⌘ + H |
| Insert new row/column | Ctrl + Shift + + | ⌘ + Shift + + |
| Undo | Ctrl + Z | ⌘ + Z |
Navigation Shortcuts
Moving around large spreadsheets is where keyboard shortcuts deliver the biggest time saving over using a mouse.
| Action | Windows | Mac |
|---|---|---|
| Jump to last used cell | Ctrl + End | ⌘ + End |
| Jump to cell A1 | Ctrl + Home | ⌘ + Home |
| Move to edge of data region | Ctrl + Arrow | ⌘ + Arrow |
| Go to specific cell | Ctrl + G | Ctrl + G |
| Next worksheet tab | Ctrl + Page Down | Option + Right |
| Previous worksheet tab | Ctrl + Page Up | Option + Left |
| Move between open workbooks | Ctrl + Tab | ⌘ + ` |
Formula Shortcuts
Excel's formula engine becomes far more powerful when you can enter and audit formulas without leaving the keyboard.
| Action | Windows | Mac |
|---|---|---|
| AutoSum | Alt + = | ⌘ + Shift + T |
| Enter formula in multiple cells at once | Ctrl + Enter | Ctrl + Enter |
| Toggle absolute/relative reference ($) | F4 | ⌘ + T |
| Show all formulas (toggle) | Ctrl + ` | Ctrl + ` |
| Calculate now (force recalc) | F9 | F9 |
| Trace dependents | Ctrl + ] | Ctrl + ] |
| Evaluate formula step by step | Alt + M, V | Via menu |
Selection Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Extend selection to last used cell | Ctrl + Shift + End | ⌘ + Shift + End |
| Select current region (data island) | Ctrl + Shift + * | ⌘ + Shift + Space |
| Select entire worksheet | Ctrl + A | ⌘ + A |
| Add non-adjacent selection | Hold Ctrl + click | Hold ⌘ + click |
| Select to edge of data | Ctrl + Shift + Arrow | ⌘ + Shift + Arrow |
Formatting Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Currency format | Ctrl + Shift + $ | ⌘ + Shift + $ |
| Percentage format | Ctrl + Shift + % | ⌘ + Shift + % |
| Date format (D-MMM-YY) | Ctrl + Shift + # | ⌘ + Shift + # |
| Number format (2 decimals) | Ctrl + Shift + ! | ⌘ + Shift + ! |
| Open Format Cells dialog | Ctrl + 1 | ⌘ + 1 |
| Bold / Italic / Underline | Ctrl + B/I/U | ⌘ + B/I/U |
| Strikethrough | Ctrl + 5 | ⌘ + Shift + X |
| Add borders | Ctrl + Shift + & | ⌘ + Option + 0 |
Data & Pivot Table Shortcuts
| Action | Windows | Mac |
|---|---|---|
| Toggle AutoFilter | Ctrl + Shift + L | ⌘ + Shift + F |
| Convert range to Table | Ctrl + T | ⌘ + T |
| Group rows/columns | Alt + Shift + → | ⌘ + Shift + K |
| Ungroup rows/columns | Alt + Shift + ← | ⌘ + Shift + J |
| Refresh PivotTable | Alt + F5 | Option + F5 |
| Flash Fill | Ctrl + E | Ctrl + E |
| Remove duplicates | Alt, A, M | Via menu |
Pro Tips for Excel Power Users
- Ctrl+D to fill down after paste — paste a formula in the top cell of a column, select from that cell down to wherever you need it, then hit Ctrl+D to fill all selected cells with the formula automatically.
- F4 to lock references — press F4 while inside a cell reference in the formula bar to cycle through absolute ($A$1), row-locked (A$1), column-locked ($A1), and relative (A1) modes.
- Ctrl+` to audit formulas — toggle all cells to show formulas instead of values. This reveals hidden errors and makes auditing spreadsheets much faster.
- Alt+= then Ctrl+Enter — select a range of blank cells at the bottom of multiple columns and press Alt+= to sum them all at once, then Ctrl+Enter to confirm the formula in all selected cells simultaneously.
- Ctrl+Shift+End to select data range — selects from the current cell to the last used cell in the sheet, which is essential before copying or formatting large datasets.
Download the Office Shortcuts PDF
The Office Pack PDF includes complete shortcut cheat sheets for Excel, Word, PowerPoint, Outlook, Google Docs, Google Sheets, Zoom, and Teams — formatted for printing or desktop reference. One-time purchase, instant download.
Related Shortcut References
- Excel Keyboard Shortcuts — Full Interactive Reference
- Google Sheets Keyboard Shortcuts
- Microsoft Word Keyboard Shortcuts
- Word vs Google Docs Shortcuts Compared
Frequently Asked Questions
What is the most useful Excel keyboard shortcut?
Alt+= (AutoSum) is the single most time-saving shortcut in Excel. It automatically inserts a SUM formula for the range above or to the left of the selected cell. Combined with Ctrl+Shift+End to select to the last used cell, you can total entire data sets in seconds.
How do I quickly navigate between Excel worksheets?
Press Ctrl+Page Down to move to the next worksheet and Ctrl+Page Up to go to the previous one. To jump to a specific sheet, right-click any sheet navigation arrow (bottom-left) to see the full list of sheets.
What is the shortcut to freeze panes in Excel?
There is no direct keyboard shortcut for freeze panes, but you can access it quickly via the ribbon: press Alt, then W, then F, then F to toggle freeze panes via the keyboard menu. First click the cell below and to the right of where you want the freeze to occur.
How do I apply currency format to cells in Excel?
Select the cells and press Ctrl+Shift+$ to apply the Currency format with two decimal places. Use Ctrl+Shift+% for Percentage, Ctrl+Shift+# for Date format, and Ctrl+Shift+! for the comma number format.
Is there an Excel shortcut to insert a new row?
Select an entire row by pressing Shift+Space, then press Ctrl+Shift+= (or Ctrl++) to insert a row above the selected one. To insert multiple rows, select multiple rows first, then press the same shortcut.