Write Client Dropdown with airSlate SignNow

Create deponent dropdown

hi everyone kevin here today i want to show you how you can create multiple dependent drop-down lists in microsoft excel so what does that even mean and why would you ever want to use something like this well let's say you have people entering data into microsoft excel to make sure people don't make data entry errors maybe you want to include a drop-down list that'll make it as easy as possible and the option that someone selects in that first drop-down list will influence what options are available in a second or a subsequent drop-down list if you want to follow along with this video i've included a sample file in the description down below otherwise let's check this out here i am in microsoft excel and management at the kevin cookie company they do a good job of keeping employees busy but they've requested that i pull together an order log an order log is something that we fill out every time we get an order here we enter in the sales person who drove the order and then we also enter the associated customer now i want to make sure that when we have our employees fill this out that they enter it as accurately as possible so i could have people just manually type it in and here we'll enter in the sales person kevin but undoubtedly what happens all the time is people make mistakes and here we see that kevin was entered incorrectly so instead we can use just a simple drop-down list to make sure that people enter the sales person name in correctly to insert a basic drop-down list let's go up to the top tabs and click on the one called data over here under the data tools category there's an option called data validation click on that this opens up a data validation prompt and right here we can set the validation criteria and currently this cell is set to allow any value at all and that's why i was able to enter kevin with a c so instead i'll click on this drop down list and let's select list right here i want this to be a drop down list i'll select that and next i have to indicate what is the source of this drop-down list now if we look over here here i have a list of all of our different sales people at the kevin cookie company so for the source i'll simply highlight these three cells and then i'll click on ok back on the sheet i can now see that i've successfully added a drop down list here i have a drop down list icon and when i click on this i can see all of the names of our different sales associates now if i try to enter a name of someone who's not on the sales team let's say for example adele here we'll get this nasty error message telling us...