P Petren Jul 8, 2008 #1 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?
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?
D Debra Dalgleish Jul 8, 2008 #2 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
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
