TL;DR: A drop-down list in Excel is data validation, not a shape or a control. To remove it: select the cells, then Data → Data Validation → Clear All → OK. That removes the list and leaves the typed values alone. If you also want the values gone, delete the cell contents separately — the two operations are independent, which is the source of most confusion.
What a drop-down actually is
The arrows appear because a cell has a validation rule whose “Allow” setting is a list. That is the entire mechanism, and it is worth stating plainly because Excel has at least four different things that look like a drop-down and are removed in completely different ways.
Only the first of these is removed with Data Validation:
- Data validation list — the common case, created from the Data tab
- Form control combo box — a drawn shape from the Developer tab
- Table header filter buttons — part of an Excel Table, removed by converting to a range
- Slicer or pivot filter — attached to a PivotTable or Table
If Data Validation → Clear All does nothing, you are almost certainly looking at one of the other three.
Removing the list and keeping the values
This is what most people actually want: the cells should still contain “Approved” or “Pending”, but the arrows should go.
Select the cells — a single cell, a block, or an entire column by clicking the column header. Then go to Data → Data Validation → Clear All → OK.
Two details that catch people out. Clearing validation removes the rule, not the content, so the existing entries survive intact. And if the cells had a rule applied to a range but you only select part of it, the rule stays on the unselected cells — which is why a drop-down sometimes “comes back” after you clear it from one cell.
To be sure, select the whole range the rule covers. If you do not know the range, select the entire column and clear; validation is per-cell, so this cannot damage anything that has no rule.
Removing the values too
Deleting the contents and removing the validation are separate steps, and the order matters slightly.
Clear validation first, then select the cells and press Delete. If you press Delete first, the drop-down remains on empty cells and will still appear when you click them, which reads as the removal having failed.
If you want to restore the previous values as well — common when experimenting — undo immediately after the delete, or work from a copy of the sheet. Data validation changes are not always reversible through undo once the dialog has been confirmed and other edits have happened since.
Removing a list from a whole column
Click the column header to select all 1,048,576 cells, open Data Validation and clear. This works because validation rules are stored per cell, and clearing across a selection removes them everywhere in that selection.
One caveat: if the sheet is protected, the Data Validation button is greyed out. Unprotect via Review → Unprotect Sheet, make the change, then protect again. If you do not have the password, the validation cannot be removed — this is a genuine permission boundary rather than a bug.
A second caveat: if the list is fed by a named range that is now invalid — the source sheet was deleted, for instance — Excel may refuse to open the dialog and show an error instead. In that case, use Home → Find & Select → Go To Special → Data Validation → All, which selects every cell carrying a rule so you can clear in one pass.
When the arrows survive the removal
Four causes, in the order worth checking.
It is a Form Control. Clicking Developer → Design Mode and then clicking the arrow reveals a selected shape. Delete it like any object. These are floating controls over the sheet, not cell-level rules, which is why Data Validation has no effect.
It is a Table filter. Convert the Table to a normal range with Table Design → Convert to Range. The filter buttons disappear with the Table.
It is a slicer. Right-click the slicer and choose Remove. Slicers float above the grid and are tied to a PivotTable or Table connection.
The workbook is shared. Shared workbooks have restricted feature support, and validation changes may not apply until sharing is turned off. Review → Share Workbook → uncheck “Allow changes by more than one user”.
Each of these looks identical on screen and behaves completely differently, which is why the generic instruction “clear data validation” fails for a meaningful share of people asking the question.
Replacing a list rather than removing it
Often the goal is not removal but a change of options, and the same dialog handles it.
Select the cells, open Data Validation, and edit the Source box. If the list is inline text, edit the comma-separated values. If it points at a range, change the reference. Applying OK updates the arrow menus immediately, and existing entries that are no longer in the list remain in the cells — Excel does not retroactively clear them, it only flags them with the error alert if you have one enabled.
That behaviour is worth knowing: a cell can hold a value that is not in its own list, and the file will look fine until someone opens the validation dialog.
Building game sheets that do not need removing later
If you are building something interactive — a scoreboard, a quiz, a grid game — validation lists are the natural way to constrain input, and they are easy to undo precisely because they are ordinary cell rules.
Keep list sources on a separate “Lists” sheet and define named ranges. When you later want to remove a drop-down, you clear one selection rather than hunting for the range, and when you copy the sheet into another workbook the source travels with it.
If you want to see how constrained-input mechanics get used in practice, Excel games built around cell rules show the pattern in context, and they are easier to take apart than a project file because every rule is visible in the same dialog.
The short version
A drop-down is data validation. Select the cells, Data → Data Validation → Clear All, and the arrows go while the values stay. Delete the content separately. If the arrows survive, it is a form control, a table filter, or a slicer — not validation.


