Forum Discussion
Excel Monthly Personal Planner
I've downloaded the Monthly Personal Planner, but it only has 8 months listed. How do I add more months to the dropdown list? I can't even find the list anywhere in the template. This template is useless to me if I can't add months. Thanks.
Sharpe411 Oh my! Yet another example of a calendar template that isn't very useful. Looks fancy with the spiral wire to mimic a paper calendar, assuming that the workbook attached is the template you are using.
Begin by right-clicking on the Tab name "Monthly Planner" and press Unhide. Now you can unhide the Lists tab and you'll see the 8 months that feed the drop down box. These 8 months are dynamic though. 2 months back and 6 months forward from the current month. I guess the designer thought that would be sufficient. If you want 12 months, expand the list, making sure that the formulae that calculate the month and year are updated correctly.
Now that you have the "12-month calendar" (see attached), don't think you can do much with it. All you have is a digital representation of just "a paper calendar". Print each month, on-by-one, and start writing down your notes on the hard copies. The template has no built in functionality that allows you to store notes by date that can be displayed for the chosen month. Your choice, though.
9 Replies
Sharpe411 Oh my! Yet another example of a calendar template that isn't very useful. Looks fancy with the spiral wire to mimic a paper calendar, assuming that the workbook attached is the template you are using.
Begin by right-clicking on the Tab name "Monthly Planner" and press Unhide. Now you can unhide the Lists tab and you'll see the 8 months that feed the drop down box. These 8 months are dynamic though. 2 months back and 6 months forward from the current month. I guess the designer thought that would be sufficient. If you want 12 months, expand the list, making sure that the formulae that calculate the month and year are updated correctly.
Now that you have the "12-month calendar" (see attached), don't think you can do much with it. All you have is a digital representation of just "a paper calendar". Print each month, on-by-one, and start writing down your notes on the hard copies. The template has no built in functionality that allows you to store notes by date that can be displayed for the chosen month. Your choice, though.
- When I add the formula to the next cell changing to the next higher number in the lists tab, it shows up on that list but doesn't appear in the drop down box in the monthly planner. Any suggestions on what I'm doing wrong?
You need to change the range referred to in Name Manager so that it includes that new row in the Data Validation dialog box.
By the way, that is but one of several major deficiencies of this template, as Riny_van_Eekelen hinted in his first reply when this thread was started last year. All this does is produce a blank calendar to be printed and then written on; it does not store entries by month and day. You're better off using the calendar software that comes with your computer.
- Thank you! This is perfect!
