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.

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!