View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bparker
 
Posts: n/a
Default 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