6-Ways to Insert New Worksheet In Microsoft Excel

How to Insert New Worksheet In MS-Excel: In an excel spreadsheet, there are several options are 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.

Method-1:

Click the New Sheet Tab Button:

1. 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:

1. To insert a New Worksheet in excel by using the shortcut keys, Press Shift+F11 or Alt+Shift+F1.

Method-3:

Shortcut Key to Insert New Worksheet in Excel -2:

1. 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:

1. Right click on a sheet tab where you want to insert the new worksheet
2. Then click on “Insert” as in the picture below.

3.  After that,  select the “Worksheet” under “General”, and then click ok.

Method-5

1. 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:

1. Press Alt + H→I→S

The ways to insert new worksheets in MS-Excel are very useful. So you should learn these to become a master.

Read Also

1. 4-Ways to Rename a Worksheet in MS-Excel
2. Row Height and Column Width in Excel (Set in Several Ways):
3. Accommodate Different Watermark for Different Pages in MS-Word
4. Merge and Unmerge Cells in MS-Excel
5. Select all Text with Similar Formatting |Word|2007 to 2019|
6. Autofit Behaviour in a Table |MS-Word|
7. Repeat Header Rows of a Table in MS-Word
8. Repeat Header Rows of a Table in MS-Word
9. Create a Link Between the Text Boxes (Shapes) in MS-Word.

FAQ: