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
Select the cell where you wish to remove dropdown list.
Go to Data > Data Validation
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.
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.