Remove a Dropdown List in Excel Without Losing Data

To remove a dropdown list in Excel for Microsoft 365 on Windows, select the cell or cells, go to Data > Data Validation, choose Clear All in the Settings tab, and select OK. This removes the validation rule that creates the list; it does not erase the existing cell contents.

What Removing a Dropdown Actually Does

Most in-cell dropdowns in Excel are created with Data Validation, using the List option to restrict what can be entered. Removing the dropdown means removing that validation rule. The cell then accepts entries without that particular list restriction, although other worksheet rules or protection may still affect editing.

Clearing the rule is different from deleting the value currently in the cell. For example, if a cell contains “In progress” selected from a list, Clear All removes the list rule but leaves “In progress” in place. If you also want to empty the cell, select it and press Delete separately. On Windows, Delete clears cell contents; it does not remove the data validation rule.

Clear All in the Data Validation dialog also removes settings associated with that validation, such as its input message and error alert. It does not delete the source values stored elsewhere in the workbook, change other cells, or remove ordinary formatting such as color and borders.

Remove the Dropdown from One Cell

Select the cell with the dropdown. If the arrow is not visible, click the cell anyway; the arrow typically appears when a validated cell is selected.
On the ribbon, choose Data > Data Validation. In some ribbon layouts, Data Validation is in the Data Tools group.
In the Settings tab of the Data Validation dialog, select Clear All.
Select OK to apply the change.

Afterward, click the cell and check that its list arrow is gone. You can type a value that was not in the former list to confirm that the list restriction has been removed. If the cell still has another kind of validation, such as a number or date limit, it may continue to reject some entries even though the dropdown is gone.

If the goal is only to hide the arrow while retaining the list restriction, do not use Clear All. In Data Validation, the In-cell dropdown setting controls whether a list arrow is displayed. Turning that setting off can leave the validation rule in place, so entries may still be restricted. That distinction matters when you want to prevent invalid typing but do not want an arrow shown.

Remove Dropdowns from Multiple Cells

You can clear validation from a selected range in one operation. Select the cells, open Data > Data Validation, choose Clear All, and select OK. This removes validation from the selected cells, not just from the active cell. Be careful with a large selection: cells that use different rules will all lose their validation.

To locate validated cells before changing them, use Excel’s Go To Special feature:

Press Ctrl+G or F5 on Windows to open Go To, then choose Special.
Select Data validation. Choose All to find cells with any validation, or Same to find cells with the same validation as the active cell.
Select OK. Excel selects matching cells on the active sheet.
Open Data > Data Validation, choose Clear All, and select OK to remove their rules.

Go To Special can help reveal dropdowns that are easy to miss across a worksheet. “Same” is useful when you want to target a group that shares the active cell’s validation settings; “All” can include cells with different kinds of validation. Inspect the selection before clearing anything, especially in a template where validation may be protecting important entry fields.

For nonadjacent cells, hold Ctrl while selecting individual cells on Windows, or select separate ranges as needed, then apply Clear All. If the cells are spread across different worksheets, repeat the process on each sheet. A normal selection and a validation change apply to the current sheet; they do not automatically remove rules throughout the workbook.

Remove the Rule Without Clearing Other Cell Features

Clear All in the Data Validation dialog is intended to clear validation settings, but it is not the same as Home > Clear > Clear All. The latter is a broader worksheet command that can remove cell contents, formatting, comments or notes, and other cell features. If you want to retain a cell’s value, number format, fill color, and borders, remove validation through the Data Validation dialog instead.

Likewise, do not delete the worksheet row or column just to get rid of a dropdown unless you intend to remove that entire part of the sheet. Removing validation is the focused change: it stops the rule from governing the chosen cell while leaving its data and ordinary formatting in place.

There is a related distinction between the validation rule and the list’s source. A dropdown may get its choices from a range on another sheet, a named range, or a typed list in the validation settings. Clearing the source range does not necessarily remove the rule. The cell can remain configured as a list even if its choices are now blank, incomplete, or invalid. To remove the dropdown itself, clear the validation rule in the target cell.

Why a Dropdown May Seem to Remain

The wrong cell was selected. The arrow belongs to the cell containing the validation, which may be beside the cell you expected. Select the cell and reopen Data Validation to inspect it.
The rule was not confirmed. After choosing Clear All, select OK. Closing the dialog without applying the change leaves the original settings in place.
Only the source list was changed. Deleting or renaming source values does not reliably remove validation from cells that refer to them.
The arrow is from a different feature. A filter arrow in a table header or AutoFilter is not a data-validation dropdown. To change worksheet filters, use Data > Filter; do not clear cell validation for that purpose.
The sheet is protected. Protection can prevent changes to validation or locked cells. If you are authorized to edit the sheet, use Review > Unprotect Sheet, provide a password if requested, and then remove the rule. Do not assume a protected worksheet can be edited without its password.
Another cell has its own rule. Similar-looking cells can have separate validation settings. Check each relevant cell or use Go To Special to find validated cells.

A useful test is to select the exact cell and open Data > Data Validation. If the dialog reports that the selection contains different validation settings, the selected cells do not all share one rule. Work with one cell or a group of matching cells at a time rather than applying a change to a mixed selection without checking its effect.

What Happens to Existing Entries and List Sources

Removing validation generally leaves existing entries untouched, including entries that would not have been allowed by the former list. For instance, if a cell currently says “Awaiting review” and you remove a dropdown whose choices were “Open,” “Closed,” and “On hold,” the text remains. You can then edit it like ordinary cell content, subject to any other restrictions.

The source list remains wherever it is stored. If the choices are in a helper column, a separate worksheet, or a named range, removing validation from one cell does not delete that source. Other dropdowns may still use it. Keep the source if other parts of the workbook depend on it; remove it separately only after checking those references.

If you are cleaning up a workbook for someone else, consider documenting the change or checking related cells first. Data validation often supports consistent spelling, reporting, and later filtering. Removing a list can make data entry more flexible, but it can also allow inconsistent terms such as “In progress,” “In-Progress,” and “Progressing” to accumulate.

Excel for Mac and Excel for the Web

In Excel for Mac, select the relevant cells and use the Data tab’s Data Validation command. In the validation dialog, use Clear All and confirm the change. Ribbon labels and dialog layout can vary slightly by Excel release, but the key action is to clear the validation settings rather than delete the cell’s contents.

In Excel for the web, select the cell or range and look for Data Validation on the Data tab. The interface can differ from the Windows desktop dialog and may present validation controls in a pane. If the available controls do not offer a way to remove the rule, open the workbook in the desktop Excel app and use Data > Data Validation > Clear All. Avoid clearing the cell or source list as a substitute: neither is a reliable way to remove the rule itself.

The keyboard shortcuts above are for Windows. Mac keyboards and Excel settings use different key combinations for navigation; using the Data tab commands is a dependable alternative on either platform. The exact route can also differ if the ribbon is customized or the window is narrow.

When to Keep or Replace the Dropdown

Removing a dropdown is appropriate when users should be able to enter free-form values, the list is obsolete, or the validation is attached to the wrong cells. Before removing it from a shared template, consider why the rule was added. A short controlled list can prevent typos and make sorting, summaries, and filters more reliable.

If the list is outdated but still useful, edit its source or update the list settings rather than deleting validation. If only a few new choices are needed, add them to the source range or typed list, as appropriate. If users need both standard choices and occasional exceptions, you can allow an error-alert configuration that fits that workflow, or provide a separate notes field for exceptions. The best choice depends on whether consistent data or unrestricted entry matters more.

You can also remove validation from just selected cells and leave it in the rest of the column. For example, a status column may use a controlled list for routine rows while a special input cell remains unrestricted. Test the workbook after editing, particularly if it has formulas, reports, or instructions that assume entries come from a fixed set of terms.

Frequently Asked Questions

How do I remove a dropdown in Excel but keep the value?
Select the cell, choose Data > Data Validation, select Clear All, and click OK. This removes the validation rule but leaves the current cell content in place.

How do I remove a dropdown from an entire column?
Select the cells in that column that should no longer have the list, then use Data > Data Validation > Clear All > OK. Check the selection first so you do not remove validation from cells that should keep it.

Why does the dropdown arrow disappear only when I click away?
Excel’s in-cell list arrow is normally shown when a validated cell is selected, not continuously. Select the cell to see it. If you want to remove the rule, use Clear All; if you want to keep the restriction but hide the arrow, change the In-cell dropdown setting instead.

Does pressing Delete remove an Excel dropdown?
No. Delete clears the selected cell’s contents, but the data-validation rule usually remains. Use Data > Data Validation and Clear All to remove the rule.

Can I remove a dropdown without changing the cell formatting?
Yes. Clear the rule from the Data Validation dialog. Avoid Home > Clear > Clear All if you want to preserve formatting and other cell features.

Why can’t I remove the dropdown from a protected sheet?
Worksheet protection may block changes to validation or locked cells. If you have permission, unprotect the sheet through Review > Unprotect Sheet, then clear the rule. A password-protected sheet may require the password from its owner.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.