In Excel: select the cells, then Data ▸ Data Validation ▸ Clear All ▸ OK — the arrow and the rule are removed while the values already in the cells stay; to empty only the chosen value, select the cell and press Delete instead.
On this page7
Select the cells that have the drop-down (Ctrl+click to add separate cells), or use Home ▸ Find & Select ▸ Data Validation to select every validated cell on the sheet.
Open Data ▸ Data Validation.
If the selection mixes different rules, Excel first asks whether to erase the current settings — confirm to continue.
On the Settings tab click Clear All, then OK.
Click one of the cells: the arrow is gone and its previous value is still there.
What this does
A drop-down list is a Data Validation rule with Allow: List, so removing it means clearing the rule, not deleting cell contents. Clear All in the Data Validation dialog resets the selected cells to Allow: Any value, which removes the in-cell arrow, the list source and any input message or error alert. Values that were already chosen stay in the cells as ordinary entries. Pressing Delete does the opposite: it empties the cell but keeps the rule, so the arrow is still there. When you do not know which cells carry a rule, Home ▸ Find & Select ▸ Data Validation selects every cell on the sheet that has one. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. For “remove drop down menu from excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected dropdown change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a data step that keeps your analysis trustworthy useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
C2:C200 has a Status drop-down offering Open, Done and Blocked, and 40 rows already say Done. Select C2:C200, choose Data ▸ Data Validation, click Clear All and then OK. The arrows disappear, the 40 cells still say Done, and any text can now be typed into the column. Selecting C2 and pressing Delete instead would have emptied C2 but kept its arrow and its three options. A leftover list keeps rejecting typed entries that are not on it and shows an arrow nobody needs. Clearing the rule turns the column back into ordinary cells without losing the data already entered. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “remove drop down menu from excel” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.
Common mistakes
- Pressing Delete, which clears the value but leaves the rule and the arrow in place.
- Clearing the source cells instead of the rule — the drop-down stays and only shows empty items.
- Selecting a single cell of a filled column, so the rule stays on every other row.
- Expecting Clear All to remove the text already in the cells; existing values are kept.
Frequently asked questions
How do I remove every drop-down on a sheet at once?
Choose Home ▸ Find & Select ▸ Data Validation to select all validated cells, then Data ▸ Data Validation ▸ Clear All ▸ OK. This also removes other validation rules, not only lists.
How do I clear the selected value but keep the drop-down?
Select the cell and press Delete. The rule stays, so the arrow and its options remain available.
Can I remove just one option from the list?
Yes — edit the list instead of removing it: change the Source in Data ▸ Data Validation, or delete the item from the source range.
Other ways people ask this
This is also commonly searched as “remove drop down menu from excel”, “excel select from drop down” and “how to remove drop down from excel cell”. They describe the identical operation, so you are in the right place no matter how you phrased it.
Why do people search for this in so many different ways?
Because the same task has many names. “remove drop down menu from excel”, “excel select from drop down”, “how to remove drop down from excel cell” all point at the one operation explained on this page, which is why they all lead here.