Browse All Articles > Linked dropdowns in MS Excel
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
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
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.
Comments (1)
Commented: