Forum Discussion
excel calendar add worksheet
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.
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?
