Remove Drop Down List in Excel

Posted July 1, 2021

Need to remove a drop-down list in Excel?

In this blog you will learn how to remove the drop-down list as well as how to remove the menu items list.

How to remove drop down list in Excel

Click onto the cell that has the drop-down list on it. In this example, this is in cell B3.

Excel drop down list

Select the Data tab then Data Validation.

Excel drop down list

A Data Validation dialogue box should have now appeared. The Source box will display information of where the list or the menu items are located within the workbook file.

Excel drop down list

In this example, the source is coming from the Sales Team worksheet, cells A2 to A14.

Extra tip: If you are going to delete the list items too, it is a good idea to make a note of the source location so that you can easily find and delete them. If you are having difficulty finding the list, check out my other blog ‘How to Edit a Drop-Down List’.

To remove the drop-down list, select the Clear All button.

Excel drop down list

Click OK.

The cell should now be back to being just a normal cell.

How to remove the drop down menu items list

You can now remove the menu items if they are no longer useful.

For this example, we would go to the Sales Team worksheet tab.

Excel drop down list

Right-click the worksheet tab and then select Delete.

Excel drop down list

Your list should now be deleted.

Note: If you don’t want to delete the entire worksheet, you can highlight over the list and press your Delete key and this will remove the list.

Excel drop down list

Was this blog helpful? Let us know in the Comments below.

If you enjoyed this post check out the related posts below.

Elevate your Excel game and become a pro with our exclusive Insider Group

Be the first to know about new tutorials, videos, and tips for Microsoft 365 products. Join us now and claim your exclusive bonus, your list of Essential Excel Skills to become proficient in Excel!

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}