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.

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Insert New Worksheet in Excel (wallstreetmojo.com)

How to Insert a New Worksheet in Excel?

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

  • Using Excel Shortcut KeysExcel Shortcut KeysAn Excel shortcut is a technique of performing a manual task in a quicker way.read more.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.

Example #1 – Shortcut Keys for Insert New Worksheet In Excel

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.

  • Click on the “ALT” button from the keyboard u0026 hold it. Now click on the “Shift” button from the keyboard u0026 hold it along with the “ALT” button. Click on the “F1” key from the keyboard u0026 then release it. Now release the alt and shift keys.Now, we will add a new worksheet to an open workbook.

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.

Example #2 – To Insert a New Worksheet Using the Mouse

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.

Example #3

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.

Example #4

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.Ribbon Bar Of An Excel.Ribbons in Excel 2016 are designed to help you easily locate the command you want to use. Ribbons are organized into logical groups called Tabs, each of which has its own set of functions.read more

Let us understand it with the help of an example.

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.

Things to Remember in Insert a New Worksheets in Excel

  • A workbook can contain 255 Worksheets.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 VBAProtect Sheet In VBAVBA Protect Sheet is an In-built function that protects the worksheet with a password & prohibits the users from editing, deleting, or moving the contained data. read moreRows and Columns in ExcelRows And Columns In ExcelA cell is the intersection of rows and columns. Rows and columns make the software that is called excel. The area of excel worksheet is divided into rows and columns and at any point in time, if we want to refer a particular location of this area, we need to refer a cell.read moreGroup Worksheets In ExcelGroup Worksheets In ExcelGrouping gives the best results to users when the same type of data is presented in the cells of the same addresses. Grouping also improves the accuracy of data and eliminates the error made by a human in performing the calculations.read moreProtect Sheet in ExcelProtect Sheet In ExcelWhen we don’t want any other user to make changes to our worksheet, we can use the Protect worksheet feature in Excel. It can be found in Excel’s Review tab. read more