Hi
Select cells you want to have drop-downs.
From menu, select Data.Validation
In Allow field select 'List'
Into Source field enter the your list of selections, or reference to such
list in a cell range. Like:
'Value1,Value2,...,ValueN'
or
=$X$1:$X$10
or
=ListRange
where ListRange is a named range on any sheet of workbook.
NB! In 2nd example you can refer only to range on same sheet!
Values in list can be numbers or texts or dates - whatever you like. When
you format cells containing the list, the dropdown is displayed as you did
format source cells. But you have to format the cell with dropdown
separately.
An example:
Into range E1:E3 enter dates {01.01.2004}, {01.02.20040, {01.03.2004}
Format the range E1:E2 as Custom "mmmm" - Janyary, February and March are
displayed
Select cell A1, and then Data.Validation. Select List and into source field
enter
=$E$1:$E$3
OK
The dropdown in cell A1 will be "January", "February", "March". When you
select p.e. "January" from list, in cell A1 is the value 37987 displayed.
Format A1 as date - it will be p.e. 1st January 2004 - but the format of
dropdown list remains unchanged.
Arvi Laanemets
