-
Select the cell with the drop-down list. To delete multiple cells with drop-down lists, hold down Ctrl to select them.
-
On the Data tab, chooseÂ
 Data Validation. -
On the Settings tab, choose Clear All and then select OK.
-
Select the cell with the drop-down list. To delete multiple cells with drop-down lists, hold down Ctrl to select them.
-
On the Data tab, chooseÂ
 Data Validation. -
On the Settings tab, choose Clear All and then select OK.
-
Select the cell with the drop-down list. To delete multiple cells with drop-down lists, hold down Ctrl to select them.
-
Select Data and chooseÂ
 ​​​​​​​Data Validation. -
On the Settings tab, choose Clear All and then select Apply.