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 |
|