-
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.