Remove a Dropdown in Google Sheets Without Deleting Data

To remove a dropdown in Google Sheets, select the cell or range, open Data > Data validation, and click Remove rule in the sidebar. This removes the dropdown rule, not the cell’s existing value. Before you begin, check whether the rule covers other cells too, so you do not remove it from more of the sheet than intended.

What You’ll Need

Access to the Google Sheets file with permission to edit it. View-only access will not let you change validation rules.
A web browser with the spreadsheet open. These steps describe Google Sheets in a browser; the mobile app has a different interface.
The cell, cells, or range where the dropdown appears. If you are unsure which cells share the rule, inspect the rule’s applied range before removing it.

Step-by-Step

Open the spreadsheet and find the dropdown. Click the cell that shows the dropdown arrow, chip, or selectable list. If there are several dropdowns, start with one cell and confirm that it is the rule you intend to remove. A dropdown can be configured with text options, dates, numbers, or a list taken from a range, but the removal process is broadly the same.
Check the affected area. Look at the row and column labels and note whether the dropdown is in one cell, a block of cells, or an entire column. Selecting a single cell first helps you inspect the matching validation rule. If you plan to remove dropdowns from several cells, select only the intended cells; do not select a whole column unless you mean to affect every applicable cell in it.
Open the validation controls. With the target cell or range selected, use the menu at the top of the sheet and choose Data > Data validation. Google Sheets opens the data validation sidebar. Depending on the sheet and interface state, it may show one or more rules that apply to the selected cells. If the sidebar does not open, make sure you selected a cell in the grid rather than a chart, drawing, or menu item, then open the menu again.
Review the rule and its applied range. In the sidebar, check the criteria and the range listed for the rule. The criteria may show a list of items, a dropdown sourced from a cell range, or another validation condition. Confirm that the range includes the cells you want to change. This check matters because one rule can cover many cells, even if you opened the sidebar from just one of them.
Remove the rule. Click Remove rule for the rule you want to delete. If the sidebar lists multiple rules, remove only the rule responsible for the unwanted dropdown. Removing a rule stops Sheets from offering or enforcing that dropdown in the covered cells. It does not, by itself, clear the values already stored in those cells.
Handle a rule that covers both wanted and unwanted cells. If only one cell should lose its dropdown while other cells should keep it, do not remove a shared rule without adjusting its range. Edit the rule’s applied range so it excludes the cell, or split the range into separate areas that include the cells that should retain the dropdown. For example, if a rule applies to A2:A20 but A10 should be free of it, set the rule to cover A2:A9 and A11:A20, if the range field accepts the separated ranges. Review the result in the sheet before closing the sidebar.
Check the cell after removal. Click the cell again. The dropdown control should no longer appear, and you should be able to enter ordinary content without that rule’s validation. Existing text or numbers should remain. If the arrow or chip is still there, reopen Data > Data validation and check for another rule applying to the cell, or verify that you removed the correct rule.
Repeat only where necessary. For dropdowns in separate areas, select each area and inspect its rule before removing it. You can select a contiguous range of cells and remove a shared rule once. Avoid assuming that every dropdown in the sheet uses the same rule: one may use a manually entered list while another gets its choices from a range, and each may need separate attention.

Google Sheets saves changes automatically, but it is still sensible to check the cells immediately after making the change. If the spreadsheet is shared, tell collaborators that the choices have been removed when that change affects how they enter data.

Common Mistakes

Deleting cell contents instead of the rule. Pressing Delete or Backspace clears selected cell contents; it is not the command for removing validation. To keep the current value, use Data > Data validation and remove the rule there. If you already cleared a value, use Undo promptly if no later action needs to be preserved.
Removing a rule used by a larger range. A dropdown visible in one cell may come from a rule applied to many rows. Check the applied range before clicking Remove rule. If only one cell needs to change, edit or split the range rather than removing a shared rule from all its cells.
Removing the wrong rule. A cell may have more than one validation condition, or the sidebar may list rules for the selected range. Read each rule’s criteria and range. Remove only the one that produces the dropdown you want to get rid of.
Confusing a dropdown with a filter control. Small arrows in a table header may be filter controls, not cell validation dropdowns. Removing data validation will not remove a filter. A filter is managed from the toolbar or the Data menu, and removing it changes how rows are displayed rather than changing a cell’s allowed entries.
Expecting old entries to disappear. Removing validation does not erase existing values or necessarily change text that was entered earlier. If you want to clear the value too, select the cell and clear its contents as a separate, deliberate action.

Tips

Make a copy before broad edits. If the sheet is important or the rule spans many rows, use File > Make a copy before changing it. A copy gives you a straightforward fallback if you discover that other people depend on the dropdown.
Use a narrow selection first. For a single unwanted dropdown, click its cell rather than selecting a broad range. Then inspect the rule’s applied range in the sidebar. This separates the place you clicked from the full area controlled by the rule.
Keep the allowed values if you may need them later. If the choices come from a source range, removing validation does not delete that source list. Avoid deleting the source cells unless you have checked whether other dropdowns or formulas use them.
Consider whether you want to change or remove the dropdown. If the list is still useful but has outdated choices, edit the rule and its options instead of removing it. If you only want to alter how the dropdown looks, the display style may be adjustable in the rule settings; changing its appearance is not the same as removing the rule.
Remember the Excel difference. These instructions are for Google Sheets in a browser. In Excel for Microsoft 365 on Windows, select the cells and use Data > Data Validation, then choose Clear All in the dialog. Excel’s controls are not the same as Google Sheets’ validation sidebar.

Troubleshooting

The Remove rule option is unavailable. You may not have edit access, or the selected item may not be a cell with a validation rule. Ask the owner for editor access, select an actual cell in the grid, and check Data > Data validation again. Protected ranges or protected sheets can also prevent changes; a sheet owner or someone with permission to edit the protected area may need to adjust the protection.

The dropdown is still visible after you remove a rule. Select the cell and reopen the validation sidebar. Look for another rule that applies to it, including a rule that covers a larger range. Confirm that the displayed range includes the correct cell and remove or revise the remaining rule. Also check whether what you see is a filter arrow in a header or a dropdown control in a different interface element rather than cell validation.

Other dropdowns disappeared too. The removed rule probably applied to a larger range than you expected. Use Undo immediately if you want to restore the previous state. Then reopen the rule and edit its applied range so the unaffected cells remain included while the target cell is excluded. If Undo is no longer available, recreate the rule for the cells that still need it, using the same criteria and options as before.

The value in the cell is not accepted after the change. Check that the rule was actually removed and that no second validation rule applies. If you see a warning rather than a dropdown, it may be another validation condition. Removing the right condition should stop it from restricting future entries. Do not clear the cell unless you also intend to remove its current content.

You cannot find the rule because the dropdown is styled differently. A dropdown may appear as a colored chip, a small arrow, or plain text depending on its display setting. Click the cell itself and open Data > Data validation rather than relying on its appearance. If no rule is listed, inspect nearby cells and confirm that the control is not a filter, a feature in another sheet, or a dropdown displayed by a separate form or add-on.

Frequently Asked Questions

Will removing a dropdown erase the value already in the cell?
No. Removing the validation rule leaves the current cell content in place. Clear the cell separately only if you also want to delete that value.

Can I remove a dropdown from just one cell?
Yes, but first check the rule’s applied range. If it covers multiple cells, edit the range to exclude the one cell or split the rule into separate ranges. Simply removing a shared rule can affect other cells too.

Can I remove dropdowns from several cells at once?
Yes. Select the intended cells or range, open Data > Data validation, and remove the applicable rule. Check the rule’s range before confirming, especially if the selected cells are part of a larger area.

Does deleting a dropdown also delete the list of choices?
Not usually. Removing validation removes the rule from the cells; it does not delete a separate source list. If the choices were typed directly into the rule, they are no longer offered by that removed rule, so note them first if you may need them again.

Can I undo removing a dropdown?
Use Undo in Google Sheets soon after the change to restore the previous rule. If you have made other edits since then, inspect the range and recreate the rule with its earlier criteria and options instead of undoing unrelated work.

Does the same menu path work in the Google Sheets mobile app?
The instructions here are for a web browser. The mobile app’s menus and controls differ by device and app version, so use the app’s cell or validation options if available, or open the spreadsheet in a browser for the sidebar steps described above.

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.