How to Remove a Dropdown List from an Excel Cell

To remove a dropdown list from a cell in Excel for Microsoft 365 on Windows, select the cell, choose Data > Data Validation, and click Clear All in the dialog box. Click OK to remove the validation rule; the cell’s existing value and the list’s source data are not deleted.

What removing a dropdown list actually does

Most cell dropdowns are created with Excel’s Data Validation feature. A validation rule can restrict entries to a list, show an in-cell arrow, and display an input message or an error alert. Clearing the rule removes those restrictions and related validation settings from the selected cells. Afterward, a user can type any value into them, subject to other worksheet protections or rules.

Removing validation is different from clearing the cell’s contents. If a cell currently contains “Approved,” clearing its dropdown rule leaves “Approved” in place. It also does not erase the values that supplied the dropdown choices, whether those values are on another sheet, in a named range, or typed into the rule’s Source box. Those choices remain available to other cells or workbook features.

Step-by-step: remove the dropdown in Excel for Windows

Select a cell that has the dropdown. To remove it from several neighboring cells, select the whole range instead. You can also select a range with the Name Box to the left of the formula bar, then enter a reference such as B2:B30.
Open the Data tab on the ribbon and choose Data Validation. In some ribbon layouts, the command is in the Data Tools group. If a menu appears, choose Data Validation there to open the dialog.
On the Settings tab, click Clear All. This removes the validation settings for the selected cells, not their contents.
Click OK. Select a cell and check that its dropdown arrow is gone. If you removed a list rule, you should also be able to enter a value that the old rule would have rejected.

You do not need to know how the original list was built. The rule can refer to a cell range, a named range, or a comma-separated set of entries; Clear All removes the rule in each case. If the selected range contains different validation rules, clearing all will remove the rule from every selected cell, so check the selection before confirming.

Remove dropdowns from multiple cells without changing other cells

When a dropdown appears in many places, the important step is selecting the correct cells. If the affected cells form one continuous block, drag across the range or click the first cell, hold Shift, and click the last. Then use the same Data > Data Validation > Clear All steps. Excel applies the removal to the selected cells.

For scattered cells, hold Ctrl on Windows while selecting each cell or range, then open Data Validation and clear the rules. On Mac, use Command while selecting separate cells or ranges. Take care not to include cells that should retain their dropdowns. If a selection includes ordinary cells as well, clearing validation does not erase their entries, but it will remove any validation rules they have.

You can also locate cells with validation using Excel’s Go To Special feature. Press Ctrl+G or F5, choose Special, select Data Validation, and choose All to select cells with validation on the sheet. Choosing Same selects cells whose validation matches the active cell. Review the highlighted selection before clearing anything: selecting all validation can include rules other than dropdown lists, such as whole-number or date restrictions.

Keep the current entry, or clear it separately

Many people want to remove the arrow but keep the value already chosen. The standard Clear All procedure does that. It changes the validation rule, not the cell’s value, formatting, or formula. For example, if C5 contains “In progress” from a status dropdown, clearing validation leaves “In progress” in C5. The cell can then accept a different entry without the former list restriction.

If you also want to empty the cell, do that as a separate action after removing the rule. Select the cell and press Delete on Windows. On Mac, press Delete or Backspace, depending on the keyboard. This clears the cell’s contents; it is not the same as choosing Clear All in the Data Validation dialog. Avoid using a general worksheet-clearing command unless you intend to remove other properties such as formatting too.

Conversely, if you only want to change the selected value while keeping the dropdown, simply replace the value in the cell. Removing the validation rule is unnecessary if the list should remain available for future entries.

When the arrow remains: identify what kind of dropdown it is

Not every small arrow visible in a worksheet is a data-validation dropdown. Before repeating the removal steps, identify where the arrow appears and what it controls.

Cell dropdown: The arrow appears when you select a cell and is usually created by Data Validation. Use the Data Validation dialog to remove it.
Table filter arrow: Arrows in a table’s header row filter or sort table data. They are not cell validation rules. To remove them, click in the table and use Table Design > Filter Button to turn off the buttons, or use Data > Filter to toggle filtering, depending on the table and ribbon layout. This affects the table headers, not validation in cells.
Form control or ActiveX combo box: This is an object placed over the worksheet, not a dropdown inside a cell. A combo box may display a value from a linked cell. Removing the object is different from removing that cell’s validation.
Filter or slicer control: A slicer is a separate visual control connected to a table or PivotTable. It will not be removed by clearing validation from a cell.

For a worksheet control, select its border rather than the cell underneath and press Delete. ActiveX controls may require Developer > Design Mode before you can select and delete them. If the Developer tab is not visible, it can be enabled in Excel’s ribbon settings. Before deleting a control, check whether a form or report depends on it. Its linked cell and source list may remain even after the object is deleted.

Change or hide the dropdown instead of removing it

Removing the rule is not always the best fix. If the list is still useful but needs different choices, open Data > Data Validation, edit the Source on the Settings tab, and leave the validation in place. For a source range, changing the entries in that range can update the choices without removing the rule. Check whether the rule refers to the intended range or a named range before editing the source.

If users should be allowed to type entries that are not on the list, inspect the Show error alert after invalid data is entered setting. Turning off the error alert can allow other entries while retaining the dropdown choices. This changes how Excel responds to invalid entries; it does not remove the validation rule or necessarily remove its arrow. If you want the rule and arrow gone altogether, use Clear All.

The Settings tab also includes the In-cell dropdown option for list validation. Clearing that option can hide the arrow while leaving the list rule in place. That is different from removing validation: restrictions and other rule settings may still apply, and users may not see the available choices. Choose this only when hiding the arrow is the intended behavior.

Excel for Mac and Excel for the web

In Excel for Mac, select the target cell or range and open Data > Data Validation. Use Clear All in the validation dialog, then confirm with OK. Ribbon placement and dialog appearance can vary between releases, but the task is the same: remove the validation rule from the selected cells. For multiple nonadjacent cells, use Command while selecting them.

Excel for the web has Data Validation tools, but the controls available can differ from the desktop application and may depend on the workbook and current version. If you cannot find a way to remove the rule in the web interface, open the workbook in the desktop Excel app and use the Windows or Mac steps above. Avoid assuming that deleting the cell’s displayed value in the browser removes its dropdown; clearing a cell’s contents and removing its validation are separate operations.

Common problems and how to troubleshoot them

The dropdown is still visible: Confirm that the arrow belongs to the selected cell, not a table header or an overlaid control. Reopen Data Validation and check that the intended cell or range was selected.
Clear All is unavailable or changes do not stick: The sheet may be protected, or workbook permissions may prevent editing. Check Review > Unprotect Sheet if you have authorization and the password, or ask the workbook owner for access. Do not try to bypass protection.
Only some cells lost the dropdown: The rule may have been applied to only part of the range. Select the remaining cells and inspect their validation settings. A copied cell can also bring its own rule with it, so check the final cells after pasting.
The dropdown choices still exist elsewhere: This is expected. Removing validation from a destination cell does not delete the source list. Remove or edit source data only if you are sure no other rule, formula, or report uses it.
A pasted value seems to restore the dropdown: A normal paste can carry formatting or validation from the copied cell. Check the destination’s rule after pasting; use a paste option that transfers values only when appropriate, and verify that the destination’s other intended properties remain intact.

If a workbook is shared, contains macros, or uses controls linked to cells, consider saving a separate copy before making broad changes. That makes it easier to compare the result or restore the original if you selected more cells than intended.

Frequently Asked Questions

Does removing a dropdown delete the value already in the cell?
No. Clearing the Data Validation rule leaves the cell’s existing value or formula in place. Use Delete or Backspace separately if you also want to clear its contents.

Will removing one dropdown remove the list from the whole worksheet?
No, unless you select all the cells that have the rule. The change applies to the selected cells only. Check the selection carefully, especially when removing validation from several nonadjacent cells.

Why can I still see the dropdown choices after clearing the rule?
The choices may be stored in a source range or named range. Clearing a cell’s validation does not erase that source data, and other cells may still use it.

Can I remove the arrow but keep the list restriction?
For a list validation rule, you can clear In-cell dropdown in the Data Validation settings to hide the arrow while retaining the rule. This differs from Clear All, which removes the validation settings.

Why does the dropdown return after I remove it?
The rule may have been applied to a different cell than the one you changed, restored by copying and pasting, or re-created by a macro or workbook process. Check the affected cell’s Data Validation settings and the workbook’s automation or shared editing workflow.

Before you finish

After removing the rule, test one of the affected cells by selecting it and entering a value that the former list did not contain. Confirm that unrelated cells still have their dropdowns and that the existing entries you wanted to keep remain intact. These checks distinguish a successful validation change from simply hiding an arrow or clearing a cell’s contents.

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.