dropdown box in a cell
 

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!

dropdown box in a cell
 

Try this:

Select the cell where you want the drop down
Goto the menu DataValidation
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 su In-cell dropdown is checked

OK out

Biff

"jawdoc" wrote in message
ups.com...
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!