Create list to choose from

D

Dianah

Hi,
I'm just trying to create a short pulldown list in a spreadsheet. Instead
of having to retype repetitve selections for this spreadsheet that gets used
a lot, I'd like to create a pulldown list, but I'm not sure which kind of
list to choose and I'm not sure how to enter the list.

Can anyone help.
Thanks a bunch.
Diana
 
D

Dianah

Yes ... that's what I discovered.
Now I need to figure out where I should store the list.
Thanks Julie.
 
J

JulieD

Hi Dianah

the common approach is to store the list on another sheet, name the list and
then refer to the name of the list in the data validation source

Cheers
JulieD
 
Top