How to Create Multiple Sheets in Excel with Different Names

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. There are many default Excel Functions that we can use to create formulas. Many educational institutions and business companies use Excel files to store valuable data. Sometimes, we need more than one Excel sheet to store distinct information. In those cases, It becomes essential to create and rename the sheets to differentiate them from each other. This article will show you 3 easy ways to Create Multiple Sheets in Excel with Different Names.

How to Create Multiple Sheets in Excel with Different Names: 3 Easy Ways

MS Excel is a very useful program. We store varieties of data in Excel worksheets. So, it’s important to give a unique title for each worksheet. Only that way, users won’t get confused. There are a couple of ways available to create multiple sheets with different names in Excel. We’ll show all the methods. To illustrate, we’ll use a sample dataset as an example. For instance, the following dataset has 3 different titles for 3 sheets. Therefore, go through the methods below carefully.

1. Apply Excel VBA to Create Multiple Sheets with Different Names

In our first method, we’ll apply VBA code for creating multiple sheets with different tiles. Code lovers will like this method the most. This is also easier and takes very little effort. Now, follow the steps below to perform the task.

STEPS:

• First, go to Developer ➤ Visual Basic.

• As a result, the VBA window will pop out.
• Then, click Insert ➤ Module.
• Consequently, the Module window will appear.
• After that, copy the following code and paste it there.

Sub CreateSheets()
    Dim p As Worksheet
    Dim rng As Range
    Dim r As Range
    Set p = ActiveSheet
    Set rng = Selection.Cells
    Application.ScreenUpdating = False
    For Each r In rng
        sName = Trim(r.Text)
        If Len(sName) > 0 Then
                Worksheets.Add After:=Worksheets(Worksheets.Count)
                ActiveSheet.Name = sName
        End If
    Next r
    p.Activate
    Application.ScreenUpdating = True
End Sub

• Now, save the file and close the VBA window.
• Next, select the title range C5:C7.

• Afterward, select Developer ➤ Macros.
• Hence, the Macro dialog box will emerge.
• Lastly, choose CreateSheets and press Run.

• Thus, you’ll see 3 newly formed sheets with the desired sheet names.
• Look at the below picture to have a better understanding.

Read More: How to Create Multiple Sheets in Excel at Once

2. Get Multiple Sheets with Different Names Using Pivot Table Feature

Moreover, the Pivot Table feature can also help us to get multiple sheets with unique names. So, learn the following steps to carry out the operation.

STEPS:

• Firstly, select the range C5:C7.
• Next, click Insert ➤ PivotTable.

• Consequently, you’ll see a dialog box.
• There, press OK.

• Hence, it’ll return a new sheet.
• Here, check the box for Title under the PivotTable Fields pane.

• After that, drag the Title and place it in the Filters section.

• Then, go to the PivotTable Analyze tab.
• Select PivotTable ➤ Options ➤ Show Report Filter Pages.

• As a result, a new dialog box will appear.
• Press OK.

• Thus, it’ll return 3 new sheets with the chosen titles.

Read More: How to Create Multiple Worksheets from a List of Cell Values

3. Manually Create Multiple Sheets with Different Titles in Excel

In our last method, we’ll show how to create the sheets with desired titles manually. It’s also a straightforward process. Therefore, follow the process below.

STEPS:

• First of all, click the ‘+’ icon that you’ll find in the sheet tab present at the bottom part in excel.

• That’ll create a new sheet.
• Now, double-click the sheet title and rename it with your desired one.
• In this way, you’ll get a new sheet with a new title.
• See the below figure where we have created a new sheet named January.

Download Practice Workbook

Download the following workbook to practice by yourself.

Conclusion

Henceforth, you will be able to Create Multiple Sheets in Excel with Different Names following the above-described methods. Keep using them and let us know if you have more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

Related Articles

• How to Create Multiple Sheets with Same Format in Excel
• Understanding Excel Spreadsheets
• How to Create New Sheets for Each Row in Excel
• How to Insert Sheet from Another File in Excel

<< Go Back to  Insert Sheet | Worksheets | Learn Excel