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


Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)

Tutorial Details
Downloadable Files: Excel File
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)