[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More


Linked dropdowns in MS Excel

Published on
7,635 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

Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Join & Write a Comment

This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month