How to clear drop down list in Excel cell?

Sometimes, you may want to clear the drop down list in excel cell. To do so, select the cell where the drop down list is present, right click on it and click on Data menu, then click on Remove Data. This will clear the list.

How to clear drop down list in excel cell?

To delete the drop down list in excel cell, you need to press Ctrl+Z and then click on the desired cell. This will remove the drop down list from the cell. You can also press Ctrl+A, Ctrl+C and then paste your previous data in the cell to replace the existing data.

How to clear drop down list in excel?

There are two ways to clear drop down list in excel. You can use drop down list tools in excel menu to clear the drop down list. You can also press “Delete” key and then click the box that says “Delete” or press CTRL+A to select all the contents of the cell to clear it from the drop down list.

How to remove drop down list in Excel?

To remove the drop down list, you can use the following options: right click on the cell, choose Format Cells, click Data drop down menu in the left pane, choose AutoFilter and clear the check box from the drop down list. You can also press Ctrl+A and delete the unwanted cells that contain the drop down list. Or you can press Ctrl+A and click the cell with drop down list and press Delete key.

How to uncheck drop down list in Excel?

To uncheck all the drop down list items in Excel, click the cell containing the list to select it. Then press Ctrl+U. A pop-up will appear. Choose to remove the list from the cell and press OK.