In this segment, you will learn a lot about using shortcuts in Microsoft Excel.

WorkSheet Tab Shortcuts

WorkSheet Tab related shortcuts are included in this section

Command Windows Shortcuts Mac Shortcuts
Insert new worksheet Shift + F11 Fn + Shift + F11
Go to the next worksheet Ctrl + PgDn Fn + Ctrl + ↓
Go to the previous worksheet Ctrl + PgUp Fn + Ctrl + ↑
Delete selected worksheets Alt, E, L  
Rename current worksheet Alt, O, H, R  
Select adjacent worksheets Ctrl + Shift + PgUp/PgDn  
Select adjacent worksheets (mouse) Shift + Click Shift + Click
Select non-adjacent worksheets (mouse) Ctrl + Click Cmd + Click
Open Move or Copy window for selected sheets Alt, E, M  
Duplicate worksheet (mouse) Ctrl + drag Alt + drag
Protect or Unprotect a WorkSheet Alt, R, P, S  
Clear print area Alt, P, R, C  
Set print area Alt, P, R, S