Removing a drop-down menu is a two-step process: select the cell or range, then clear the data validation rule

To delete a drop-down menu in Excel, click the cell containing it, go to the Data tab, select Validity (or Data Validation, depending on your Excel version), and click Delete All or Clear. The drop-down disappears when ready, but the cell itself remains — you can then type anything into it. This works the same way whether you created the drop-down yourself or inherited it in a shared spreadsheet.

The exact menu name varies slightly by version. In Excel for Windows and Mac, look for "Data Validation" under the Data tab. In some older versions or regional settings, it appears as "Validity". The steps are identical regardless.

Key Takeaways

  • Select the cell or range containing the drop-down menu you want to remove.
  • Open the Data tab, then click Data Validation (or Validity), and choose Delete All or Clear.
  • Removing the validation rule does not delete the cell's contents — only the restriction that forced you to choose from a list.
  • If you want to delete the drop-down from multiple cells at once, select the entire range before opening Data Validation.
  • You can undo the deletion by pressing Ctrl+Z (or Cmd+Z on Mac) when ready after removing it.

Selecting a single cell with a drop-down menu

Click once on the cell that contains the drop-down arrow. You will see the small downward-pointing arrow appear on the right side of the cell when it is selected. The cell reference (like A1 or B5) will show in the Name Box on the left side of the formula bar, confirming you have the right cell.

If the cell contains text or a number, that content stays visible. The drop-down restriction is separate from what is stored in the cell — removing one does not affect the other.

Selecting multiple cells with drop-down menus at once

If you have drop-downs in several cells and want to remove them all in one action, click the first cell, then hold Ctrl (or Cmd on Mac) and click each additional cell. Alternatively, click the first cell, hold Shift, and click the last cell in a continuous range to select everything between them.

You can also select an entire column or row by clicking the column letter or row number. This is useful if a whole column was set up with drop-downs and you want to clear all of them at once. When you open Data Validation next, the Delete All button will remove the rule from every selected cell.

Opening the Data Validation menu

With your cell or range selected, click the Data tab at the top of the ribbon. Look for the button labeled "Data Validation" (in Excel for Windows and most Mac versions) or "Validity" (in some regional or older versions). Click it to open a dialog box.

The dialog shows what rule is currently applied to the selected cell. You might see "List" if it is a straightforward drop-down, or "Whole Number", "Decimal", "Date", or "Custom" if the validation is checking for a specific type of input. This information is just for reference — you do not need to change anything here to delete it.

Clearing the validation rule

Inside the Data Validation dialog, look for a button labeled "Delete All" or "Clear". Click it. The dialog will close, and the drop-down menu will be gone from your selected cell or cells.

If you selected multiple cells and only some of them had drop-downs, the Delete All button removes the validation from all selected cells anyway — it does not matter if a cell had no rule to begin with. This is safe and saves you from having to select each drop-down individually.

What happens to the cell after you delete the drop-down

The cell becomes a normal text or number cell. If it contained a value before (like "Red" or "Q3"), that value stays. You can now type anything into the cell without being restricted to a list. If you try to paste data that would have violated the old rule, Excel will accept it without complaint.

The cell formatting — font, color, borders — remains unchanged. Only the validation rule is removed. If you want to delete the cell's contents as well, select it and press Delete, or right-click and choose Clear Contents.

Undoing a deletion if you change your mind

If you delete a drop-down by mistake, press Ctrl+Z (Windows) or Cmd+Z (Mac) when ready to undo. This restores the validation rule exactly as it was, including the list of options and any error messages that were set up.

Undo works only if you have not made other changes since the deletion. If you have already saved the file or made several edits, undo may not be available. In that case, you will need to recreate the drop-down manually or restore from a backup.

Frequently Asked Questions

Does deleting a drop-down menu delete the data in the cell?

No. The drop-down menu is a rule that restricts what you can type into a cell. Removing the rule does not touch the cell's contents. If the cell contains "January" or "5000", that data stays. You can then edit or replace it like any other cell.

Can I delete a drop-down from just one cell in a range, or do I have to delete them all?

You can delete from one cell at a time. Select only that cell, open Data Validation, and click Delete All. The other cells in the range keep their drop-downs. If you want to remove multiple but not all, select only the ones you want to change.

What if I delete a drop-down but want to keep the list of options for reference?

The list is stored inside the validation rule, so deleting the rule removes it. Before you delete, write down the options or copy them to another cell or sheet. Once the rule is gone, you cannot recover the list from Excel — you would have to recreate it manually.

Will deleting a drop-down affect other people's copies of the spreadsheet?

Only if you save the file and they open the updated version. If you delete a drop-down and save, anyone who opens that file afterward will see the cell without the drop-down. If they already have an older copy open, their version stays unchanged until they close and reopen it.

Can I delete all drop-downs in a spreadsheet at once without selecting each one?

Yes. Press Ctrl+A (or Cmd+A on Mac) to select all cells in the sheet, open Data Validation, and click Delete All. This removes every validation rule from the entire sheet in one action. Use this only if you are sure you want to remove all drop-downs — there is no way to target specific ones this way.