How To Remove Drop Down List In Excel?

Select the cell or range with the drop-down list

Go to the Data tab

Click Data Validation

In the Data Validation dialog, click Clear All

Click OK

If needed, copy the cell and use Paste Special > Validation to remove validation from other cells

To remove all drop-downs in a sheet, select the entire sheet and clear data validation

Suggested for You

Trending Today