Creating multiple tabs at once

Question

Creating multiple tabs at once

Brooks, Kevin 20

How do I create multiple tabs at the same time in Excel. I want to do a tab for each day of the month. Do I do it one at a time using copy?

0 comments

Answer accepted by question author

Hendrix 1,670 Independent Advisor

Hi Kevin,

You do not need to copy the tab 30 times manually. In this case, the quickest method is to use a short macro. You can follow these steps:

First, design one worksheet as your daily template and rename that worksheet "Template".
Press Alt + F11 (or Alt + Fn + F11) to open the Visual Basic Editor.
Select Insert > Module and paste this script:

Sub CreateDailyTabs()
    Dim dayNumber As Integer
    Dim numberOfDays As Integer
    Dim templateSheet As Worksheet
    numberOfDays = Day(DateSerial(Year(Date), Month(Date) + 1, 0))
    Set templateSheet = Worksheets("Template")
    For dayNumber = 1 To numberOfDays
        templateSheet.Copy After:=Worksheets(Worksheets.Count)
        ActiveSheet.Name = Format(DateSerial(Year(Date), Month(Date), dayNumber), "mmm dd")
    Next dayNumber
End Sub

Press F5 to run it. The macro automatically determines whether the current month has 28, 29, 30, or 31 days and creates tabs named, for example, Oct 01, Oct 02, and Oct 03, etc.

Hope this will help. Should you need further assistance, please feel free to reach out again in the comments on this post. I'm happy to help.

Brooks, Kevin 20 Reputation points

2026-10-01T21:41:36.49+00:00

Yes, it worked the 1st time I tried. You are awesome!

Thank you
Hendrix 1,670 Reputation points Independent Advisor

2026-10-01T22:00:04.4266667+00:00

Hi Kevin,

I am glad to hear that the information shared was helpful to you.

If you have any concerns or need further assistance in the future, please don’t hesitate to reach out again. Not only will I be happy to assist you, but all users and moderators in the Q&A forum will also do their best to provide support and guidance.

Wishing you a wonderful day ahead.

1 additional answer

Your answer

Brooks, Kevin 20 Reputation points

2026-10-01T21:41:36.49+00:00

Yes, it worked the 1st time I tried. You are awesome!

Thank you
Hendrix 1,670 Reputation points Independent Advisor

2026-10-01T22:00:04.4266667+00:00

Hi Kevin,

I am glad to hear that the information shared was helpful to you.

If you have any concerns or need further assistance in the future, please don’t hesitate to reach out again. Not only will I be happy to assist you, but all users and moderators in the Q&A forum will also do their best to provide support and guidance.

Wishing you a wonderful day ahead.

Answer 1

Excel does not provide a documented way here to create all 31 tabs in one action.

What is supported:

To add a new sheet, select New sheet at the bottom of the workbook.
To copy an existing worksheet in the same workbook, either:
- press CTRL and drag the worksheet tab to the new location, or
- right-click the worksheet tab, select Move or Copy, select Create a copy, choose where to place it, and select OK.
In Excel for the web, right-click the tab name and select Duplicate.

If each day tab should have the same layout, copying an existing template sheet is the supported approach. Based on the available guidance, that would need to be repeated for each tab needed.

If the workbook becomes large, sheet tab colors can also help organize the tabs.