Select where you want the drop-down list to appear. Click the Data tab and select Data Validation in the Data Tools group. A Data Validation dialog box will appear.

Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same time.

Click "Data Validation" on the Data tab and click "Data Validation." Choose "List" in the Allow box. Type your list items into the Source box with a comma between each item. Click "OK" to add the ...

To remove the drop-down list, click the "Data" tab on the ribbon and click "Data Validation" to open the dialog box. Click the "Settings" tab and click the "Clear All" button.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

Click the dropdown arrow next to Data Validation on the Data tab. Choose Circle Invalid Data. That’s it! If you decide you want the circles removed, simply click the dropdown arrow next to Data ...

If you see the "This value doesn't match the data validation restrictions defined for this cell" error in Excel, this article will help you.