Excel

Copper Contributor
I want to add to a drop down list. I’m not able to find the table where list is kept. I can see the name of the table.
1 Reply

Hello @Randy59,

 

Click on the cell containing the drop-down list. With this cell selected, go under the Data Tab into the section labeled Data Tools. Click Data Validation. Under the settings tab, you will find the source of your list. It can either be an array of cells (i.e. $A$1:$A$10) or a manually input list (i.e. Option 1, Option 2, Option 3,....).

 

I hope this helps!
PReagan