Thread: Edit Drop Down List
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default Edit Drop Down List
Hi Lynn,

Highlight your input cell goto DataValidation and change the source
reference.
i.e. if your source range is $J$7:$J$10 changing it to $J$7:$J$12
will allow you to add two new values in J11 and J12.

HTH
Martin


Reply With QuoteReply With Quote