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.


Download Practice Workbook

Download the following workbook to practice by yourself.


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

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 (3 Quick Ways)


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.

Get Multiple Sheets with Different Names Using Pivot Table Feature

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

Get Multiple Sheets with Different Names Using Pivot Table Feature

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

Get Multiple Sheets with Different Names Using Pivot Table Feature

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

Get Multiple Sheets with Different Names Using Pivot Table Feature

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

Get Multiple Sheets with Different Names Using Pivot Table Feature

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

Get Multiple Sheets with Different Names Using Pivot Table Feature

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

Get Multiple Sheets with Different Names Using Pivot Table Feature

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


Similar Readings


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.

Manually Create Multiple Sheets with Different Titles 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.

Manually Create Multiple Sheets with Different Titles in Excel

Read More: How to Create Multiple Sheets with Same Format in Excel (4 Ways)


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. Follow the ExcelDemy website for more articles like this. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Aung

Aung

I'm Aung. Recently I earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo