Create list to choose from

[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

 

[JulieD]

Hi Dianah

i'ld go with data / validation
check out Debra Dalgleish's site for details
http://www.contextures.com/xlDataVal01.html

cheers
JulieD

 

[Dianah]

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

 

[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