In an excel spreadsheet, there are several options there to insert the “New Worksheet”. These are whether the Keyboard shortcuts or other options from the ribbon. in this article, 6 different ways are provided below to insert a new worksheet in excel.
Table of Contents
1. Click New Sheet Tab Button
Click on the “New Sheet” button, which appears at the right of the existing worksheet tabs as given in the picture below.
2. Shortcut Key to Insert a New Worksheet
To insert a New Worksheet in excel by using the shortcut keys, Press Shift+F11 or Alt+Shift+F1.
3. Shortcut Key to Insert New Worksheet in Excel
To insert more worksheets at a time, keep holding down the Shift key, then press F11 as many new worksheets as you want or, keep the press and holding down Alt + Shift key, and press then F1 as many sheets as you want.
Right-click on a sheet tab where you want to insert the new worksheet
Then click on “Insert” as in the picture below.
After that, select the “Worksheet” under “General”, and then click ok.
Go to the Home tab
Then click on the drop-down arrow of the Insert in the Cells group
Afterwards, click the “Insert sheet”.
- Press Alt + H→I→S
The ways to insert new worksheets in MS Excel are beneficial. So it would be best if you learned these to become a master.
What are the shortcut keys to insert a new worksheet in Excel?
To insert more worksheets at a time, keep holding down the Shift key, then press F11 as many new worksheets as you want or, keep pressing and holding down the Alt + Shift key, and press then F1 as many sheets as you want. Another way to insert a new worksheet by using the shortcut key is Alt + H + I + S.