See all How-To Articles

Remove a Drop-Down List (Data Validation) in Excel & Google Sheets

This tutorial will demonstrate how to remove a drop-down list in Excel and Google Sheets.

 

RemoveValidation Intro

 

If you have a drop-down list in Excel that is created using Data Validation, you may wish to remove it to allow the user to enter any information into the cell rather than what is just contained in the drop-down list.

Removing Data Validation

  1. To remove Data Validation, first select the cell that contains the drop-down list.

 

RemoveValidation SelectCell

 

  1. Then, in the Ribbon, select Data > Data Tools > Data Validation.

 

RemoveValidation Ribbon

 

  1. In the Settings tab, click Clear All, and then click OK.

 

RemoveValidation ClearAll

 

The drop-down list is removed from the selected cell.

Remove a Drop-Down List in Google Sheets

  1. Select the cell in Google Sheets that has the drop-down list in it.

 

RemoveValidation GS List

 

  1. In the Menu, select Data validation.

 

RemoveValidation GS Menu

 

  1. Click Remove validation.

 

RemoveValidation GS Remove

 

The drop-down list is removed from the selected cell.