6-Ways to Insert New Worksheet In MS-Excel: In excel spreadsheet, there are several options are there to insert the “New Worksheet”. These are whether Keyboard shortcut or other options from the ribbon. in this article, 6 different ways are provided below to insert new worksheet in excel.
Method-1:
Click the 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.
Method-2:
Shortcut Key to Insert New Worksheet in Excel- 1:
Method-3:
Shortcut Key to Insert New Worksheet in Excel -2:
- To insert more worksheets at a time, keep hold down the Shift key, then press F11 as many new worksheets as you want or, keep the press and hold down Alt + Shift key, and press then F1 as many sheets as you want.
Method-4:
- Right click on a sheet tab where you want to insert the new worksheet
- Then click on “Insert” as in the picture below.
3. After that, select the “Worksheet” under “General”, and then click ok.
Method-5
- Go to the Home tab
2. Then click on the drop-down arrow of the Insert in the Cells group
3. Afterwards, click the “Insert sheet”.
Method-6:
The last method from 6-Ways to Insert New Worksheet in MS-Excel:
- Press Alt + H→I→S
The ways to insert new worksheet in MS-Excel are very useful. So you should learn these to become master.
Read Also
- 4-Ways to Rename a Worksheet in MS-Excel
- Row Height and Column Width in Excel (Set in Several Ways):
- Accommodate Different Watermark for Different Pages in MS-Word
- Merge and Unmerge Cells in MS-Excel
- Select all Text with Similar Formatting |Word|2007 to 2019|
- Autofit Behaviour in a Table |MS-Word|
- Repeat Header Rows of a Table in MS-Word
- Repeat Header Rows of a Table in MS-Word
- Create a Link Between the Text Boxes (Shapes) in MS-Word.
FAQ
Most frequent questions and answers
- To insert more worksheets at a time, keep hold down the Shift key, then press F11 as many new worksheet as you want or, keep press and hold down Alt + Shift key, and press then F1 as many sheets as you want. Another way to insert new worksheet by using the shortcut key is Alt + H + I + S.