pull down lists

New Contributor


How do I modify a pulldown list.


The source for the list named =Voltage. There is no table visible when I select data validation.

I need to find =Voltage to add more choices. How do I find it?


2 Replies


Close the dialog.

Press F5 to activate the Go To dialog.

Select Voltage and click OK.


Or click Name Manager on the Formulas tab of the ribbon.

Select Voltage and inspect its definition.

@Hans Vogelaar 




Using the Name manager got me the information I was looking for. Thanks!