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 |