Forum Discussion

Ramonpraew's avatar
Ramonpraew
Copper Contributor
May 27, 2021
Solved

Change drop down list

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 appoint...
Excel on Mac
office 365
  • StoneKiwi's avatar
    StoneKiwi
    May 27, 2021

     

    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

    The new values should now show in the dropdown list.

     

StoneKiwi's avatar
StoneKiwi
Iron Contributor
May 28, 2021
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

Resources