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

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on April 20, 2022

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.

AI Formula Generator

Try for Free

See all How-To Articles