View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CBrausa
 
Posts: n/a
Default how do I enter more data to an already made pull down menu


put cursor in the cell with the menu
go to Data tab,
Validation
settings
it will tell you where your information is located.
go to that area, insert your new info and then make sure you change the
cell range in the Data box (Validation window)


--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=513348