Excel Tips - Best Way to Create Dropdowns that Dynamically Update

This video will show you an easy way to create dropdown lists in Excel that can update dynamically when new fields are added.

[peterwaugh]

I was using Excel back in the late 80's & early 90's. I really wish Youtube was around then. I used to read through the manual, yes printed book, from back to front trying to work out how to get more out of it. I still use Excel to this day but for far less complicated tasks. Still find your content interesting.

[Angel_Ripoff]

Love the simplicity and how clearly you describe & demonstrate the process, thanks so much!

[vividtang]

Clearly describe easy to understand. Thanks.

[acreguy]

I never knew you could do this. I've had issues with manually adding new entries to drop down lists using Data Validation. I'm good to go now. That's a big "Thumbs up" and "Subscribed." Thank you!!

[bingoteeth]

I was expecting Deferred to be 4th in the dropdown. I take it that the sort needs to be done again?

[neomadrasi]

When you add a new value to the table, will you need to alphabetically sorry it again? Or, will excel do the sorting intuitively?
I'm Libre Office calc, you get a check box in the data validation tab to automatically display the dropdown value alphabetically

[shailendrachaudhary]

could you also include the data file for practice it would be huge help

[seports]

Is there a way of increasing the font size of the dropdowns?

[arindambhattacharya]

Well I was expecting much more..this is quite simple

[pattamaljayaram]

How to activate this in all cells of column B??

[davidgruty]

what if you delete an item of the list? We get a blank. Do we have to resize the Table Format?

[bsa]

With Microsoft 365 this tip is outdated, MS 365 allows searchable dropdown lists, to include more entries simply extend the range of the validation list to encompass blank cells, the blanks won't be shown in the DD list, but when filled in they will be included.

[gausselim]

Your drop-down list didn't auto alphabetize.