Listbox

[JV]

How do I create a drop down listbox in excel??

 

[Debra Dalgleish]

You can use Data>Validation to create a dropdown list in a cell. There
are instructions here:

http://www.contextures.com/xlDataVal01.html

 

[Arvi Laanemets]

Hi

Select the cell. Data.Validation.List

The dropdown list can be created in 3 ways
1. You enter the list directly into source field, like 'First, Second,
Third'
2. You refer in source field to list in range on same worksheet, like
'=$F$2:$F$10'
3. You refer in source field to named range (only way you can access list on
another worksheet), like '=MyList' - you can create a named range selecting
Insert.Name.Define from menu.


Arvi Laanemets