How to Delete Drop Down List in Microsoft Excel

In this article, you will learn how to delete drop down list.

The dropdown list is used to restrict the user to input data and gives the option to select from the list. We need to delete or remove the Dropdown list as the user will able to input any data instead of choosing from a list.

To delete or remove already existed dropdown list. Just follow the simple steps as shown below.

Using Data validation option we can remove the dropdown list

Let’s see an example here

We have a dropdown list here

Select the cell where you wish to remove dropdown list.


Go to Data > Data Validation

    1. Select Clear All option in the Data Validation dialog box and Click OK. 



Now it's just the text written in that cell. You can edit that cell as dropdown list is removed.

You will see that the dropdown list is removed from the cell.

Below you can find more example:-
How to edit a drop-down list in Excel?
How to apply Conditional Formatting in drop down list?
How to create a dependent drop-down list?
How to create multiple dropdown List without repetition using named ranges?
How to create drop-down list?

Popular Articles:

50 Excel Shortcut to Increase Your Productivity

How to use the VLOOKUP Function in Excel

How to use the COUNTIF function in Excel 2016

How to use the SUMIF Function in Excel



Hope you learned how to remove a dropdown list in Excel. Please state your query regarding this article. We are here to help you.


Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.