How do I create a list that can be used in a drop box?

J

James RB

I am new at excel and would like to create a list that I can use in a drop
down box. When i go to the help, I do what it says and can't get the data
into the list. Can you take through step by step. Any help would be
appreciated.
 
S

SJ McAbney

Firstly, this group is for Access and not Excel.

Secondly, select the cells you want to validate in Excel, go to Data ->
Validation, and select List. With this list you enter the range that you want
to appear in the list.

To provide a list from another sheet you need to use a named range as
defined in Insert -> Name
 
Top