WORKBOOK
Workbook
| Action | Windows Shortcut | Mac Shortcut |
|---|---|---|
| New Workbook | Ctrl + N | Command + N |
| Open Workbook | Ctrl + O | Command + O |
| Save Workbook | Ctrl + S | Command + S |
| Close Workbook | Ctrl + W | Command + W |
| Close Excel | Ctrl + Q | Command + Q |
| Switch Sheets | Ctrl + PgUp / PgDn | Control + Tab / Shift + Tab |
| Insert Worksheet | Shift + F11 | Shift + F11 |
| Delete Worksheet | Alt + E + L | Control + Option + – |
| Move Worksheet | Alt + E + M | Control + Option + M |
| Rename Worksheet | Alt + H + O + R | Control + Option + R |
| Hide Worksheet | Ctrl + Shift + H | Control + Shift + H |
| Unhide Worksheet | Alt + H + U | Control + Shift + U |
| Protect Workbook | Alt + T + P | Command + Option + P |
| Unprotect Workbook | Alt + T + P + P | Command + Option + P + P |
| View Macros | Alt + F11 | Option + F11 |
| Freeze Panes | Alt + W + F | Control + Option + F |
| Split Window | Alt + W + S | Command + Option + S |
| Hide/Show Gridlines | Alt + W + G | Command + Option + G |
| Hide/Show Headings | Alt + W + H | Command + Option + H |
| Hide/Show Formula Bar | Ctrl + Shift + U | Command + Option + U |
| Hide/Show Ribbon | Ctrl + F1 | Command + Option + R |
| Hide/Show Task Pane | F6 | F6 |