Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
3 Ways to Automatically Update Drop Down Lists in Excel - Data Validation
Ensure that your Data Validation Drop Down Lists or Menus are automatically updated with any new entries or deletions - these automatic methods make maintaining your spreadsheet much easier.
The 3 methods that I show you here will cover the 3 most common ways to have your data validation lists automatically update:
- Robust and versatile method (the one you should use).
- Commonly taught method, though with some downfalls (also mentioned here).
- Formula that allows bypassing some of the steps mentioned in the previous methods.
These 3 methods should give you a complete understanding of how to automatically update your lists, regardless of the setup of your spreadsheets.