Printable Excel Keyboard Shortcuts Cheat Sheet
66 Excel shortcuts on one page — navigation, formatting, formulas, pivot tables and data — with the Windows keys and the Mac keys side by side, so one printout covers a mixed office or lab. Hit Print or Download PDF; no signup. Copy, paste and undo behave the same in Excel as everywhere else and live on the general keyboard shortcuts sheet instead.
Prints on one US Letter page. Set margins to "None" for the sharpest result.
Excel Keyboard Shortcuts
66 shortcuts — Windows and Mac keys side by side
Navigation & Selection
| Action | Windows | Mac |
|---|---|---|
| Jump to the edge of the data | Ctrl+Arrow | Cmd+Arrow |
| Select to the edge of the data | Ctrl+Shift+Arrow | Cmd+Shift+Arrow |
| Select the current region | Ctrl+Shift+* | Ctrl+Shift+Space |
| Select the whole column | Ctrl+Space | Ctrl+Space |
| Select the whole row | Shift+Space | Shift+Space |
| Select every cell | Ctrl+A | Cmd+A |
| Back to cell A1 | Ctrl+Home | Ctrl+Fn+← |
| Last used cell on the sheet | Ctrl+End | Ctrl+Fn+→ |
| Start of the row | Home | Fn+← |
| Go To dialog | Ctrl+G or F5 | Ctrl+G |
| Next / previous sheet | Ctrl+PgDn / PgUp | Option+→ / ← |
| Next open workbook | Ctrl+Tab | Cmd+` |
| Find | Ctrl+F | Cmd+F |
| Find and replace | Ctrl+H | Ctrl+H |
| Edit the active cell | F2 | Ctrl+U |
Formatting
| Action | Windows | Mac |
|---|---|---|
| Format Cells dialog | Ctrl+1 | Cmd+1 |
| Bold | Ctrl+B | Cmd+B |
| Italic | Ctrl+I | Cmd+I |
| Underline | Ctrl+U | Cmd+U |
| Strikethrough | Ctrl+5 | Cmd+Shift+X |
| General format | Ctrl+Shift+~ | Ctrl+Shift+~ |
| Number, two decimals | Ctrl+Shift+! | Ctrl+Shift+! |
| Currency, two decimals | Ctrl+Shift+$ | Ctrl+Shift+$ |
| Percent, no decimals | Ctrl+Shift+% | Ctrl+Shift+% |
| Scientific | Ctrl+Shift+^ | Ctrl+Shift+^ |
| Date (d-mmm-yy) | Ctrl+Shift+# | Ctrl+Shift+# |
| Time | Ctrl+Shift+@ | Ctrl+Shift+@ |
| Outline border on selection | Ctrl+Shift+& | Cmd+Option+0 |
| Remove all borders | Ctrl+Shift+_ | Cmd+Option+_ |
| Hide the row | Ctrl+9 | Ctrl+9 |
| Unhide rows | Ctrl+Shift+9 | Ctrl+Shift+9 |
| Hide the column | Ctrl+0 | Ctrl+0 |
| Unhide columns | Ctrl+Shift+0 | Ctrl+Shift+0 |
| Insert a hyperlink | Ctrl+K | Cmd+K |
| Repeat the last action | F4 | Cmd+Y |
Formulas
| Action | Windows | Mac |
|---|---|---|
| AutoSum the selection | Alt+= | Cmd+Shift+T |
| Cycle A1 → $A$1 → A$1 | F4 | Cmd+T |
| Show formulas, not results | Ctrl+` | Ctrl+` |
| Fill down from the cell above | Ctrl+D | Cmd+D |
| Fill right from the cell left | Ctrl+R | Cmd+R |
| Fill the whole selection | Ctrl+Enter | Ctrl+Return |
| Enter as a legacy array formula | Ctrl+Shift+Enter | Ctrl+Shift+Return |
| Insert Function dialog | Shift+F3 | Shift+F3 |
| Copy the formula from above | Ctrl+' | Cmd+' |
| Copy the value from above | Ctrl+Shift+" | Ctrl+Shift+" |
| Evaluate part of a formula* | F9 | F9 |
| Insert today's date | Ctrl+; | Ctrl+; |
| Insert the current time | Ctrl+Shift+; | Cmd+; |
| Recalculate every workbook | F9 | Cmd+= |
| Recalculate the active sheet | Shift+F9 | Shift+F9 |
| Expand / collapse formula bar | Ctrl+Shift+U | Ctrl+Shift+U |
Pivot Tables
| Action | Windows | Mac |
|---|---|---|
| Create one from the selection | Alt, N, V | — |
| Refresh this pivot table | Alt+F5 | — |
| Refresh every pivot table | Ctrl+Alt+F5 | — |
| Group / ungroup items | Alt+Shift+→ / ← | Cmd+Shift+K / J |
| Select the report, minus filters | Ctrl+Shift+* | Ctrl+Shift+Space |
| Open a field's drop-down | Alt+↓ | Option+↓ |
| Legacy PivotTable wizard | Alt, D, P | — |
Data
| Action | Windows | Mac |
|---|---|---|
| Turn AutoFilter on or off | Ctrl+Shift+L | Cmd+Shift+F |
| Insert rows or columns† | Ctrl+Shift++ | Cmd+Shift++ |
| Delete rows or columns† | Ctrl+- | Cmd+- |
| Paste Special | Ctrl+Alt+V | Cmd+Ctrl+V |
| Format the range as a table | Ctrl+T | Cmd+T |
| Insert or edit a note | Shift+F2 | Fn+Shift+F2 |
| Add a new sheet | Shift+F11 | Shift+F11 |
| Freeze the top row | Alt, W, F, F | — |
* Select part of a formula in the formula bar first; F9 replaces it with what it evaluates to, and Esc puts it back. † Select whole rows or columns first; new rows arrive above the selection and new columns to its left. "Alt, N, V" means press and release each key in turn — Windows key tips. A dash means Excel for Mac has no key for that command; use the PivotTable Analyze or View tab. On a Mac where the F-keys run brightness and volume, hold Fn as well. · printablepolly.com/excel-keyboard-shortcuts
The Shortcuts Worth Learning First
1. Ctrl + Arrow and Ctrl + Shift + Arrow
These two move more spreadsheet than everything else on the chart. Ctrl + Arrow (Cmd + Arrow on a Mac) jumps to the last filled cell in that direction; adding Shift selects everything it passes, so a 50,000-row column gets selected in one keystroke instead of a scroll-and-drag. They are also how you find where a dataset actually ends before you write a formula across it.
2. Alt + = to total, then F4 to lock the reference
Alt + = (Cmd + Shift + T on a Mac) drops a SUM under the column you are standing in and guesses the range. F4 then cycles the reference under your cursor through A1 → $A$1 → A$1 → $A1 — locking the row or the column before you drag a formula down is the difference between a lookup that works on every row and one that quietly slides off its table. The math formulas reference covers the arithmetic those formulas are standing in for.
3. The Ctrl + Shift number-format band
Ctrl + Shift + ~ ! $ % ^ # @ runs left to right across the number row and applies general, number, currency, percent, scientific, date and time formatting — the same keys on Windows and Mac. Ctrl + 1 opens the full Format Cells dialog when you need something the band does not cover, and Ctrl + ` flips the whole sheet between results and the formulas behind them, which is how a hard-coded number sitting in a column of calculations gives itself away.
4. Alt + F5 and Alt + Shift + → for pivot tables
A pivot table does not update itself when the source data changes: Alt + F5 refreshes the one you are in and Ctrl + Alt + F5 refreshes every one in the workbook. Alt + Shift + → groups whatever you have selected, which is how a column of daily dates becomes months or quarters without adding a helper column. If your data lives in a browser instead, the Google Sheets shortcuts chart is the same idea for Sheets.
Printable PDF
The chart above is the whole thing — one US Letter page, black-and-white friendly, with both platforms in every row. Print as many copies as you need for a class, a team or a computer lab. No signup, no watermark.
More Printable Tech Cheat Sheets
FAQ
How do I find the shortcut for a command Excel has not given a key to?
Press and release Alt on Windows and Excel labels every ribbon tab and button with the letters to press next — that is where Alt, N, V (create a pivot table) and Alt, W, F, F (freeze the top row) come from, and it covers every command on the ribbon rather than the few with dedicated keys. Excel for Mac has no key tips; its menu bar prints the shortcut beside each command instead, which is the quickest way to check the handful that differ.
Do Excel shortcuts work the same on a Mac?
Mostly Cmd takes the place of Ctrl, but the exceptions are the ones worth printing. The number-format band (Ctrl+Shift+% and friends) keeps Ctrl on both platforms, AutoSum is Cmd+Shift+T rather than Alt+=, absolute references are Cmd+T rather than F4, and editing a cell in place is Ctrl+U rather than F2. On a Mac where the F-keys run brightness and volume, hold Fn as well.
Why does F4 sometimes repeat my last action instead of adding dollar signs?
Because it does both jobs, and which one you get depends on whether you are editing. With the cursor sitting on a reference inside a formula, F4 cycles A1 → $A$1 → A$1 → $A1. Anywhere else it repeats whatever you did last, which is the fastest way to apply the same fill colour or border down a sheet. Excel for Mac splits them: Cmd+T for the reference, Cmd+Y to repeat.
What is the fastest way to move around a big spreadsheet?
Ctrl+Arrow (Cmd+Arrow on a Mac) jumps to the last filled cell in that direction, so one press lands you at the bottom of a 50,000-row column. Add Shift and it selects everything on the way — Ctrl+Shift+↓ grabs a whole column of data without touching the mouse. Ctrl+End goes to the true last used cell, which is also how you spot the stray formatting that has been inflating your file size.
Are there real keyboard shortcuts for pivot tables?
A few, and they are the ones that get used every day: Alt+F5 refreshes the pivot table under the cursor, Ctrl+Alt+F5 refreshes every one in the workbook, and Alt+Shift+→ groups the selected items — the shortcut for rolling dates up into months or quarters. The rest are ribbon key tips (Alt, N, V to create one; Alt, D, P for the old wizard). Excel for Mac has no key tips at all, so those live on the PivotTable Analyze tab there, though Cmd+Shift+K still groups a selection.
Is this Excel cheat sheet free to print?
Yes. Click Print or Download PDF and all 66 shortcuts come out on one US Letter page with both platforms in every row — no signup, no watermark, and no limit on copies for a class, a team, or a whole office.