drop down list in a cell

C

ceemo

I believe there is a way to make a cell have a list of availbale entries
in like a drop down list but im not sure how to do it ?
 
B

bparker

Go to Data-Validation. Select "list" from the 'Allow:' section, the
Excel will let you highlight cells that contain the items you want o
your drop-down list. Or you could just type in the items, separate
with commas. Hit OK and you'll be good to go.
Bra
 
Top