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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top