drop down list

C

chefmike

Can anybody tell how to make a drop down list? I have a list of about 15
numbers I want to put into a drop down list in a specific cell. I have read
the help files and still don't understand how to do it. Any help would be
great.
Thanks in advance
mike
 
T

The Toasterman

Use validation in DATA

i.e: data / validation in allow select LIST & you make your list elsewhere
in your worksheet & in the data field select the list. You can hide your list
later.
 
B

Bob Umlas

you don't even need to have the list elsewhere in the workbook. you can
simply type the list, separated by commas, in the space provided, like
2,5,43,6,54,5,345,65,51,3,4,6,34
 
G

Gord Dibben

mike

Which version of Excel are you using?

Excel 2002 and 2003...................

Help>drop-down returns "how to create a drop-down list using Data Validation"


Gord Dibben MS Excel MVP
 
C

chefmike

I am using excel 2003

Gord Dibben said:
mike

Which version of Excel are you using?

Excel 2002 and 2003...................

Help>drop-down returns "how to create a drop-down list using Data Validation"


Gord Dibben MS Excel MVP
Click to expand...
 
C

chefmike

Thanks for the help.

Bob Umlas said:
you don't even need to have the list elsewhere in the workbook. you can
simply type the list, separated by commas, in the space provided, like
2,5,43,6,54,5,345,65,51,3,4,6,34
Click to expand...
 
Top