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
