6-Ways to Insert New Worksheet In Microsoft Excel

27/04/2019
No Comments
Share

6-Ways to Insert New Worksheet In Excel:

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:

  1. Click on the “New Sheet” button, which appears at the right of the existing worksheet tabs as given in the picture below.
Insert New Worksheet in Excel
Create a New Worksheet in Excel

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.
5-Ways-to-Insert-New-Worksheet-In-MS-Excel
Inserting new worksheet in excel by using the right click

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

Insert New Worksheet In MS-Excel by right click
Inserting New Worksheet In MS-Excel by right clicking the sheet tab

Method-5

  1. Go to the Home tab
Insert New Worksheet by using insert command
Home tab in Excel

2.  Then click on the drop-down arrow of the Insert in the Cells group

3.  Afterwards, click the “Insert sheet”.

Insert New Worksheet In MS-Excel by using insert command
Insert New worksheet from the Home tab in Excel

Method-6:

The last method from 6-Ways to Insert New Worksheet in MS-Excel:

  1. Press Alt + H→I→S
Insert new worksheet
Another way to insert new sheet by pressing 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

  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

Most frequent questions and answers
  1. 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.