excel calendar add worksheet

Copper Contributor

I have an excel workbook with several tabs - one per month.  I need to add the rest of the year and I can't see any way.

8 Replies


What exactly is your problem?

Don't you know how to add a worksheet? Click the + to the right of the rightmost sheet tab, or select Insert > Insert Sheet in the Cells group of the Home tab of the ribbon.

Or don't you know how to populate a new sheet? If so, please tell us more about the layout of the worksheets.


Guess I wasn't clear.   I am using a calendar template.   Yes, if course I know how to add a sheet.  But when I do, it's just a blank sheet. I have Jan-Jun, for example,  and I want to add Jul-Dec.


Try copying the Jun sheet. See if you can change the first date, hopefully the rest will follow automatically.

If you can't make it work:

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?


Thank you. That is a completely fixed calendar, adding new months would be an insane amount of work. You can download their calendar for 2025 from Vertex42 2025 Calendars 


If you want a more flexible calendar, see for example Excel Calendar Templates 

Thx. I need 24 & 25 combined.

@ellenxsw If you open both the 2024 and 2025 calendars, you can move or copy sheets from the 2025 calendar to the 2024 calendar.