That’s it – Now what?
You’ve just learned how to create a drop-down list in Excel.
Also, you can now control the error alert that is shown when invalid data is entered.
AND you can make the spreadsheet show a nice input message to make the data entry process easier for the user.
But there’s more to Excel than eradicating typos with drop-down lists.
Let’s stop and think: Why are typos such a menace?
Because they make your functions less effective.
Especially the functions: IF, SUMIF, and VLOOKUP.
And they happen to be 3 of the most important functions in Excel.
If you’re not proficient with those already, I strongly suggest you enroll in my 3-part free online course and learn IF, SUMIF, and VLOOKUP once and for all.