Editing Drop Down Menu in Personal Monthly Planner template

%3CLINGO-SUB%20id%3D%22lingo-sub-3259020%22%20slang%3D%22en-US%22%3EEditing%20Drop%20Down%20Menu%20in%20Personal%20Monthly%20Planner%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3259020%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20downloaded%20the%20monthly%20planner%20but%20found%20that%20it%20did%20not%20contain%20all%2012%20months%20in%20the%20drop%20down%20menu%20at%20the%20top%20of%20the%20form.%26nbsp%3B%20I%20have%20read%20the%20Help%20topics%20on%20creating%20and%20editing%20drop%20down%20menus%20but%2C%20as%20I%20didn't%20create%20this%20template%2C%20I%20don't%20know%20where%20to%20find%20the%20worksheet%20that%20created%20the%20original%20drop%20down%20content.%3C%2FP%3E%3CP%3EHow%20do%20I%20add%20more%20months%20to%20the%20drop%20down%3F%26nbsp%3B%20And%2C%20for%20next%20year%2C%20how%20do%20I%20add%20the%202023%20months%20and%20align%20the%20start%20date%20with%20appropriate%20day%20of%20the%20week%3F%3C%2FP%3E%3CP%3EThanks%20all!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3259020%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3259044%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20Drop%20Down%20Menu%20in%20Personal%20Monthly%20Planner%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3259044%22%20slang%3D%22en-US%22%3EHi%20Riny%2C%20I%20agree%20the%20templates%20can%20be%20a%20pain%20in%20the%20lower%20gastro-intestinal%20region.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20just%20found%20another%20template%20that%20is%20more%20easily%20edited%20to%20fit%20my%20organization's%20needs.%20Thanks%20for%20helping%20out!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3259034%22%20slang%3D%22en-US%22%3ERe%3A%20Editing%20Drop%20Down%20Menu%20in%20Personal%20Monthly%20Planner%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3259034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1334943%22%20target%3D%22_blank%22%3E%40guydlines%3C%2FA%3E%26nbsp%3BExactly%20which%20template%3F%20There%20are%20many%20out%20there.%20Most%20are%20notoriously%20difficult%20to%20adjust%20to%20ones%20own%20needs.%20Hidden%20worksheets%2C%20complicated%20named%20formulae.%20You%20name%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have downloaded the monthly planner but found that it did not contain all 12 months in the drop down menu at the top of the form.  I have read the Help topics on creating and editing drop down menus but, as I didn't create this template, I don't know where to find the worksheet that created the original drop down content.

How do I add more months to the drop down?  And, for next year, how do I add the 2023 months and align the start date with appropriate day of the week?

Thanks all!

2 Replies

@guydlines Exactly which template? There are many out there. Most are notoriously difficult to adjust to ones own needs. Hidden worksheets, complicated named formulae. You name it.

Hi Riny, I agree the templates can be a pain in the lower gastro-intestinal region.

I just found another template that is more easily edited to fit my organization's needs. Thanks for helping out!