dropdown box in a cell

J

jawdoc

I want to have one of the cells in a worksheet function as a drop down
box that has 4 predefined entries.
I have done this within a word document but I can't seem to make it
work within excel.
Any help would be greatly appreciated!
 
T

T. Valko

Try this:

Select the cell where you want the drop down
Goto the menu Data>Validation
Select List
Source:

If you only have 4 selections available type those in separated by a comma.
Example: Joe,Tracy,Bill,Lisa
Or, create a list of those selections on the worksheet somewhere and then
use that range of cells as the source. Example:

A1 = Joe
A2 = Tracy
A3 = Bill
A4 = Lisa

In that case the source would be: A1:A4

Make sure: In-cell dropdown is checked

OK out

Biff
 
Top