ShortcutdrillExcel shortcuts / grouping and structure / Insert a sheet
Insert a sheet in Excel: Shift+F11 (Mac: Fn+Shift+F11)
| Windows | Shift+F11 |
|---|---|
| Mac | Fn+Shift+F11 |
| Group | grouping and structure |
Drill: Insert a sheet. Free, no sign-up.
What it does and when to use it
Shift+F11 inserts a new worksheet in front of the current one and makes it active. Alt, H, I, S does the same through the ribbon.
The common mistake
Expecting the new sheet after the current one. It goes in front; drag or use Alt, H, O, M to move it.
Related shortcuts
- Insert a column Ctrl+Space, Ctrl+Shift+=
- Delete a blank row Shift+Space, Ctrl+-
- Group rows Alt+Shift+Right arrow
- Ungroup rows Alt+Shift+Left arrow
- Collapse the groups Alt, A, H
- The printable cheat sheet
Questions
How do I delete a sheet from the keyboard?
Alt, H, D, S deletes the active sheet, after a confirmation.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill