Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Create Multiple Sheets in Excel at Once (3 Quick Ways)

If you are searching for the solution or some special tricks to create multiple sheets in Excel at once then you have landed in the right place. Sometimes, you may need to create multiple sheets with same format in Excel, sometimes, you want create multiple new worksheets in Excel. There are some easy ways to create multiple sheets in Excel at once. This article will show you each and every step with proper illustrations so, you can easily apply them for your purpose. Let’s get into the central part of the article.


Download Practice Workbook

You can create your own file in XLSM format and apply the methods described here, or download the following Excel file and practice the methods.


3 Methods to Create Multiple Sheets in Excel at Once

In this section, I will show you 3 quick and easy methods to create multiple sheets in Excel at once on Windows operating system. You will find detailed explanations of methods and formulas here. I have used Microsoft 365 version here. But you can use any other versions as of your availability. If any methods don’t work in your version then leave us a comment.

1. Click ‘New sheet’ Button on Right Side of Sheet Tabs Multiple Times

You can simply create multiple worksheets by clicking the Plus icon beside the name of the sheets. After clicking once it will create one new worksheet and clicking each time on the New Sheet button or the plus icon, it will create one new worksheet.

How to Create Multiple Sheets in Excel at Once

Read More: How to Create Tabs Within Tabs in Excel (with Simple Steps)


2. Select Multiple Sheet Tabs with Ctrl Key and Copy Them

You may need to create a copy of multiple sheets at once. For this, Excel has a built-in feature. Follow the steps below:

📌 Steps:

  • First, you have to select the worksheets. For this, hold the Ctrl key on the keyboard and click on the name of the sheet one by one to select

How to Create Multiple Sheets in Excel at Once

  • When the selection of sheets is done, then right-click on them to open options.
  • From the options, select the Move or Copy

How to Create Multiple Sheets in Excel at Once

  • Then, the Move or Copy window will appear.
  • Mark the button saying “Create a Copy”.
  • Then, press OK.

How to Create Multiple Sheets in Excel at Once

  • As a result, you will see there will create new sheets which are the copy of the previously selected sheets.

How to Create Multiple Sheets in Excel at Once

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


3. Use VBA Macro to Create Multiple Sheets from One Sheet at Once

If you want to create multiple copy sheets from one sheet at once then you can use a VBA macro code. Here, I will share with you the code and show you how you can apply them to a workbook.

📌 Steps:

  • For this, first, go to the top ribbon and press on the Developer option, and then press on the Visual Basic option from the menu.

You can use ALT + F11 to open the Microsoft Visual Basic for Applications window if you don’t have the Developer tab added.

Using Excel VBA Macro

  • Now, a window named “Microsoft Visual Basic for Applications” will appear. Here from the top menu bar, press on the “Insert” And a menu will appear. From them, select the “Module’” option.

Using Excel VBA Macro

  • Now, a new “Module” window will appear. And Paste this VBA code into the box.
Sub CreateMutipleWorksheet()
Dim X_Num As Integer
Dim X_WS_Name As String
On Error Resume Next
xTitleId = "Create Multiple Similar Worksheet"
X_WS_Name = Application.InputBox("Name of Worksheet To Copy", xTitleId, , Type:=2)
X_Num = Application.InputBox("Number of Copy", xTitleId, , Type:=1)
For i = 1 To X_Num
Application.ActiveWorkbook.Sheets(X_WS_Name).Copy _
After:=Application.ActiveWorkbook.Sheets(X_WS_Name)
Next
End Sub

Use VBA Macro

  • To run the code go to the top menu, press on the Run option, and here will open some other options and select the Run Sub/UserForm also you can simply press F5 to run the code.

Using Excel VBA Macro

  • When you run the code, a window will appear named “Create Multiple Similar Worksheet”.
  • Then, insert the name of the worksheet that you want to copy in the box and press OK

Use VBA Macro

  • After that, one more window will appear and will ask you to enter the number of copies that you want to create for the selected worksheet.
  • After inserting the number press OK.

Use VBA Macro

  • As a result, you will see there will create 3 copies of the selected worksheet.

Use VBA Macro

Read More: How to Create New Sheets for Each Row in Excel (4 Quick Ways)


Conclusion

In this article, you have found how to create multiple sheets in Excel at once. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Osman Goni Ridwan

Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo