Google Sheets Dropdown: How to Remove It

To get rid of a dropdown in Google Sheets, select a cell that has it, open Data > Data validation, select the applicable rule in the sidebar, and click Remove rule. This removes the dropdown rule but normally leaves the cell’s current value in place. To remove dropdowns from several cells, select their range first and remove the relevant rule.

What You’ll Need

A Google account with permission to edit the spreadsheet. If you can only view or comment, ask the owner or an editor to remove the dropdown.
A web browser with the spreadsheet open in Google Sheets. These instructions describe the browser interface; menus and controls in the Sheets mobile app may differ.
The cell or range containing the dropdown. If you are not sure which cells have one, inspect the relevant column or sheet before changing rules.

Step-by-Step

Open the spreadsheet and find the dropdown. Click the tab for the sheet where the dropdown appears, then click one of the affected cells. A dropdown may display as a colored chip, a small arrow, or plain text, depending on its display style. If you can see a small arrow when the cell is selected, click it only if you need to inspect its choices; choosing an option changes the cell value, not the rule.
Decide whether to remove one dropdown or a group. For one cell, leave that cell selected. For a continuous block, drag across the cells or click the first cell, hold Shift, and click the last cell. To select a whole column, click its letter at the top; to select a whole row, click its number. Select only the area you intend to change, because removing a rule from a broad selection can affect cells that should keep their dropdowns.
Open the validation controls. From the menu bar, choose Data > Data validation. Google Sheets opens a sidebar showing validation rules that apply to the selected cells. The sidebar may list more than one rule if your selection contains different dropdowns or other validation settings. Check the rule’s range and criteria before removing it; a dropdown based on a list of values and one based on a range are both validation rules.
Select the specific rule you want to remove. If the sidebar shows a rule card, click it to view its settings and the range it affects. Compare the displayed range with the cells you selected. If you see several rules, do not assume they all belong to the dropdown you want gone. Identify the matching rule by its range and its dropdown criteria, then leave unrelated rules alone.
Click Remove rule. Use the Remove rule button for the selected rule in the sidebar. The dropdown should disappear from the cells governed by that rule. In most cases, any value already entered in those cells remains, so a cell that currently contains a selected item will still show that text after its dropdown is removed. Removing the rule is different from deleting the cell’s contents.
Check the affected cells. Click a cell where the dropdown appeared. Its arrow or chip-style menu should no longer be available. If you removed a rule from a range, spot-check a few cells near the beginning, middle, and end of that range. Also check nearby cells that were not meant to change. This confirms that the rule was removed from the intended area and not from a larger section by mistake.
Repeat for other rules if necessary. A sheet can have separate validation rules for different ranges. If dropdowns remain in other cells, select one of those cells, open Data > Data validation again, and remove its matching rule. For a larger group with several different rules, handle each rule separately and verify its range before clicking Remove rule.
Undo promptly if the wrong rule was removed. If you removed the wrong rule, use Edit > Undo or press Ctrl+Z on Windows or ChromeOS. On a Mac, press Command+Z. Undo soon after the change, before making other edits that may make it harder to return the sheet to the prior state. Then select the correct cells and remove only the intended rule.

Removing the validation rule does not necessarily erase existing entries or automatically clean up data elsewhere. For example, if cells contained values selected from a dropdown, those values remain ordinary cell contents after the rule is gone. If your goal is to leave the cells empty as well, clear their contents as a separate action after confirming that you do not need the existing data.

Common Mistakes

Pressing Delete and expecting the dropdown to go away. Delete or Backspace clears a cell’s content, but it does not reliably remove the validation rule. The dropdown may still appear when you select the now-empty cell. Use Data > Data validation and remove the rule instead.
Clearing the cell value instead of removing validation. If a cell shows an unwanted choice, deleting its text only removes that entry. The dropdown remains available because its rule is still attached. Remove the rule when you no longer want users to choose from a list.
Removing every rule in a mixed selection. A selected range may contain dropdowns for different purposes, or other data validation rules such as number or date limits. Inspect the sidebar’s ranges and remove only the matching rule. If unsure, work on one smaller range at a time.
Using Clear formatting. The formatting controls affect how cells look; they are not the right place to remove data validation. Changing a chip’s color, clearing a background, or changing text formatting does not remove the dropdown rule.
Confusing a dropdown with a different feature. A dropdown created by data validation is removed through the validation sidebar. A filter menu, a table control, or a smart chip may look interactive but is not necessarily a validation dropdown. If no applicable rule appears in the sidebar, check what kind of control you are seeing before changing the sheet.

Tips

Make a copy before a broad cleanup. If you plan to remove dropdowns from a whole column, many tabs, or a shared template, use File > Make a copy first. A copy gives you a fallback if the selection or rule range is not what you expected.
Use the rule range as your guide. The rule’s range tells you which cells it governs, while the selected cell helps you locate it. If a rule applies to an entire column but you only intended to change one cell, pause: removing that rule may affect every cell in its range.
Preserve existing values when that matters. Removing validation usually keeps the current contents. If those entries need to remain, do not select the cells and clear their contents afterward. Conversely, if you want both the dropdown and its existing selections gone, remove the rule first, then clear only the intended cell contents.
Use a narrow selection for a precise change. Removing a rule from one cell or a clearly defined range is safer than selecting the entire sheet. Expand the selection only after confirming that the same rule applies to every additional cell.
Coordinate edits in shared files. If collaborators are actively editing, tell them which range you are changing. A teammate may add the rule again or enter values while you work. Check the sheet after the change and confirm the dropdown does not reappear.

Troubleshooting

The dropdown is still visible after removing a rule. Check whether the cell is covered by another validation rule or whether the dropdown you see belongs to a different range. Select the cell itself, open Data > Data validation, and review every rule shown for it. Remove only the rule that applies to the unwanted dropdown. Then click away and select the cell again to check the result.
You cannot click Remove rule or edit the rule. You may not have editing access, or the relevant cells may be protected. Check whether the file is in view-only mode. If you have edit access but the range is protected, ask the spreadsheet owner to adjust the protection or remove the rule. Do not try to work around protection by deleting other content.
The rule disappears, but the old choice remains in the cell. That is expected: removing validation generally removes the menu, not the cell value. If the remaining text should also be deleted, select the cell and clear its contents after confirming that the value is not needed. Avoid deleting the whole row or column just to remove one entry.
The dropdown comes back later. Another editor may have recreated the rule, or you may be looking at a different cell within a larger validated range. Reopen the sidebar and inspect the rule range. If the file is shared, ask collaborators whether they are maintaining a standard dropdown on that range.
You cannot find the rule in the sidebar. Make sure you selected the cell that actually displays the control, not a nearby cell, and confirm you are in the correct sheet tab. If the control is a filter, table feature, or smart chip rather than a data-validation dropdown, the validation sidebar will not offer the control you need. Identify the feature first, then use the relevant Sheets control to remove or change it.

Frequently Asked Questions

Will removing a dropdown delete the value already in the cell?
Usually, no. Removing the data validation rule removes the menu but leaves the current cell content. Clear the content separately only if you also want the cell to be blank.

Can I remove a dropdown from just one cell?
Yes. Select that cell, go to Data > Data validation, select the rule that applies to it, and click Remove rule. Check the rule’s range first, especially if it covers more than one cell.

How do I remove dropdowns from a whole column?
Click the column letter to select the column, then open Data > Data validation and remove the applicable rule. Confirm the rule’s range before removing it, since a single rule may also cover cells outside the column.

Can I hide the arrow but keep the dropdown rule?
Removing the rule is the straightforward way to stop the dropdown from being available. If you only want a different appearance, open the rule’s settings and review the available display styles; changing how a dropdown looks is not the same as removing its validation.

Does clearing formatting remove a dropdown?
No. Formatting changes appearance, while a dropdown is controlled by data validation. Use Data > Data validation to remove its rule.

Is the process the same in Excel?
No. These steps are for Google Sheets in a web browser. Excel has its own data-validation controls and menu paths, so follow instructions specific to Excel rather than looking for Google Sheets’ validation sidebar.

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.