View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Adding to drop down lists

You can insert the new items in the middle of the list, and they range
will automatically expand to include all the items.

Or create a dynamic range, as described here, and use that range as the
drop down list's source:

http://www.contextures.com/xlNames01.html#Dynamic

Petren wrote:
Once i have named a list that will become my drop down list, how would i add
extra selections after i have made the list?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com