Remove a drop down list

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

Windows macOS Web



1. Select the cell with the drop-down list.

   If you have multiple cells with drop-down lists that you want to delete, you can use Ctrl+Left click to select them.

2. Click Data >Data Validation.

3. On the Settings tab, click Clear All.

4. Click OK

If you need to remove all Data Validation from a worksheet, including drop-down lists, but you don't know where they are, then you can use the Go To Special dialog. Press Ctrl+G > Special, then Data Validation > All or Same, and repeat the steps above.

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.

1. Select the cell with the drop-down list.

   If you have multiple cells with drop-down lists that you want to delete, you can use Ctrl+Left click to select them.

2. Click Data >Data Validation.

3. On the Settings tab, click Clear All.

4. Click OK

If you need to remove all Data Validation from a worksheet, including drop-down lists, but you don't know where they are, then you can use the Go To Special dialog. Press Ctrl+G > Special, then Data Validation > All or Same, and repeat the steps above.

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.

1. Select the cells with the drop-down list.

2. Click Data >Data Validation.

3. On the Settings tab, click Clear All.

4. Click OK.

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

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Create a drop-down list

Apply data validation to cells