Create list to choose from

  • Thread starter Thread starter Dianah
  • Start date Start date
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
 
Yes ... that's what I discovered.
Now I need to figure out where I should store the list.
Thanks Julie.
 
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
 
Back
Top