How to Get Rid of a Dropdown List in Excel Quickly

To remove a dropdown list in Excel, select the cell or range, go to Data > Data Validation, choose Clear All, and select OK. This removes the validation rule but keeps any values already in the cells. If you only want to hide the arrow or remove a selected value, use the alternatives below instead.

What You’ll Need

The workbook open in Microsoft Excel for Microsoft 365 on Windows, with permission to edit the cells.
A way to identify the affected cell or range. If you are unsure where the dropdowns are, you can locate validated cells using Excel’s Go To Special command.
If the sheet is protected, the password or permission needed to unprotect it. You may need to ask the workbook owner for access.

You do not need to know where the dropdown’s list items are stored to remove the rule. The list may come from values typed into the validation window, a range on another sheet, a named range, or a formula. Clearing the validation from the dropdown cells is the key step.

Step-by-Step

Decide what you want to remove. Excel dropdowns are usually created with Data Validation. Removing that validation means the cell will no longer restrict entries to the list. It does not erase the cell’s current value. If you only want to clear one selected entry, use the Delete key instead; if you want the arrow gone but want to keep the list restriction, see the hide-arrow option in step 5.
Select the cell or cells with the dropdown. Click one cell to remove its dropdown only. To remove dropdowns from a block, drag across the cells or click the first cell, hold Shift, and click the last. To select separated cells, hold Ctrl while clicking each one on Windows. For a whole column of dropdown cells, select the relevant portion of the column rather than the entire worksheet column if other cells have rules you want to keep. Check the highlighted selection before changing anything.
Open the Data Validation settings. On the ribbon, choose Data > Data Validation. In the Data Validation dialog, open the Settings tab if it is not already displayed. The dialog may show Allow: List for a dropdown cell. If you see a different setting, the cell may have another kind of validation, or your selection may include cells with different rules. The next action clears validation for every selected cell, so verify the selection before continuing.
Clear the validation rule. In the dialog, choose Clear All, then select OK. Clear All removes the validation settings from the selected cells, including any list restriction, input message, and error alert associated with that validation. It does not clear cell contents, formatting, formulas, comments, or the source list stored elsewhere. Click a changed cell to check that the dropdown arrow is no longer available and test that the cell accepts an entry that was not on the old list.
Hide the arrow without removing the restriction, if that is your goal. Open Data > Data Validation for the cell, and on the Settings tab clear the In-cell dropdown checkbox, then select OK. The list arrow will be hidden, but the list validation remains: Excel can still reject entries that do not meet the rule. Use this option when you want to keep the restriction but do not want users to choose from the visible arrow. Do not choose Clear All for this outcome.
Remove a value without changing the dropdown rule, if needed. Select the cell and press Delete on Windows. This clears the cell’s contents but leaves its validation in place, so the arrow can still appear when the cell is selected. On a Mac, press the Delete key; depending on the keyboard, Backspace may be labeled Delete. If the cell contains a formula or a value you want to retain, do not use this step.
Check the rest of the workbook and save. Test one cell from each affected part of the selected range. Confirm that existing entries remain, that the dropdown is gone where intended, and that dropdowns outside the selection still work. Save the workbook with Ctrl+S on Windows or Command+S on Mac. If the outcome is wrong and you have not made other changes since, use Ctrl+Z on Windows or Command+Z on Mac to undo.

To find dropdown cells you cannot readily see: On Windows, choose Home > Find & Select > Go To Special, select Data validation, choose All or Same, and select OK. All selects cells with any validation in the current selection or worksheet context; Same selects cells with the same validation as the active cell. Review what Excel highlights before clearing anything. Go To Special can also find other types of validation, not only list dropdowns.

On Mac, the Data Validation dialog is also available from the Data tab; select the relevant cells, open Data Validation, and use Clear All followed by OK. Excel for the web has Data Validation controls on the Data tab, though the location and available options can vary with the current interface. If you cannot find Clear All in the web version, open the workbook in the Excel desktop app and use the steps above. Always check the selected range, especially when removing rules from a shared template.

Common Mistakes

Pressing Delete and expecting the arrow to disappear. Delete removes the cell’s contents, not its validation. The dropdown can still be used afterward. Use the Data Validation dialog to remove the rule.
Deleting the list source instead of the dropdown rule. Removing values from a source range, named range, or list formula may leave validation in place. It can also make the dropdown empty or cause an error. Clear validation on the cells where the dropdown appears.
Using Clear All on the wrong selection. The button clears validation settings across every selected cell. Selecting a whole column or a large range by mistake can remove rules you meant to keep. Select a specific cell or carefully defined range first.
Assuming the arrow is always visible. In-cell dropdown arrows generally appear when a validated cell is selected. Click the cell before deciding that its dropdown has disappeared.
Confusing a filter arrow with a validation dropdown. Arrows in a table header or in a filtered list control sorting and filtering, not cell-entry validation. Removing Data Validation will not remove those. Use the table’s filter controls or turn off the sheet’s filter if those are the arrows you mean.
Choosing Clear All when you only want to hide the arrow. Clear All removes the restriction as well as the arrow. Uncheck In-cell dropdown instead if entries should remain limited to the allowed list.

Tips

Make a copy before a broad cleanup. For a workbook with many rules, save a separate copy before removing validation across large ranges. This gives you a safe reference if you later discover that some cells needed their dropdowns.
Work in small, checked groups. If similar dropdowns appear in different sections, handle one section at a time and verify it before moving on. This reduces the chance of removing a rule from an unrelated input area.
Keep the current values when removing only the rule. Clear All in Data Validation leaves existing entries in place. This is useful when a workbook has already been filled in and you want users to edit freely without losing the recorded choices.
Identify the arrow type first. A validation arrow belongs to a selected cell. A filter arrow is normally in a header row, and a form control or combo box may float over cells. The method depends on which kind you have; Data Validation applies only to the cell-entry rule.
Review input prompts and error alerts. If the dropdown is being removed because it blocks a legitimate entry, consider whether the cell’s prompt or error message was useful. Clear All removes those validation messages for the selected cells too, so you may need another way to document expected inputs.

Troubleshooting

The Data Validation command is unavailable or will not let you make changes. First check whether the worksheet is protected. On Windows, look under Review > Unprotect Sheet. If the sheet requires a password, you need the password or help from its owner; do not try to work around the protection. A workbook shared with restricted editing permissions can also prevent changes. Once you have editing access, select the cells again and reopen Data Validation.

The dropdown arrow is still there after Clear All. Click the cell to see whether the arrow appears only on selection, then reopen Data Validation with that exact cell selected and check whether a list rule remains. If you selected only part of a merged area or missed a neighboring cell, repeat the operation for the correct cells. If the arrow is in a table header, it is a filter control, not a validation list. If it is a floating object, it may be a form control or combo box and must be removed as an object instead.

Excel says the entry is invalid even though the dropdown is gone. Hiding the arrow by unchecking In-cell dropdown does not remove the list restriction. Reopen Data Validation and choose Clear All if users should be able to enter any value. Also check whether the cell is protected or the error is coming from a formula, conditional formatting, or another workbook process rather than Data Validation.

Some cells in the range still have dropdowns. The selection may not have included every affected cell, or some cells may have been skipped because the range is noncontiguous. Use Go To Special to locate validated cells, inspect the highlighted cells, and clear the rules from the intended cells. If the cells have different validation settings, selecting Same may find only the cells matching the active cell; use All when you need to locate different rule types, then review the selection carefully.

The list is blank or has changed, but the arrow remains. That usually means the validation rule still exists while its source has changed or is empty. If you want to keep the dropdown, repair its source; if you want the dropdown gone, clear the validation from the target cells. Removing the source alone does not reliably remove the rule, and can affect other dropdowns that share that source.

You cannot find the Data Validation option in Excel for the web. Check the Data tab and make sure you have selected a worksheet cell rather than a chart or shape. If the command is missing or the web interface does not provide the setting you need, choose to open the workbook in the desktop app, if available. Use the Windows or Mac desktop steps, then save the workbook so the change is available to collaborators.

Frequently Asked Questions

Will removing a dropdown delete the value already in the cell?
No. Clearing validation removes the rule, not the cell’s contents. The existing text, number, or date stays in place unless you separately clear or replace it.

Can I remove a dropdown from many cells at once?
Yes. Select the cells or range, open Data > Data Validation, choose Clear All, and select OK. Every selected cell loses its validation, so avoid including cells whose rules you want to preserve.

Can I remove the dropdown arrow but still prevent unapproved entries?
Yes. In Data Validation, clear In-cell dropdown instead of choosing Clear All. The visible list arrow goes away, but the validation rule continues to control which entries Excel accepts.

Why does the arrow appear only when I click the cell?
That is normal for a Data Validation list. Select the cell to display its in-cell dropdown arrow. If an arrow remains visible in a header or on top of the sheet when no cell is selected, it may be a filter or a separate form control.

Does deleting the source list remove the dropdown?
Not necessarily. The cell’s validation rule can remain even if its source range is emptied or deleted. Clear the rule from the cells using Data Validation, or update the source if you want to keep the list working.

Can I undo the change?
Usually, yes: use Ctrl+Z on Windows or Command+Z on Mac soon after the change. If you have made many later edits, undoing may reverse those too. A saved backup is safer when changing validation across a large workbook.

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.