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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James RB - 17 Jan 2005 05:31 GMT

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.

Reply to this Message

SJ McAbney - 17 Jan 2005 10:21 GMT

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

Reply to this Message