I’m still on the Sort & Filter worksheet within the Excel102exercise file.
Now I want to create a dropdown list, when users are entering the make value within these records.
I want to give them a specific list of makes that they can choose: Ford, Chevy, Pontiac, Oldsmobile..
That way we’re not getting extra stuff inside there that doesn’t belong and we’re getting properly spelled. As long as we spell it correctly then anybody that uses the dropdown will get the proper results as well.
First step to applying data validation is we have to select the cells that we’re going to apply the validation to.
I’m going to click up inside of cell B4 and I’m going to go down I’m just going to hold my Shift key on my keyboard and I’m going to press the B30 cell.
Now that’s the range of cells that I want to play the data validation to we could grab the entire column if you imagine this list getting hundreds or thousands of records large that we want to accommodate for that.
That’s the cells I’m in apply it to once that’s highlighted I’m going to go to Data tab, you’ve got data tools, We’ve got Data validation.
I’ll give that a quick all right inside Data validation window.
We’ve got three tabs Settings, Input message, Error alert. We’re going to focus on the settings tab.
It clearly says that the validation criteria will allow any value. We know that you can jump into cells be four to B30 and you could type, whatever you want in there, Excel doesn’t care, it could be numbers that could be misspelled items, at this point Excel allows that. But we want to control it.
Instead of any value that may click in the dropdown we get a list of validation criteria settings to choose from.
There is an option in there for a list. I’ll get that a click once a select List there and then get the source option that opens up for me.
This is where you’re going to create your list.
I’m going to type in essentially the makes that I want the users to pick from: Ford, Chevy, Pontiac, Oldsmobile.
We don’t want to misspell it here because this is what everybody’s going to be using.
Then hit OK so now remember I had before to B30 selected.
If I go into any of those cells I’ve now got a little drop down arrow I click on that dropdown and it gives me the list of makes that I’ve defined.
A little drop down to assist our users in filling out the records.