If you are like most Excel users, you would work with large data sets and there are times when you need to add new sheets to your Excel workbook.
Perhaps you want to track different data sets or keep different parts of the workbook separate. Regardless of the reason, adding a new sheet is a quick and easy process.
In this article, we will discuss how to add new sheets in Excel using shortcuts.
By default, a new Excel workbook will contain just one sheet. In earlier versions of Excel (2013 or 2016), there were three sheets by default.
Keyboard Shortcut to Add New Sheet in Excel
Here is the keyboard shortcut to Add New Sheet in Excel
Here is the keyboard shortcut to Add New Sheet in Excel
SHIFT + F11
As an alternative, you can also use the shortcut option ALT + SHIFT + F1 which will also get the job done.
How to Use the Keyboard Shortcut to Add New Sheet in Excel
Here are the steps to use the keyboard shortcut mentioned above:
- In the Excel workbook, go to the sheet to the left to which you want to add a new sheet.
- After that, just press the keyboard shortcut keys Shift + F11
- Or you can also use Alt + Shift + F1 (hold the ALT and the SHIFT keys and press the F1 key) and you will get the new sheet added.
If you want to add multiple new sheets, you can continue to hold the Shift key and then press the F11 key multiple times.
Also read: Shortcut to Hide a Sheet in Excel
Some Useful Things to Know About Adding New Sheets in Excel
An important thing to note for users with smaller keyboards is to use the F keys (F1, F2, F3) effectively in Excel shortcuts.
Many keyboards, mostly laptop ones which are smaller have an Fn key.
The Fn key serves as a space-saving option on smaller keyboards and allows laptop makers to have multiple assignments for a single key.
For many laptop models, the F keys are enabled in the default settings. However, if you have a laptop keyboard where the F key is the alternative option, it is recommended that the Fn key be enabled in that case.
This will allow you to use the Keyboard shortcut (Shift + F11) to add New Sheet in Excel easily without the need to press additional keys (Fn key) every time.
Other Excel shortcuts you may also like: