Switch, add and rename sheets
Ctrl+PageDown moves to the next sheet and Ctrl+PageUp to the previous one. Shift+F11 adds a sheet, and Alt, H, O, R renames the current one. Browsers use Ctrl+PageDown to switch tabs, so on Windows this page simulates it when you click the keys.
Try it: press the keys on this sheet
Windows and Mac keys
| Action | Windows | Mac |
|---|---|---|
| Insert new sheet | Shift+F11 | ⇧F11 |
| Next sheet | Ctrl+PgDn | ⌃PgDn or ⌥→ |
| Previous sheet | Ctrl+PgUp | ⌃PgUp or ⌥← |
| Rename sheet | Alt then H then O then R | No default shortcut |
Shortcut not working?
No PageDown key on a laptop
Use Fn+Ctrl+Down Arrow on most laptops, or Ctrl+Fn+Down on Mac. On Mac Option+Right Arrow also works.
Shift+F11 shows the desktop on Mac
Mac uses F11 for Show Desktop. Press Fn+Shift+F11 or change the setting in Mission Control.
Too many sheets to cycle through
Right-click the arrows left of the sheet tabs to get a list of every sheet.
Frequently asked questions
What is the shortcut to switch sheets in Excel?
Ctrl+PageDown for the next sheet and Ctrl+PageUp for the previous one. On Mac you can also use Option+Right and Option+Left.
What is the shortcut for a new sheet?
Shift+F11 on Windows and Mac (Fn+Shift+F11 on most Mac keyboards).
How do I rename a sheet with the keyboard?
Press Alt, H, O, R, type the name and press Enter. On Mac, double-click the tab.