Remove a Dropdown from a Google Sheets Table

To remove a dropdown in Google Sheets, select the affected cell or range, open Data > Data validation, and remove the rule in the sidebar. If the dropdown comes from a Google Sheets table column type instead, open that column’s menu, choose Edit column type, and change it to None. Removing either control normally leaves values already entered in the cells intact.

First identify which kind of dropdown you have

Google Sheets can show a dropdown for more than one reason. The most common is a data validation rule attached to one or more cells. It can offer a fixed list, such as Open, In progress, and Done, or take its choices from a range elsewhere in the spreadsheet. A dropdown may appear as a colored chip or as an arrow in a cell, depending on the rule’s display style.

Sheets tables also have column types. A table column assigned the Dropdown type can show choices for cells in that column. This is a table setting, not necessarily an ordinary validation rule, so removing a data validation rule may not remove the table’s dropdown. Identifying the source first helps avoid changing the wrong setting or removing a rule that other cells still need.

One quick clue is scope: if every cell in a table column behaves the same way, check the column type. If only selected cells show the menu, or the cells are outside a table, check data validation. When you are unsure, inspect both settings before editing.

Remove a data validation dropdown

Use these steps in Google Sheets in a web browser to remove a standard dropdown rule:

Select a cell that shows the dropdown. To remove it from several cells, select the full range first. You can also select a whole sheet column by clicking its letter, but do that only if you mean to remove rules everywhere in that column.
Choose Data > Data validation from the menu bar. The data validation rules for the selection appear in a sidebar.
Find the rule that supplies the dropdown and choose Remove rule. If the selection contains multiple rules, make sure you remove the intended one.
Check the affected cells. The dropdown control should disappear. Existing text, numbers, or selected choices generally remain as cell values.

If the sidebar does not show a rule for the selected cell, select a different cell that visibly has the dropdown and inspect that one. Rules can apply to separate ranges, and a cell that looks like part of the same group may not share the same rule. When a rule covers a large range, selecting one affected cell can reveal its range in the sidebar; use that information to decide whether to edit the whole rule or only a smaller set of cells.

Remove a dropdown from a table column

If the dropdown is supplied by a table column type, change the type rather than looking only for validation rules. Click the menu arrow in the table’s column header, choose Edit column type, and select None if that option is offered. The column remains in the table, but it no longer uses the Dropdown column type. The precise controls can depend on the table and the current Sheets interface; if the header menu does not offer a column type, check for a standard data validation rule instead.

Changing a column type is different from deleting the table column. It is also different from changing the table’s formatting. Table banding, header colors, and borders do not by themselves create a dropdown. If you want the table structure and its formatting to remain, edit only the column type or the relevant validation rule.

For a table column whose dropdown was created with a separate validation rule, remove that rule through Data > Data validation as described above. Some sheets may use both a table column type and a rule, so check whether the dropdown remains after the first change and inspect the other source if needed.

Choose the right range before removing the rule

A validation rule can apply to one cell, a block of cells, or a long range that includes future rows. Removing it from a single cell may not remove it from neighboring cells. Conversely, selecting an entire column can remove restrictions from cells that were meant to keep them, including cells outside the table’s visible data.

Before changing a shared rule, look at the range shown in the data validation sidebar. Consider the intended outcome:

One incorrect cell: Select only that cell and remove or adjust its rule if Sheets allows the rule to be separated from the rest of the range.
A whole table column: Check the table’s column type and the range used by any validation rule, including rows intended for later entries.
A few cells in a larger range: If you want the rule to remain elsewhere, select the cells that should keep it and make sure they still have the intended validation after editing.
The entire sheet column: Click the column letter only when removing the dropdown everywhere in that column is deliberate.

If preserving the original setup matters, make a copy of the spreadsheet or note the rule’s criteria and range before changing it. This is particularly useful in a shared tracker where dropdown choices may be part of a team’s workflow.

What happens to existing selections?

Removing a dropdown rule removes the restriction and the menu; it does not normally erase the cell’s current contents. For example, if a task cell contains In progress and you remove its dropdown, that text usually remains in the cell as ordinary text. You can continue to edit it, but Sheets no longer checks it against that removed list.

This distinction matters when a dropdown is being used to keep records consistent. Without validation, someone can type a different spelling, an unexpected status, or any other value. Existing values do not become automatically standardized just because the menu disappears. If the goal is to remove the control but retain the current data, remove the rule and leave the cell contents alone.

If you want to remove both the dropdown and the existing values, that is a separate action. Select the cells and use Edit > Delete values to clear their contents without treating rule removal itself as a data-clearing command. Check the selection carefully first: clearing values affects every selected cell, while removing a validation rule changes how entries are controlled.

Common problems and how to fix them

The dropdown remains after removing a rule. The cell may have a table Dropdown column type, another validation rule, or a different range’s rule. Check the table header menu and inspect the exact cell in the validation sidebar.
Only some cells lose the dropdown. The cells may be covered by different rules or ranges. Select a cell that still shows the menu and inspect its settings separately.
The dropdown disappears, but the old choice remains. That is expected: the selected option is stored as the cell value. Delete the value separately only if you intend to clear it.
You cannot find Data validation. Confirm you are editing the spreadsheet in Google Sheets, rather than viewing a read-only preview or another application. You also need permission to edit the sheet to change its rules.
A collaborator’s changes seem to undo yours. In a shared file, another editor may restore a rule or change the table column type. Check version history or coordinate with the other editors before making a broad change.

Also distinguish a dropdown from a filter control. A filter or table header menu helps sort or filter records; it is not a cell-entry dropdown. Removing data validation or changing a column type will not remove table filters. Avoid deleting the table or its column just to make a cell’s choice menu disappear.

Remove, edit, or replace the dropdown?

Deleting a dropdown is not the only option. If the choices are mostly useful but need correction, edit the existing rule or table column type instead. For example, a project tracker might still need a Status dropdown, but its list could be updated to include Waiting for review. Updating the options preserves a consistent workflow without leaving old or invalid choices in place.

Consider the purpose of the rule before removing it. A personal planning sheet may work perfectly well with free typing. In a shared inventory, registration, or task sheet, a controlled list can prevent inconsistent entries that make filtering and summaries harder. If only a few entries are wrong, correcting the rule or its source list is often safer than removing validation from the entire column.

When you do remove it, tell other editors if they rely on the dropdown. They may otherwise assume a missing menu is a temporary problem or enter values that no longer match the team’s conventions. A short note in the sheet or a message to collaborators can prevent confusion.

Google Sheets and Excel are different

These directions are for Google Sheets in a web browser. Excel uses its own data validation controls and table features, so its menu paths and behavior are not interchangeable with the Google Sheets steps above. If you are editing an Excel workbook opened in another program, follow that program’s instructions rather than expecting Google Sheets’ Data validation sidebar or table column menu to appear.

Likewise, a Sheets table and a formatted range are not identical. A range can be formatted to look like a table without using the Sheets table feature. In that case, a dropdown is more likely to come from data validation, and changing table column types will not apply. The visual appearance alone is not enough to determine which setting controls the menu.

Frequently Asked Questions

How do I remove a dropdown in Google Sheets but keep its value?

Select the cell or range, open Data > Data validation, and remove the applicable rule. The existing choice normally stays as the cell’s text or value. Do not use a command to clear cell contents if you want to keep that information.

Why does the dropdown still appear after I remove data validation?

It may be a table column type rather than a validation rule, or the selected cell may have a separate rule. Check the table column header menu for Edit column type, and inspect a cell that still shows the menu in the Data validation sidebar.

Can I remove a dropdown from just one cell?

Yes, if the rule can be removed or adjusted for that cell without affecting the rest of its range. Select only that cell and inspect the rule’s applied range. If several cells share one rule, take care to preserve the rule for the cells that still need it.

Will removing a dropdown delete the choices already entered?

No, removing the rule or changing the column type normally removes the menu, not the existing cell contents. To delete a choice already stored in a cell, clear that value separately after selecting the appropriate cells.

How do I remove a dropdown from an entire table column?

For a table Dropdown column type, open the column header menu, choose Edit column type, and select None when available. If the column instead uses validation, remove the rule for the intended range through Data > Data validation and confirm the range before applying the change.

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.