Dropdowns are useful features that simplify data entry and enforce data validations in spreadsheet software. Creating a dropdown list is easy. And you might have done that already in Excel. But ...

Now we’re ready to create the data validation dropdown that will display the unique list in column H. To begin, select J2 and then do the following: Click the Data tab.

Select a cell — I selected B2. Click the Data tab. In the Data Tools group, click Data Validation, and then click Data Validation from the dropdown. From the Allow dropdown, choose 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.