Google Sheets Dropdown: Show Only Selected Values

Yes. In Google Sheets, a dropdown cell normally displays only the value you selected after the menu closes; the other options appear when you open the dropdown. If you mean showing only rows that match a selection, use a filter instead—the dropdown itself does not hide or filter other rows.

What “show only selected” means in Sheets

A dropdown is a way to choose an allowed value for a cell. For example, a Status cell might offer Not started, In progress, and Complete. Once you choose In progress, the cell displays that choice, not the full list. Click the cell’s arrow or dropdown chip to open the list again and view the available alternatives.

This distinction matters because there are two related but different tasks people often describe as showing only selected values:

Keep a cell compact: Use a dropdown. The closed cell shows the chosen value, and the menu shows the options when opened.
Show matching records only: Apply a filter to the rows in your table. This hides rows that do not meet the filter, while leaving the underlying data in the sheet.

A dropdown is not a privacy control. Anyone with access to the sheet who can open the cell can generally see its available choices, and filtering rows does not erase or secure the hidden data.

Create a dropdown in Google Sheets

In the Google Sheets web app, you can create a dropdown directly or through data validation. The exact labels in the side panel can shift as Google updates the interface, but the basic choices are to enter options yourself or take them from a range of cells.

Select the cell or range where people should make a choice.
Choose Insert > Dropdown, or choose Data > Data validation > Add rule.
In the rule panel, choose a dropdown criterion. Enter each option if you are making a list manually, or choose the option to use a range and specify the cells that contain the choices.
Review the rule’s behavior for invalid entries, then select Done.

For example, to make a status selector for rows 2 through 50, select the cells in the Status column for those rows before adding the rule. Each cell can then hold a status from the list. If you apply the rule to a whole column, consider whether the header cell should be excluded so it does not receive a dropdown by mistake.

When a dropdown is selected, the cell shows its current value. Clicking it opens the available choices; choosing a different option replaces the previous value in that cell. The dropdown does not automatically populate other cells or create a filtered report.

Change how the selected value looks

Sheets provides display styles for dropdowns, commonly including a colored chip, an arrow, and plain text. These change the appearance of the cell, not which options are available or whether the list is visible. A chip can make status values stand out; an arrow may look more like a conventional form control; plain text keeps the cell visually minimal.

To change the display style, select a cell governed by the rule and open its dropdown rule through Data > Data validation. Use the rule’s display-style setting, if shown, and save the change. The selection remains the same; only its presentation changes. Color assigned to an option can also help readers scan a table, but color should not be the only way to communicate meaning. Keep the text label clear, especially for people who may not distinguish the colors easily.

If you want the cell to display nothing until a choice is made, leave it blank and do not set an initial value. A blank cell does not mean that the dropdown has no options: click it to check. Likewise, removing the visible chip or arrow is not the same as removing the validation rule.

Filter a table to show only matching rows

If your goal is to see only the records with a chosen status, filter the table rather than changing the dropdown. First make sure the data has a header row, then click a cell in the table and choose Data > Create a filter. Filter icons appear in the header cells. Open the icon for the relevant column, use Filter by values, clear the values you do not want, leave the desired value selected, and apply the filter. The sheet then displays rows that match the filter.

For instance, a task table could have a Status column containing Not started, In progress, and Complete. Filtering that column to In progress hides the other status rows from the current view. It does not change those cells’ values, delete the rows, or alter the dropdown options. Clear the filter or select the other values to bring those records back into view.

When several people work in the same sheet, an ordinary filter can affect the view other editors see. If you want to filter without changing the shared view for everyone, use a filter view: open Data > Filter views > Create new filter view, then set the column filter inside that view. Filter views are useful for separate review tasks, such as one person viewing open work while another checks completed work. They are not a way to restrict access to rows.

Use a range when the options may change

Typing options directly into a rule is convenient for a short, stable list. A range-based dropdown is easier to maintain when the choices might be renamed or expanded. Put the approved options in a dedicated area, then set the dropdown to use that range. Updating the source list can update the choices offered by the rule, without editing every dropdown cell individually.

Keep the source list tidy: use one option per cell, avoid accidental blank entries, and make labels distinct enough that users can tell them apart. If the list includes nearly identical names, people may choose the wrong one even though validation is working correctly. For a list that should stay consistent across multiple columns or tabs, a single maintained source range is generally easier to audit than several separately typed lists.

A range-based list does not, by itself, make a dependent dropdown. For example, selecting a country in one cell will not automatically make a second dropdown show only that country’s cities unless you build additional logic and ranges for that setup. If you need that behavior, plan the source data and dependencies separately; a basic dropdown simply presents the options its rule points to.

Control invalid entries and avoid accidental changes

Data validation can help keep entries consistent. Depending on the rule’s settings, Sheets can reject a value that is not in the list or show a warning while allowing it. Rejection is useful when downstream reports depend on a fixed set of labels. A warning can be preferable when the list is a guide but unusual entries must still be possible.

Validation is not a substitute for permissions or a protected range. An editor may be able to alter the rule itself if they have sufficient editing access. If the choices or formulas must not be changed casually, use the sheet’s sharing and protected-range controls appropriately. Also remember that copying and pasting data can produce results that differ from choosing an item through the menu, so check the validation settings and the resulting cell values if pasted data appears inconsistent.

Common dropdown problems

The list does not appear: Select the cell and look for its arrow or chip. If there is no menu, check whether a validation rule is applied to that cell under Data > Data validation.
The cell shows the wrong option: The cell displays its current contents. Open the dropdown and choose the intended option, or inspect whether the cell was changed by a paste or another editor.
Options are missing: For a range-based rule, confirm that the selected source range includes the missing items and that the rule points to the correct cells.
A filter hides rows unexpectedly: Open the column’s filter menu and review the checked values. Clear the filter to display all rows again. Hidden-by-filter rows have not been deleted.
The menu shows old choices: Check whether the rule uses a manually entered list or a source range. Editing the wrong list elsewhere in the sheet will not update a manually entered rule.

It is also easy to confuse filtering with sorting. A filter hides rows that do not match your criteria; sorting rearranges visible rows. Neither operation changes the choices in a cell’s dropdown validation rule.

When a dropdown is not the right tool

Use a dropdown when each record should contain one of a manageable set of known values, such as a department, priority, or approval state. Use a filter when the purpose is to narrow a table to matching records. For a visual summary, a pivot table or chart may be more useful than hiding rows, while a filter view is a practical choice when different collaborators need different table views.

If users need to choose several values for one record, a standard single-choice dropdown may not fit the workflow. Consider separate columns, one choice per row in a related table, or another structured input method. Avoid putting several comma-separated selections in one cell if you later need to count, filter, or analyze each selection independently; separating the values makes those tasks more reliable.

Frequently Asked Questions

Does a Google Sheets dropdown show all options in the cell?
No. When the dropdown is closed, the cell shows its current value. Open the dropdown to see the available options.

Can I make a dropdown show only options that are selected?
A normal dropdown lists its allowed choices when opened; it does not maintain a separate list of previously selected options. If you mean showing only rows with chosen values, filter the table by the relevant column.

How do I show only rows with one dropdown value?
Choose Data > Create a filter, open the filter menu in the target column, and use Filter by values to leave the value you want selected.

Does hiding rows with a filter delete them?
No. A filter changes which rows are visible, not the underlying records. Clear the filter to show the rows again.

Can I hide the dropdown choices from other editors?
Not by using a dropdown or filter. Editors who can access the cell can generally view its choices. Use appropriate sharing permissions if the underlying information should not be accessible.

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.