Add Signed Dropdown with airSlate SignNow

Add drop down fields, Make content changes and eSign

welcome to Excel campus my name is John and in this video I'm going to explain how to create dynamic data validation lists that extend when we add new items to our source range so what I mean by that is in the cell here we have this data validation list with some items here these are from our products column over here in this sheet and as we add new items to the bottom of this list we want those to be automatically included in our data validation list here and for this we're going to use Excel tables and named ranges so the first thing we're going to do is go over to our source range which is this products sheet and we're going to insert a table so we'll go to the insert tab on the ribbon choose table keyboard shortcut is ctrl T that'll bring up this prompt here just make sure your my table has headers checkbox is checked and click OK that will insert our table we can see our table name right here as well and we can also change that I also have a whole nother video on getting started with Excel tables so if you're not using Excel tables yet I highly recommend checking that out so the next step will be to insert our named range for this products column so to do that we're going to go to the formulas tab on the ribbon here we can either click the define name button right there it's a little shortcut or we can jump into the name manager this is the name manager here that lists all of our named ranges and then we can click the new button right here and that will allow us to define this named range so it's already named at products for us you can change that if you want I like to prefix mine with RNG so our ng products that just makes them easier to find in formulas and then for the refers to down here we just want the body of that range or of that column so we're going to go ahead and click this button right here will select a2 right here and then use ctrl shift down arrow on the keyboard to select just the products column we can see that reference has been created right here table 3 and then the product or the column name in brackets there so that looks good well click this box and then we'll click OK to create our named range now we can also see it again here in the name we have our named range right here and where it refers to which is Table three and the products column so everything looks good there we'll go ahead and close this window and now we just need to go over to our data validation list so we'll select this cell here contains our data validation list go to the...