Validate with a Validation List

In Excel, you can restrict the values a user can enter into a cell. By restricting values, you help ensure that all worksheet entries are valid and that calculations based on them are valid as well. During data entry, a validation list forces anyone using your worksheet to select a value from a drop-down list rather than typing and potentially entering the wrong information. Validation lists save time and reduce errors.

There are two methods that you can use to create a data validation list. First, if your list is short and does not change, you can type your list into the Source field of the Data Validation dialog box. For example, if your field collects gender, you can ...

Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.