Remove a drop-down list in Excel 2016 for Mac

If you no longer want a drop-down list in your worksheet, you can remove it.

  1. Select the cells that have the drop-down list.

  2. On the Data tab, click Data Validation.

  3. On the Settings tab, click Clear All.

Click Clear All to remove a drop-down list

If, instead of deleting it, you decide you want to change the options in your drop-down list, see Add or remove items from a drop-down list.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.