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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!