July 1

0 comments

Remove Drop Down List in Excel

By Sharyn Baines

July 1, 2021

Delete, Dropdown, Named Range

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.

Sharyn Baines

About the author

Sharyn is an expert trainer. She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand. She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.

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

JOIN FREE! 'Excel at Work Insiders Group' for free tutorials, mini-courses, videos and blogs!

>