Let A2:A10 in Sheet1 house a list of items that you want to display in some other cell, possibly in another worksheet, as a dropdown list from which a selection can be made.On 2002-12-03 01:37, Brambo wrote:
I have seen that it is possible to use a pull down menu for a particualr cell which shows all possible values. These values are defined in another part of Excell. Could anybody tell how to create a pull down menu, many thanks in advance.
(1.) Select A2:A10.
(2.) Go to the Name Box on the Formula Bar.
(3.) Type, e.g., SList (from source list) and hit enter.
(4.) Activate the target cell where you want to have the dropdown list ("menu").
(5.) Activate Data|Validation.
(6.) Choose List for Allow.
(7.) Enter the following in the Source box:
(8.) Click OK.
Advanced Note. If A2:A10 is part of a larger data area that already has a name, say DTable, you can use this existing name in data validation instead of creating a new name by entering the following in the Source box...
which will show all items in column 1 of DTable.