Excel - Getting started with Data Validation List

Creating a Data Validation List is a great way to ensure you have "good" data. For example, I may type Human Resources as a department, but later in my data, I see HR. I know that HR and Human Resources are the same, but Excel doesn't.

Data Validation List

YouTube Video

Excel - Getting started with Data Validation List

Steps to turn on Data Validation List

1. Select the range you want to use with a data validation list
2. Click the Data tab
3. Click Data Validation in the Data Tools group
4. Change Allow from Any value to List
5. Type in your Source or select a source.
6. Click OK

Excel - Create a Data Validation List