The fastest way to delete a drop-down box

To remove a drop-down box in Excel, click the cell containing it, then go to the Data tab and select Data Validation. In the dialog box that opens, click Clear All, then OK. The drop-down disappears but the cell's contents stay. If you want to delete the cell itself and shift the remaining cells up or left, right-click the cell and choose Delete instead.

The method you choose depends on whether you want to keep the data in that cell or remove it entirely. Data Validation clears only the drop-down rule; the cell remains in your spreadsheet. Deleting the cell removes both the drop-down and the cell itself.

Key Takeaways

  • Click the cell with the drop-down, go to Data > Data Validation, click Clear All, then OK to remove the drop-down while keeping the cell.
  • If you want to delete the cell entirely and shift other cells to fill the gap, right-click the cell and choose Delete instead.
  • Clearing a drop-down does not erase the text or numbers already in that cell — only the validation rule that created the list.
  • To remove drop-downs from multiple cells at once, select all of them first, then use Data Validation > Clear All.

Removing a single drop-down box step by step

Click once on the cell that contains the drop-down you want to remove. You will see the cell highlighted with a blue border. If the cell has a small arrow on the right side, that is the drop-down indicator.

Open the Data tab at the top of the ribbon. In the Data Tools section, you will see a button labeled Data Validation (in some older versions of Excel, this may say Validity). Click it. A dialog box will open showing the current validation rule — usually a list of allowed values or a range of numbers.

Click the Clear All button at the bottom left of the dialog box. This removes the validation rule entirely. Then click OK to close the dialog and explore the change. The drop-down arrow disappears from the cell, but any text or number already in the cell remains.

Deleting the cell entirely instead of just the drop-down

If you want to remove the cell and shift the remaining cells to fill the space, right-click on the cell containing the drop-down. A context menu will appear with several options.

Click Delete from the menu. A second dialog box will ask you which direction to shift the remaining cells — left or up. Choose the direction that makes sense for your spreadsheet layout, then click OK. The cell and its drop-down are both removed, and the surrounding cells move to fill the gap.

Removing drop-downs from multiple cells at once

If you have drop-downs in several cells and want to remove them all, select all those cells first. 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 to select a continuous range.

Once all the cells are highlighted, open the Data tab and click Data Validation. Click Clear All, then OK. All the drop-downs in the selected cells are removed at once, but the cells and their contents remain.

What happens to the data when you remove a drop-down

Removing a drop-down box does not change or erase the data in the cell. If a cell contains the text "North" and has a drop-down list of regions, clearing the validation rule removes the drop-down but leaves "North" in the cell. The cell becomes a regular text cell with no restrictions.

This is useful if you want to keep the data but allow users to type in values that are not on the original list. It is also useful if you are cleaning up a spreadsheet and no longer need the validation rule but want to preserve the information.

Why a drop-down might not disappear

If you clear the validation rule but the drop-down arrow still appears, the cell may contain a formula or be formatted in a way that looks like a drop-down. Check the formula bar at the top to see if there is a formula in the cell. If there is, you will need to edit or delete the formula separately from the validation rule.

Another possibility is that the cell is part of a named range or a table with special formatting. In that case, clearing the validation rule will still remove the drop-down, but the cell may retain other formatting. You can remove that formatting by right-clicking the cell, choosing Format Cells, and adjusting the appearance as needed.

Frequently Asked Questions

Does clearing a drop-down delete the list I created?

No. Clearing the validation rule removes the drop-down from that specific cell or range, but the list itself is not deleted from your computer. If you created the list as a named range or in a separate part of the spreadsheet, it remains there. You can reuse it in other cells if you want.

Can I undo removing a drop-down?

Yes. Press Ctrl+Z (or Cmd+Z on Mac) when ready after removing the drop-down to undo the action. If you have already closed the file or performed other actions, the undo may not work. In that case, you will need to recreate the drop-down manually.

What if I only want to delete the drop-down in one cell out of many that have the same list?

Click only that one cell, then use Data Validation > Clear All. This removes the drop-down from just that cell. The drop-downs in other cells remain unchanged. You do not need to select multiple cells unless you want to remove drop-downs from all of them at once.

Will removing a drop-down affect other people's access to the spreadsheet?

If you share the spreadsheet with others, removing a drop-down will affect their view the next time they open or refresh the file. They will no longer see the drop-down arrow in that cell. If they have already entered data using the old drop-down, that data stays in place.