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

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.



"chefmike" wrote:

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

Thank you that did the trick. Why can't the help menu make that simple?

"The Toasterman" wrote:

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.



"chefmike" wrote:

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

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

"chefmike" wrote in message
...
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

mike

Which version of Excel are you using?

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

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


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 07:57:02 -0700, chefmike
wrote:

Thank you that did the trick. Why can't the help menu make that simple?

"The Toasterman" wrote:

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.



"chefmike" wrote:

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

I am using excel 2003

"Gord Dibben" wrote:

mike

Which version of Excel are you using?

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

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


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 07:57:02 -0700, chefmike
wrote:

Thank you that did the trick. Why can't the help menu make that simple?

"The Toasterman" wrote:

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.



"chefmike" wrote:

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

Thanks for the help.

"Bob Umlas" wrote:

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

"chefmike" wrote in message
...
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