Remove a drop-down list

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

  1. Click Data >Data Validation.

  2. 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.

Applies To: Excel 2013

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language