Learn › Excel › Add a new sheet
Excel new sheet shortcut: Shift + F11
Add a new, empty worksheet next to your first sheet in one press.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
Laptops with an Fn key: the F keys (F2, F4, F5, F11...) usually need Fn pressed together with them, for example Fn + F4. If Fn Lock is on, they work without Fn.
What it does
Shift + F11 adds a new, empty worksheet next to the ones you have. It gets a name like Sheet1, and you can rename it by double-clicking its tab.
When to use it
Use it to keep data, a summary or a chart apart from the main table, without opening a menu or clicking the plus button.
How to do it
- Press Shift + F11. On many laptops hold Fn too: Shift + Fn + F11.
- A blank sheet appears next to your first sheet.
- Double-click its tab to give it a name you will recognize.
A quick example
In the Tasks workbook, press Shift + F11: a blank sheet opens next to the Tasks sheet.
Shift + F11 and the plus button
Shift + F11 and the plus button next to the sheet tabs both add a worksheet. The shortcut is faster because your hands stay on the keyboard.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens: click into the sheet first, not into the formula bar or a search box.
- Your laptop needs Fn: on many laptops the F keys work only together with Fn, so press Shift + Fn + F11.
- The new sheet is not where you expected: Excel adds it next to the active sheet. Drag its tab to move it.
- Nothing is added: the workbook may be protected. Unprotect the structure of the workbook first.
Quick answers
What is the shortcut to add a new sheet in Excel?
Press Shift + F11. On many laptops press Shift + Fn + F11.
How do I rename the new sheet?
Double-click its tab at the bottom, type the new name and press Enter.
Is there another way to add a sheet?
Yes. Click the plus button next to the sheet tabs.

