Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Base a Data Validation dropdown on the Region values. Now, let’s use UNIQUE () to create a unique list of region values and then base a data validation dropdown on that list.

To create a drop-down list in Excel, you will use the Data Validation feature. This feature enables you to set specific criteria for the data that can be entered into a cell.

A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.

Learn how to use data validation in Google Sheets to enter information faster and with fewer errors.