SOLVED

Change drop down list

%3CLINGO-SUB%20id%3D%22lingo-sub-2392587%22%20slang%3D%22en-US%22%3EChange%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2392587%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20microsoft%20365%20and%20want%20to%20use%20this%20template.%20I%20would%20like%20to%20change%20%2F%20add%20more%20wording%20in%20%25%20complete%20drop%20down%20list%20%3B%3C%2FP%3E%3CP%3E0%25%20to%200%25%20prospect%3C%2FP%3E%3CP%3E25%25%20to%2025%25%201st%20appointment%3C%2FP%3E%3CP%3E50%25%20to%2050%25%202rd%20appointment%26nbsp%3B%3C%2FP%3E%3CP%3E75%25%20to%2075%25%20....%3C%2FP%3E%3CP%3E100%25%20to%20100%25%20complete%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2392587%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2393897%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2393897%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EThe%20cell%20dropdown%20options%20should%20be%20coming%20from%20a%20range%20(a%20list%20of%20possible%20values)%20that%20is%20referenced.%3CBR%20%2F%3E%26gt%3B%20Add%20or%20change%26nbsp%3B%20values%20in%20the%20current%20list%20(wherever%20it%20is)%3CBR%20%2F%3E%26gt%3B%20Select%20the%20cells%20with%20the%20dropdown%20menu%3CBR%20%2F%3E%26gt%3B%20Click%20Data%20Tab%20%26gt%3B%20Data%20Validation%3CBR%20%2F%3E%26gt%3B%20Change%20the%20Source%20range%20to%20include%20your%20new%20values%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22StoneKiwi_0-1622152672322.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F284472i24F7EB1139C62517%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22StoneKiwi_0-1622152672322.png%22%20alt%3D%22StoneKiwi_0-1622152672322.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20new%20values%20should%20now%20show%20in%20the%20dropdown%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2394334%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20drop%20down%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2394334%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1064976%22%20target%3D%22_blank%22%3E%40Ramonpraew%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EHi%2C%3CBR%20%2F%3EAre%20you%20using%20Excel%20on%20an%20Ipad%3F%3CBR%20%2F%3EUnfortunately%20these%20features%20are%20not%20available%20on%20the%20Ipad%20version%20of%20Excel.%3CBR%20%2F%3EYou%20will%20need%20to%20open%20the%20Excel%20file%20on%20a%20PC%20and%20follow%20my%20previous%20instructions%20then%20send%20the%20file%20back%20to%20your%20Ipad%20for%20it%20to%20work.%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%2C%3CBR%20%2F%3EStoneKiwi%3C%2FLINGO-BODY%3E
New Contributor

I am using microsoft 365 and want to use this template. I would like to change / add more wording in % complete drop down list ;

0% to 0% prospect

25% to 25% 1st appointment

50% to 50% 2rd appointment 

75% to 75% ....

100% to 100% complete

 

Is it possible?

 

4 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

 

Hi,

The cell dropdown options should be coming from a range (a list of possible values) that is referenced.
> Add or change  values in the current list (wherever it is)
> Select the cells with the dropdown menu
> Click Data Tab > Data Validation
> Change the Source range to include your new values

StoneKiwi_0-1622152672322.png

The new values should now show in the dropdown list.

 

@StoneKiwi thank for your kindness but there is no “data validation” in data tab ... 

@Ramonpraew

Hi,
Are you using Excel on an Ipad?
Unfortunately these features are not available on the Ipad version of Excel.
You will need to open the Excel file on a PC and follow my previous instructions then send the file back to your Ipad for it to work.

Regards,
StoneKiwi

@StoneKiwi I see. Best regards.