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
rea

Select the cell where you wish to remove dropdown list.

tyu

Go to Data > Data Validation

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

uio

 

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 dependent drop down list?
How to create multiple dropdown List without repetition using named ranges?
How to create drop down list?

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 *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube