pull down lists

New Contributor

ad9a6a79-701e-4938-af6c-d088a484545d.png

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

@scottJacobs 

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 

 

Hans,

 

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