Remove a drop-down list by clearing data validation

To delete a drop-down list in Excel, select the cell or cells containing it, then go to the Data tab and click Data Validation. In the dialog box that opens, click Clear All, then OK. The drop-down disappears and the cell becomes a normal text field.

This works whether you created the drop-down yourself or inherited it in a spreadsheet someone else built. The cell keeps any value that was selected from the list — you are only removing the restriction that forces you to pick from that specific list.

If you want to delete the drop-down but also clear the cell's contents, select the cell and press Delete instead. This removes both the validation rule and whatever text or number is in the cell.

Key Takeaways

  • Select the cell with the drop-down, go to Data > Data Validation, click Clear All, then OK to remove the list while keeping the current value.
  • To remove the drop-down and erase the cell contents at the same time, straightforward press Delete.
  • You can remove drop-downs from multiple cells at once by selecting the entire range before opening Data Validation.
  • Removing a drop-down does not affect other cells in the spreadsheet — only the ones you selected.

Remove drop-downs from a range of cells at once

If multiple cells have drop-down lists and you want to remove them all together, select the entire range first. Click the first cell, then hold Shift and click the last cell in the range you want to change. Or click and drag across all the cells you need.

Once the range is selected, open the Data tab and click Data Validation. Click Clear All and then OK. Every drop-down in that range disappears at once, and all the cells become regular input fields.

This is faster than deleting them one at a time, especially in a large spreadsheet where drop-downs appear in dozens of rows.

Find which cells have drop-downs before deleting them

In a spreadsheet you did not create, you might not know which cells contain drop-down lists. Excel does not highlight them automatically, so you have to look for the small arrow that appears when you click a cell with validation.

Click through cells in the column or area where you think drop-downs exist. When you click a cell that has one, a small downward-pointing arrow appears on the right side of the cell. That arrow is your signal that a drop-down list is active there.

Once you find them, you can select multiple cells with drop-downs by holding Ctrl and clicking each one individually, then clear them all at once using Data Validation > Clear All.

Understand what data validation does

A drop-down list in Excel is created using a feature called data validation. This feature restricts what can be typed or entered into a cell — instead of allowing any text or number, it forces the user to pick from a predefined list.

When you clear data validation, you remove that restriction. The cell no longer forces a choice from a list. Someone can now type anything into that cell, just like a normal spreadsheet cell.

Data validation can also enforce other rules, like requiring a number between 1 and 100, or a date after a certain day. Clearing all validation removes every rule attached to that cell, not just the drop-down list itself.

Recover a drop-down list you deleted by mistake

If you removed a drop-down and when ready realize you made a mistake, press Ctrl+Z (or Cmd+Z on Mac) to undo. This restores the validation rule and the drop-down list returns.

If you closed the file or performed other actions after deleting the drop-down, undo may not work. In that case, you will need to recreate the drop-down by going back to Data Validation and setting up the list again. You will need to remember or find the original list of values that were in the drop-down.

Delete drop-downs in older versions of Excel

The steps above work in Excel 2016, 2019, 2021, and Microsoft 365. If you use an older version like Excel 2010 or 2013, the process is the same: select the cell, go to Data > Validity (or Data > Validation depending on your version), and click Clear All.

In Excel Online (the browser version), click the cell, go to Data > Data Validation, and click Clear Validation. The menu looks slightly different but the result is identical.

Frequently Asked Questions

Does removing a drop-down list delete the value in the cell?

No. Clearing data validation removes the list restriction but leaves whatever value was selected in the cell. If the cell contains "Option A" and you clear the drop-down, "Option A" stays there — the cell just stops forcing you to pick from a list. To erase both the drop-down and the value, press Delete instead of using Clear All.

Can I remove a drop-down from just one cell in a column?

Yes. Click the single cell that has the drop-down, open Data Validation, click Clear All, and click OK. Other cells in the same column keep their drop-downs. You only remove validation from the cells you select.

What if I want to change the drop-down list instead of deleting it?

Select the cell, go to Data > Data Validation, and edit the list in the dialog box. You can add new options, remove old ones, or point to a different range of cells that contains the list. Click OK to save the changes without clearing the validation.

Will removing a drop-down affect formulas that reference that cell?

No. Formulas in other cells that reference this one will continue to work exactly as before. Removing data validation only changes what can be entered into the cell — it does not change how other parts of the spreadsheet use that cell's value.