Forum Discussion

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
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

Iron Contributor

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.

Ramonpraew
Copper Contributor
May 28, 2021
StoneKiwi thank for your kindness but there is no “data validation” in data tab ...
- 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
  - Ramonpraew
    Copper Contributor
    May 28, 2021
    StoneKiwi I see. Best regards.