To remove a drop-down list in Excel, you delete the data validation from the cell(s) that contain it.

Remove drop-down from selected cells

This keeps the existing values in the cells but removes the little arrow and the list.

  1. Select the cell or range that has the drop-down list.
  2. Go to the Data tab.
  3. Click Data Validation.
  4. In the Settings tab, click Clear All.
  5. Click OK.

After this, the cell behaves like a normal cell, but whatever value was already selected stays there.

Remove drop-down and clear everything

Use this if you want to wipe the list, the text, and any formatting in one shot.

  1. Select the cell(s) with the drop-down list.
  2. Go to the Home tab.
  3. In the Editing group, click Clear.
  4. Choose Clear All.

This gives you a completely blank cell with no drop-down, no value, and no formats.

Remove all similar drop-downs on a sheet

If many cells share the same data validation, you can remove them all together.

  1. Select one cell that has the drop-down you want to remove.
  2. Press F5 to open Go To , then click Special.
  3. Choose Data Validation → All (or Same depending on your Excel version).
  4. Click OK to select all those cells.
  5. Go to Data → Data Validation → Settings.
  6. Click Clear All → OK.

All those drop-down lists will be removed, but the current values in the cells remain.

Quick keyboard trick

You can jump straight to the Data Validation dialog with a shortcut.

  • Press Alt + A + V + V (one after another, not all at once).
  • Then click Clear All → OK.

This is handy when you need to do this repeatedly across a workbook.

If the drop-down still “won’t go away”

Sometimes what looks like a drop-down is actually coming from another feature, like a form control or ActiveX combo box, not data validation.

  • If you can’t remove it using Data Validation, try:
    • Go to Developer tab (enable it in Options if needed).
    • Use Design Mode , click the object, and press Delete.

This only applies when the drop-down is an actual object sitting on top of the sheet, not inside a cell as data validation.

“How to remove drop down list in Excel” is really “how to remove data validation” in most normal tables—once you know that, fixing it becomes a simple few clicks instead of a mystery.

Is your drop-down inside a normal cell (with a small arrow when you click it), or is it a bigger combo box sitting on top of the sheet?