How to remove drop-down list in Google Sheets

You can watch a video tutorial here.

To validate the data that is entered in Google Sheets, it is possible to define the list of values that are allowed by creating a drop-down list.  This is especially useful when creating data entry forms and you need to restrict the values that are entered. When modifying the sheet you may want to remove the drop-down to allow any value to be entered in the cell. 

Step 1 – Select the cell

– Select the cell from which the drop-down list is to be removed

Step 2 – Open the Data Validation window

– Go to Data > Data Validation

Step 3 – Remove the list

– Click Remove Validation

Step 4 – Check the result

– The drop-down list is removed from the cell