Insert New Worksheet in Excel (All Things to Know)

In this article, we will basically learn how to insert a new worksheet in Excel. Moreover, we’ll show how to rename, move, and delete worksheets.

One significant advantage of inserting a new worksheet is the effective organization of spreadsheet solutions. By using multiple sheets in a workbook, you can separate inputs, data, calculations, reports, and visuals, improving data organization.

Each worksheet serves as a space to store data, input formulas, create charts, and generate reports and dashboards. Lastly, utilizing multiple worksheets enables efficient data management and calculations in Excel.

Download Practice Workbook

You can download the practice workbook for free.

How to Insert New Worksheet in Excel

Method 1: Clicking Plus Icon (New sheet Button) to Insert New Worksheet in Excel

Click on the Plus icon (+) at the bottom of the workbook.

As a result, a new worksheet named Sheet2 appears.

Method 2: Add New Worksheet Through Insert Sheet Command in Excel

Go to Home tab >> Click Insert >> Insert Sheet.

Thus, we get a new worksheet in our dataset.

Method 3: Using Shortcut Keys to Add New Worksheet in Excel

Press Alt + Shift shortcuts to add a new worksheet >> or press Shift + F11.

Method 4: Worksheet Option in Insert Dialog Box

First, right-click on the existing sheet name >> tap Insert.

In the Insert dialog, tap on Worksheet >> OK.

Read More: Create Multiple Sheets at Once

Method 5: Insert New Sheet Through Excel VBA in One Go

Example 1: Using VBA Code in Immediate Window

Initially, go to Developer tab >> Visual Basic.

In the Visual Basic window, click View >> Immediate Window.

Now, type the following code in Immediate window and press Enter:

Sheets.Add Count:=5

Hence, 5 new worksheets appear as shown in the below image.

Example 2: Using VBA Code in Module

Select the headers >> go to Developer tab >> Visual Basic.

Tap on Insert >> Module.

In the Module box, type the VBA code and click Run:

Sub Insert_New_Sheet()
    Dim rngSelection As Range
    Dim isExistingSheet As Boolean
    Set rngSelection = Selection
    For Each cell In rngSelection.Cells
        isExistingSheet = False
        For Each worksheetItem In ThisWorkbook.Worksheets
            If worksheetItem.Name = cell.Value Or cell.Value = "" Then
                isExistingSheet = True
            End If
        Next worksheetItem
        If Not (isExistingSheet) Then
            Sheets.Add.Name = cell.Value
        End If
    Next cell
End Sub

Thus, we obtain 5 new sheets named according to the selected headers.

Read More: Create Multiple Sheets with Same Format

How to Rename a Worksheet in Excel

Double-click on the existing sheet name >> type the new name.

How to Move a Worksheet in Excel

Right-click on the existing sheet Move >> tap Move or Copy.

In the Move or Copy dialog, click on (move to end) >> OK.

As a result, the Move sheet moves to the end of the workbook.

How to Delete a Worksheet in Excel

Right-click on the sheet name you wish to remove >> click Delete.

Things to Remember

• A single workbook has the capacity to hold up to 255 worksheets.
• All the methods for inserting a new worksheet in Excel position it to the left of the currently active worksheet except the New sheet method.
• By default, a new Excel workbook includes a single worksheet, though earlier versions may have three.

Frequently Asked Questions

• How many rows or columns are there in an Excel Worksheet?

An Excel worksheet has 16384 columns and 1048576 rows.

• How to insert a new worksheet to the right in Excel?

The New sheet button or Plus icon is the easiest way to insert a new worksheet to the right side of the existing one.

Insert New Worksheet in Excel: Knowledge Hub

Conclusion

In conclusion, we have learned how to insert new worksheet in Excel. We have also discussed how to rename, move and delete a worksheet in Excel. Now, we can use the new worksheet for our projects. For further inquiries, let us know in the comment box. Thank you for your read.

<< Go Back to Worksheets | Learn Excel