Fill Dropdown Title For Free

welcome to Excel campus my name is John and in this video I'm going to explain how to create drop-down lists in cells so these are also called data validation lists and we can see when we click on this cell here we get this little drop-down icon next to the cell and when we click on that we get all these different choices to choose from and when we choose one of those that entry will be input into the cell so in this video I'm not only going to explain how to create the drop-down list but I will also share how to use keyboard shortcuts to make selections from the list how to copy and apply the list to multiple cells how to handle errors and invalid inputs and how to update the dropdowns with new data so let's take a look at how to create these I'm going to go over to this inventory sheet here and we're going to create a few different drop-down lists the first one will be in this column here we just have these values of yes and no so we want to create a drop-down list for those values so we can first just select this cell here we're going to go to the data tab on the ribbon and then over here there's a data validation button this is a split button and we're going to click the top half of the button that'll open the data validation window here and on the Settings tab we have under the allow drop-down we're going to choose list so this will create our drop-down list and really the most important setting here is the source so in this source box we can either reference a range or we can just put values in here we can just type values in here that are comma separated so if we just wanted to have yes and no as two options there we can just type yes comma no hit okay and then we'll see we have the drop-down list or the icon added right here to the cell and when we click that we'll get our options for yes or no and we can choose one of those and then that value will be input into the cell now we might also have a much longer list that we want to choose from for example we have this product column here and we also have a products sheet that has a table here it's a long list of product names and we might want to add these to our drop-down menu so we can do that by referencing a range so go back over to our inventory sheet and right here and cell a2 again we'll just select that cell data tab on the ribbon click data validation button open the data validation window we're going to choose list and now in this source section we can either click right here in this box or we can click this little icon right here and that'll allow us to select a range we're going to go over to the products sheet I'll select cell a2 and then I'm going to use ctrl shift down arrow that keyboard shortcut to select all of the cells here all they use 2 cells in that column so it's all the way down to row 83 we'll just click this button again and then we can see that we have our source range there that's great then we'll click OK and that will add that drop down there and when we click...