Forum Discussion
excel calendar add worksheet
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.
- HansVogelaarJun 24, 2024MVP
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?
- ellenxswJun 24, 2024Copper Contributor
- HansVogelaarJun 24, 2024MVP
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