Insert New Worksheet in Excel

A worksheet is a sheet in a workbook. The workbook is the name of an Excel file, and that workbook contains one or more worksheets.

The worksheet is a single page inside a file designed with an electronic spreadsheet program like Microsoft Excel. The worksheet is used to accumulate data or to work with data. We all know that we cannot work on a single worksheet in Excel as it has a limited number of cells, rows, and columns. Therefore, we need to have multiple worksheets with a big database.

We also need to know how to insert a new worksheet in excel on the existing worksheet. Again, this has been explained above through various examples.

We have learned these ways to insert a worksheet into an excel file:

1. Using Excel Shortcut Keys.
2. Using Insert Tab

There are multiple ways to insert a new worksheet in excel. Inserting a new worksheet is quite simple.

Let us discuss it one by one with a few examples.

There are two shortcut keys to insert a new worksheet in Excel, They are:

Alt + Shift Shortcut #1

Shift + F11 Shortcut #2

Step #1 - Click on the ‘SHIFT” button from the keyboard.

Step #2 - Click on the ‘F11’ key from the keyboard & release it.

Step #3 - Now release the "shift" key.

Now, we will add a new worksheet to an open workbook.

Step #1 - We will find a "+" sign at the bottom of the sheet highlighted in dark red in a workbook.

Step #2 - Click on the "+" sign to insert a new worksheet in Excel, as shown below.

There is another way to insert a new worksheet in Excel. Let us understand it with an example.

Step #1 - Open a new workbook, as shown below.

Step #2 - Now, right-click on the existing sheet named as ‘Sheet1’ by default

Step #3 - From the above image, click on the "INSERT" option to insert anything. Then, you will get a pop-up, as shown below.

Step #4 - Now, select the "Worksheet" option to insert a new worksheet and click on the "OK" button.

From the above image, we can see the second sheet, named "Sheet 2." By default, this is the sheet inserted by us using the third procedure.

Let us see a new way to insert a new worksheet in Excel, which is another easy and simplest way to insert a worksheet. In this procedure, we will use the "INSERT" option available in the Ribbon bar of an excel.

Let us understand it with the help of an example.

Step #1 - Open a new workbook, as shown below.

Step #2 - Click on the ‘Home’ tab available in the Ribbon bar of a workbook.

Step #3 - We may find an "Insert" tab on the right side of a ribbon bar under the "Home" tab.

Step #4 - Now, click on the "Insert" icon available on the right side of the ribbon bar to open a drop-down list of options to be selected.

Step #5 - We will find an "Insert Sheet" option available at the end of the drop-down list.

Step #6 - Click on the "Insert Sheet" option available at the end of the drop-down list to insert a new worksheet in Excel, as shown below.

The above figure shows that the second sheet named "Sheet2" has been added to a workbook.

1. A workbook can contain 255 Worksheets.
2. A workbook may be slow to use with many worksheets and formulas.

This article is a guide to Insert New Worksheet In Excel. Here, we discuss inserting a new worksheet in Excel using shortcut keys and practical examples. You may learn more about Excel from the following articles: -

• Protect Sheet in VBA
• Rows and Columns in Excel
• Group Worksheets In Excel
• Protect Sheet in Excel