3 Ways to Automatically Update Drop Down Lists in Excel - Data Validation

Add to Favorites
Author: | Edits: don

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.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.