Linked dropdowns in MS Excel

Published on
7,607 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.

1 Comment

Expert Comment

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?

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Join & Write a Comment

This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Next Article:

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month