How to remove drop down list in Excel cell?

There are many situations when you need to disable the selection of a drop down list cell. disabling drop down list is important because when the cell is editable the drop down list is automatically displayed, and when the cell is read-only, the drop down list is hidden. There are a few things you can do to remove the drop down list from a cell.

How to remove drop down list in Excel ?

To remove the list from the cell you can use a right click on the cell. There will be a menu to edit the cell. You can click on the menu and choose the option “Remove”. This will remove the drop down list from the cell.

How to remove drop down list in Excel cells?

To remove the drop down list in Excel cells, select the drop down list cell. Now press F2 or right click and click on Format Cells. Now select the Number option from the menu and click on the drop down menu. Now click on the Remove Decimal Places and click OK. This helps in removing the drop down list automatically.

How to remove drop down list in excel?

To remove drop down list from Excel cell, you need to press right click on the cell. When the pop up menu appears, click on the Format Cells option. Now click on the Conditional Formatting option, which is located in the drop down menu. A drop down list will appear on the right side of the cell. You can click on the arrow to see the available options. You need to click on the No Conditional Formatting option from the list.

How to remove drop down list in Excel

If you want to remove the drop down list from the cell, press Ctrl+T on your keyboard to open the Table Tools menu. To select the cell, click on it. Now, click on the Edit drop-down menu and click on Remove to remove the drop down list.