ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Adding to drop down lists (https://www.excelbanter.com/excel-discussion-misc-queries/194017-adding-drop-down-lists.html)

Petren

Adding to drop down lists
 
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

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



All times are GMT +1. The time now is 08:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com