Aung Shine
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
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.
- 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.
