Linked dropdowns in MS Excel

Published:
Updated:
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.

Patrick
Linked-dropdowns-02.doc
7
3,138 Views

Comments (1)

Commented:
Looks useful for dashboarding.  Any examples of how it can be used to drive filtering of data in an xls, pivot or chart(s).  Is slicers and linked dropdowns nearly identical?

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.

Get access with a 7-day free trial.
You Belong in the World's Smartest IT Community