From the course: Excel 2016: Data Validation in Depth
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Multitiered lists
- [Instructor] On this worksheet called MultiList, we're setting up some data-entry for columns A through D. We'll have some data entries, free form. For the state entries here, we're only active in certain states. We want them to be available from a pick list, and we see abbreviations over in row one, father to the right, column G. Here are the state entries that we want to see. So, we're going to set up a pick list for those. Now, you wanna put it city entries as well. We don't want to type them. And, as I scroll rightward here, you can see in the different columns some of the larger cities in these states. We're only active in these states. Now, what we'd like to be able to do here is have one pick list depend upon another one. So, for example, in column B, if we have our picklist set up, and we choose California from it, then we wanna be able to click in column C, and use a picklist that only reveals these cities. So, we can pick from that list so that the city name pops in. And…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.