The Sheet tabs guide
Each tab at the bottom is a sheet. Click + to add one, double-click a tab to rename it, and move between sheets with Ctrl+Page Down and Ctrl+Page Up (⌥+→ and ⌥+← also work in Excel for Mac).
Add a sheet
- The + button next to the tabs adds a new sheet after the one you're on.
- Shift+F11 adds one too, before the one you're on in Windows Excel. On a Mac laptop it's fn+⇧+F11, and macOS may use F11 for Show Desktop.
A sheet in the wrong place can be dragged along the tab bar, or moved with right-click → Move or Copy.
Rename it
Double-click the tab, type the name and press Enter, or right-click → Rename. Microsoft's rules: not blank, at most 31 characters, none of / \ ? * : [ ], no apostrophe at the start or end, and not "History". Formulas that point at the sheet, like =Mar!B5, follow the new name.
Move between sheets
Ctrl+Page Down goes to the next sheet, Ctrl+Page Up to the previous one. On a laptop without Page keys, hold fn with the arrow keys. In a browser those keys switch the browser's own tabs and a web page never sees them, so in this practice sheet you click the tabs (or use ⌥+arrow on a Mac).
Common mistakes
- Renaming the wrong tab. Double-clicking Mar instead of the new sheet loses the March name, and the data looks like April's. Undo straight away.
- The new sheet in the wrong place. + adds after the sheet you're on: click the last tab first.
- Names that don't match. "April" next to Jan, Feb and Mar breaks the pattern people scan for.
To use a number from another sheet in a formula, see references to other sheets.
FAQ
- What is the shortcut to switch sheets in Excel?
- Ctrl+Page Down for the next sheet and Ctrl+Page Up for the previous one. Excel for Mac also takes Option+Right arrow and Option+Left arrow.
- How do I add a new sheet in Excel?
- Click the + next to the sheet tabs, which adds one after the sheet you're on, or press Shift+F11.
- How do I rename a sheet in Excel?
- Double-click its tab, type the new name and press Enter. Right-click → Rename does the same.
- Why can't I name a sheet the way I want?
- Sheet names can't be blank or longer than 31 characters, can't contain / \ ? * : [ ], and can't start or end with an apostrophe.



































































