Workbook

ActionWindows ShortcutMac Shortcut
New WorkbookCtrl + NCommand + N
Open WorkbookCtrl + OCommand + O
Save WorkbookCtrl + SCommand + S
Close WorkbookCtrl + WCommand + W
Close ExcelCtrl + QCommand + Q
Switch SheetsCtrl + PgUp / PgDnControl + Tab / Shift + Tab
Insert WorksheetShift + F11Shift + F11
Delete WorksheetAlt + E + LControl + Option + –
Move WorksheetAlt + E + MControl + Option + M
Rename WorksheetAlt + H + O + RControl + Option + R
Hide WorksheetCtrl + Shift + HControl + Shift + H
Unhide WorksheetAlt + H + UControl + Shift + U
Protect WorkbookAlt + T + PCommand + Option + P
Unprotect WorkbookAlt + T + P + PCommand + Option + P + P
View MacrosAlt + F11Option + F11
Freeze PanesAlt + W + FControl + Option + F
Split WindowAlt + W + SCommand + Option + S
Hide/Show GridlinesAlt + W + GCommand + Option + G
Hide/Show HeadingsAlt + W + HCommand + Option + H
Hide/Show Formula BarCtrl + Shift + UCommand + Option + U
Hide/Show RibbonCtrl + F1Command + Option + R
Hide/Show Task PaneF6F6
 
%d