Adding more months to Monthly Personal Calendar Excel

I am trying to set up the Monthly Personal Planner template for 2024 to help plan out next year's events for the team.

However, I can only select up to March 2024 in the drop down at the top of the page.

Can someone help me set this up for the whole year? I want a tab per month down the bottom. I am not sure how to add more months to drop down so the dates prefill on the calendar.

Monthly personal planner | Microsoft Create

Cheers

Answer
Answer

Right click the sheet name, Unhide the list sheet

Image

Add more month you want in Column A, you may also delete unwanted months.

Formula>Name range > Change the refer to rang from A1:A8 to A1:AX (X is the total rows)

Image

•Beware of Scammers posting fake Support Numbers here.

3 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated December 20, 2024 Views 1,881 Applies to: