Linked dropdowns in MS Excel

Published on
7,770 Points
7 Endorsements
Last Modified:
Linked Data Validated dropdowns in Excel

Creating a Data Validated dropdown is a straightforward task, however every now and again the question comes up of "How do I make the contents of a second dropdown change depending upon the choice made in the first drop down"

As there are embedded screenshots in my 'How to' notes I am attaching an MS Word file which has full instruction on how to do it.

Hope it helps someone.

Ask questions about what you read
If you have a question about something within an article, you can receive help directly from the article author. Experts Exchange article authors are available to answer questions and further the discussion.
Get 7 days free