drop down list in a cell
 

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 ?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=546817

drop down list in a cell
 

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


--
bparker
------------------------------------------------------------------------
bparker's Profile: http://www.excelforum.com/member.php...o&userid=34940
View this thread: http://www.excelforum.com/showthread...hreadid=546817