Google Sheets Delete a Dropdown: Steps and Fixes

To delete a dropdown in Google Sheets, select the cell or range that has it, open Data > Data validation, select the relevant rule in the side panel, and click Remove rule. This removes the dropdown restriction; it does not automatically erase the cell’s current value.

Remove a dropdown with Data validation

Google Sheets stores dropdowns as data validation rules. Removing the rule is therefore different from clearing the cell contents. In a browser, use these steps:

Select a cell that displays the dropdown, or select the range of cells you want to change.
Open Data > Data validation from the menu bar. The data validation rules appear in a side panel.
Choose the rule that applies to your selection if the panel shows more than one.
Click Remove rule. The dropdown arrow or chip-style control should disappear from cells governed by that rule.

If you selected a range before opening the panel, check the rule’s apply-to range so you know what will be affected. A rule may cover many cells even if you opened the panel from only one of them. Removing it can make every cell in that rule’s range accept ordinary input, so avoid removing a shared rule if you intend to change just one cell.

Google Sheets may show dropdowns as colored chips or as arrows, depending on the display style. That visual choice does not change the removal process: delete the validation rule, rather than trying to erase the visible arrow or chip.

Deleting the dropdown is not the same as deleting its value

A dropdown combines a validation rule with whatever value is currently stored in the cell. Removing the rule stops Sheets from requiring or suggesting a choice from that list, but a value already selected—such as Approved, Pending, or Rejected—normally remains in the cell. This is useful when you want to preserve existing records while allowing people to enter different text later.

If your goal is to empty the cell as well, select it and press Delete or Backspace on your keyboard. That clears the cell’s contents, but it does not, by itself, remove the dropdown rule. You may need to perform both actions: clear the value, then remove the validation rule. Check the result before clearing a large range, since this action can remove data you still need.

There is a similar distinction between removing a rule and replacing it. Editing the rule can change the allowed choices while keeping validation in place. Removing it leaves the cell without that dropdown restriction. Choose based on whether you still want a controlled list.

Remove a dropdown from one cell or part of a range

When a dropdown appears in only one cell, select that cell and remove its rule. When a dropdown appears across a table column, the rule may apply to a range such as C2:C100. To remove it from only a few cells, first inspect the rule’s apply-to range in the side panel. If Sheets offers a way to adjust that range, revise it to exclude the cells you want to keep controlled, then remove the rule from the cells that should no longer have it.

For a simple one-off exception, you can also select the target cells and use Data > Data validation to remove the rule associated with that selection. Afterward, check a nearby cell that should retain the dropdown. If that neighboring dropdown has disappeared too, undo immediately with Ctrl+Z on Windows or ChromeOS, or Command+Z on a Mac, then adjust the rule range more carefully.

Be cautious with merged cells and large selections. A selection can intersect a rule that covers more cells than you expected. If the sheet is important or shared, note the range and existing choices before changing the rule, and verify representative cells in and around the edited area afterward.

Remove dropdowns from many cells

For a block of cells, select the whole block first, then open Data > Data validation. Remove the rule that applies to the selected cells. This is often quicker than repeating the operation cell by cell, but only when the selected cells share the rule you want to remove. A block may contain several distinct rules, for example one dropdown for Status and another for Priority, so review the panel rather than assuming there is just one.

If a whole sheet has unwanted dropdowns, do not assume that selecting every cell and removing one rule will clear every dropdown. Different cells can have different rules and apply-to ranges. Work through the relevant rules, or select and inspect the affected areas separately. A safer approach is to start with one known dropdown, identify its rule and range, then repeat for other kinds of dropdowns.

Before making a broad change to a shared spreadsheet, consider making a copy with File > Make a copy, or use version history if you need to restore an earlier state. This is especially sensible when the dropdowns enforce a workflow or feed a summary, chart, or report. Removing validation can let future entries become inconsistent even if existing values stay unchanged.

Edit the dropdown instead of deleting it

Sometimes a dropdown is working correctly but its choices are outdated. In that case, edit the rule rather than removing it. Select a cell governed by the dropdown and open Data > Data validation. Choose the rule, then update its criteria. Depending on how the dropdown was created, the choices may be entered directly in the rule or drawn from a range of cells.

For example, a project tracker may offer Not started, In progress, and Complete. If the team now uses Blocked as an additional status, edit the list to include that choice instead of deleting validation. If the dropdown is sourced from a range on another sheet or in a setup area, update the source list and confirm that the rule includes the new entry. The precise fields shown depend on the rule’s source and the current Sheets interface.

Changing a source list is not always the same as changing existing cell values. A cell that already contains a choice removed from the list may remain populated, even though the value is no longer an allowed option. Review the sheet for old entries if consistency matters. Also check the rule’s invalid-data behavior: validation can reject unlisted entries or display a warning, depending on its settings.

Why a dropdown may not disappear

If the dropdown remains after you remove a rule, a few common causes are worth checking:

You removed a different rule. A cell can be affected by a rule other than the one currently selected in the side panel. Select the exact cell showing the control and inspect the listed rules.
Another rule also covers the cell. The same area may be affected by multiple validation rules. Review each applicable rule rather than stopping after the first removal.
You cleared the cell, not its validation. Pressing Delete or Backspace removes the entry, but the dropdown can remain because the rule is still active.
You edited the list but did not remove validation. Changing choices updates the dropdown; it does not turn the cell into unrestricted text.
You lack permission to change the sheet. A protected sheet or range can prevent edits. Ask the owner or an editor with the necessary access to change the protection or remove the rule.

Also confirm that you are editing the intended spreadsheet and tab. In a shared file, another editor could change a rule while you work. Once a rule is removed, click a cell and try entering a value that was not on the old list; if Sheets accepts it without a validation warning, the restriction has likely been removed. Do not use an unusual test value in a live record unless it is safe to do so.

What happens to formatting and connected data

Removing data validation removes the dropdown behavior, not necessarily the cell’s formatting. A colored background, text color, border, or conditional formatting rule can remain because those are separate settings. For instance, a status cell may still turn green when it contains Complete even after its dropdown is gone. If you want to remove that appearance too, inspect the relevant formatting settings separately rather than expecting Remove rule to reset the cell’s style.

Similarly, deleting a dropdown does not delete the list of choices stored elsewhere in the workbook. If the dropdown used values from a helper range, that source list remains until you delete it yourself. Other formulas, charts, or dropdowns may depend on the same range, so do not remove it just because one validation rule is no longer needed.

Existing formulas in a selected cell deserve special care. Clearing contents can remove a formula, while removing validation should leave the formula or value alone. If a cell both contains a formula and has a validation rule, review your selection before using Delete or Backspace. For data cleanup, distinguish clearly between changing the rule, clearing the entry, and deleting formatting or source data.

How Google Sheets differs from Excel

These directions are for Google Sheets in a web browser. In Microsoft Excel for Microsoft 365 on Windows, select the cells, open Data > Data Validation, and use Clear All in the Data Validation dialog to remove the validation settings. Excel’s dialog and Google Sheets’ side panel are different interfaces, even though both use validation rules for dropdown lists.

Keyboard shortcuts can clear cell contents in either spreadsheet program, but they are not a substitute for removing data validation. In Google Sheets, use the Data validation panel to remove the rule. The Google Sheets mobile app may arrange commands differently from the browser; if you cannot find the same side panel on a phone or tablet, open the file in a desktop browser for these exact menu steps.

Frequently Asked Questions

How do I remove a dropdown but keep the selected text?
Select the cell, open Data > Data validation, select the rule, and click Remove rule. The existing entry normally remains; avoid pressing Delete or Backspace if you want to keep it.

Why does the dropdown remain after I press Delete?
Delete or Backspace clears the cell’s contents, not its validation rule. Open Data > Data validation and remove the rule to get rid of the dropdown control.

Can I remove a dropdown from just one cell?
Yes. Select the cell and remove the rule that applies to it. If the rule covers a larger range, check its apply-to range and verify that neighboring cells still have the dropdown if they should.

Can I delete the dropdown choices but leave the cell blank?
Remove the validation rule to remove the choices, then clear the cell contents separately if it contains a value. These are two distinct actions, so clear only the cells whose contents you intend to erase.

Will removing a dropdown delete its source list?
No. Removing validation removes the rule from the affected cells. A helper list used as the dropdown source remains in the sheet unless you delete that range separately.

Can I restore a dropdown after removing it?
You can immediately use Undo, or recreate the validation rule through Data > Data validation. If you do not know the original choices or source range, check version history or ask the sheet owner before rebuilding it.

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.