How to remove drop down box in Excel cell?

There are many ways to remove drop down box in excel cell. However, in this article, we will show you the easiest and the fastest way to remove drop down box in Excel cell. We have provided the solution in three different ways, the first one as a manual solution, the second as an add-in or the last one as VBA solution.

How to remove drop down menu in Excel cell?

Drop down boxes are used to quickly sort or choose data from a list. Drop down boxes are available on excel worksheets which contain text, numbers, date or any other data. This data can be arranged in an organized manner and easily made visible for users to choose. If you want to remove the drop down menu in Excel cell, it’s quite easy to do that.

How to remove drop down menus in Excel?

If you want to remove the drop down menu in Excel, select the cell where the menu appears and press Ctrl+Alt+Delete. A small menu will appear at the bottom left corner. Choose Delete Cell to get rid of the menu.

How to remove drop down box Excel ?

To remove the drop down box from Excel cell, press F2 and press right click on the cell. Now, click on Format Cells option. In the drop down menu, click on AutoFilter. A list will appear. Now, click on Remove from list. The drop down box will be removed.

How to remove drop down arrow in Excel cell?

If you don’t want this and want to remove the drop down arrow from the Excel cell then disable the arrow using the Ribbon. You can disable the drop down arrow from a list box by right-clicking on the cell and choosing the Format Cell option and click on the arrow and click on the arrow and click on the arrow. A pop-up will appear, click on the arrow from the pop-up menu to disable the arrow.