Create a Filter in Google Sheets: Steps and Tips

To create a filter in Google Sheets in a web browser, select the cells you want to filter, including the header row, then choose Data > Create a filter. Google Sheets adds a filter button to each column heading; click one to sort the data or show only rows that match your choices. Filtering hides rows from view rather than deleting them.

What a Google Sheets filter does

A filter lets you focus on selected records in a range without removing the other records. For example, a sales sheet might have columns for Date, Region, Product, and Revenue. A filter can display only rows for the West region, show dates within a chosen period, or leave visible only sales above a specified amount. The rest of the data remains in the sheet and can be shown again by clearing the filter.

When a filter is active, each heading in the filtered range gets a small filter control. Its menu includes sorting options and ways to choose which values or conditions to display. You can filter more than one column at a time. A row remains visible only if it meets the active filters across the columns, which makes it possible to narrow a large list step by step.

Filters are most useful when the data is arranged as a simple table: one header row, one record per row, and one kind of information per column. They are not a separate copy of the data or a permanent report. If you need a distinct, automatically populated result elsewhere, a filter view or the FILTER function may be a better fit.

Prepare the range before creating a filter

Before adding a filter, check the shape of the data. The top row of the selected range should contain clear column names such as Customer, Status, or Order date. Avoid putting a title, notes, or a blank row above the headers inside the selected range, because Sheets treats the first row of the range as its heading row. Remove completely blank rows or columns inside the data when practical; they can make it look as if the list ends earlier than it does.

Also check that each column contains consistent data. If some dates are stored as text and others as dates, date-based conditions may not treat them alike. Similarly, extra spaces or inconsistent spelling can make apparently identical categories appear as separate values. For instance, “North” and “North ” may be treated as different entries if one contains a trailing space.

Keep one record on each row and one field in each column.
Use a distinct heading for each column and avoid blank headings.
Include all relevant columns in the range, especially columns that should move together when you sort.
Do not select unrelated notes or a second table beside the data.

If you select only one column in a wider table, Sheets may offer to expand the range. Include the whole table so sorting one field does not separate its values from the other details in the same records.

How to create and remove a filter

Open the spreadsheet in Google Sheets in your browser.
Select the data range, including the header row. If the data is a continuous block, you can click a cell inside it and let Sheets identify the range, but verify the range before proceeding.
Choose Data > Create a filter. You can also use the filter-shaped button on the toolbar when it is available.
Look for a filter button beside each column heading. Click the button in the column you want to use.
Choose a sort option, select or clear values, or choose a condition. The visible rows update to match the active settings.

To remove the filter controls and return to the normal sheet view, choose Data > Remove filter. Removing the filter does not erase rows or their contents. If you only want to show all values temporarily while keeping the filter available, open a column’s filter menu and use its clear-selection or select-all options, depending on the choices shown.

When you add rows directly below a filtered range, Sheets often extends the range as the data grows, but do not assume that it always included a distant or separately pasted block. If new records do not respond to the filter, check the range through the filter controls and adjust it to include the added rows and columns.

Filter by values, conditions, and sort order

Google Sheets offers two common ways to decide which rows appear. Filter by values is useful for categories with a manageable set of entries. In the filter menu, clear the values you do not want displayed and leave selected the ones you want. A search box in the menu can help locate a value in a long list. For example, in a Status column, selecting only “Open” can hide completed and pending records from view.

Filter by condition is better when you want a rule rather than a hand-picked list. Available conditions depend on the type of column. Text can be filtered by rules such as containing or beginning with a phrase; numbers can be filtered using comparisons such as greater than or equal to; dates can be narrowed using date-related conditions. A condition can be useful when the list changes, since newly added values that meet the rule can appear without manually selecting each one.

Sorting is available in the same column menus. Sorting A to Z or smallest to largest rearranges the displayed records within the range; it does not simply hide unmatched rows. Make sure the filter range includes every field belonging to each record before sorting. If only the names column is sorted while related phone numbers or order details are outside the range, the rows can become mismatched. Filtering and sorting are different actions, even though both are accessed from the column control.

Use filters across multiple columns

You can set filters on several columns to answer a more specific question. Suppose a sheet lists customer orders with Region, Product, and Status columns. Choosing “East” in Region and “Open” in Status shows orders that meet both selections. In practical terms, filters on different columns narrow the results together: a row has to pass each active column’s filter to remain visible.

Within one column, selecting several values generally means that any selected value in that column can appear. For example, selecting “East” and “West” in Region keeps rows from either region. Combining that choice with “Open” in Status then limits the visible rows to open orders in East or West. This distinction helps explain why selecting multiple values in a single menu can broaden that column’s matches, while adding a filter on another column narrows the overall set.

For a concrete example, imagine 500 rows of event registrations with columns for City, Event, and Payment. Select “Portland” and “Salem” in City, then select “Paid” in Payment. The sheet shows paid registrations for either city. The original 500 records are still present; the filter changes which rows are currently displayed, not the underlying records.

Choose a filter view when collaborating

A standard filter changes the sheet’s shared filtered view, so it can affect what collaborators see while they are working in the same spreadsheet. That can be inconvenient if one person needs to inspect only overdue tasks while another needs the full list or a different subset. For independent filtering, use a filter view.

In the browser, choose Data > Filter views > Create new filter view. Sheets opens a filter-view mode where you can set conditions and sorting without replacing another person’s view of the data. You can name the view so it is easier to recognize later, and people with access to the spreadsheet can open a saved view when they need that particular arrangement. Filter views are useful for shared trackers, review queues, and reports where different collaborators regularly need different slices of the same records.

A filter view is still a view of the spreadsheet’s data, not a new data set. Edits made to cell contents affect the underlying sheet. Use the view to change what is displayed, not as a private copy for making independent changes. If you need to share a fixed snapshot, consider copying the relevant results to a separate sheet or exporting a copy, while taking care to preserve the appropriate permissions and context.

Common filter problems and how to fix them

The filter buttons do not appear on every heading. The selected range may not include the full table. Remove or adjust the filter and select the complete block, including all column headings.
A value seems to be missing from the menu. Check for spelling differences, leading or trailing spaces, and values outside the filter range. Also check whether another column’s filter is already hiding the row that contains it.
A date condition gives unexpected results. Confirm that the cells are recognized as dates rather than text. Date display formats can differ from the stored value, and entries pasted from another source may not have been interpreted consistently.
Rows disappear after a filter is applied. This usually means they do not match the selected values or condition, or they are excluded by a filter on another column. Review each active filter menu and clear conditions to test the result.
Sorting mixes up information. Check whether the filter range covered the entire table. Undo the sort if it was just performed, then sort with the full record range included. Sorting a partial range can separate related values.

One common misconception is that a filter deletes data. It does not: filtered-out rows are hidden from the current view, and removing the filter makes them visible again. Still, filtering is not a substitute for a backup or careful editing. A user can edit or delete cells while a filter is active, so verify the row and column before changing data in a shared sheet.

Filters compared with other ways to show data

Use a standard filter when you want to temporarily inspect or sort the original table and are comfortable with its shared view changing. Use a filter view when multiple people need different saved views of the same data. If you want a separate result area that updates from criteria, Google Sheets also has the FILTER function, which returns matching rows into another area. That formula-based approach is different from the menu filter: it creates displayed results elsewhere and can require room for the results to expand.

Pivot tables are more appropriate when the goal is to summarize or group information, such as calculating total revenue by region, rather than simply hide rows that do not match. For presentation, a chart or pivot table can make trends easier to understand, but it does not replace a filter when the task is to inspect individual records.

In Microsoft Excel, the broad idea is similar, but menu names and collaboration behavior differ. Excel commonly uses Data > Filter for a standard filter, while Google Sheets uses Data > Create a filter. If instructions are written for one program, do not assume the exact menu path or filter-view controls will be identical in the other.

Frequently Asked Questions

How do I create a filter in Google Sheets?
Select the data, including its header row, and choose Data > Create a filter. Click a filter button in a heading to choose values, set a condition, or sort.

Does filtering delete rows in Google Sheets?
No. A filter hides rows that do not match the current settings. Remove the filter or change its selections to show those rows again. The data remains in the spreadsheet unless someone edits or deletes it separately.

Can I filter more than one column at a time?
Yes. Apply a filter to each relevant column. The combined view displays rows that satisfy the active filters across those columns, which is useful for questions such as showing open orders in a particular region.

How can I filter a Google Sheet without changing what others see?
Use a filter view: choose Data > Filter views > Create new filter view. It lets you set up a separate view rather than changing the standard shared filter state.

Why can’t I see all my rows after creating a filter?
One or more filter settings may be excluding them. Check the value selections and conditions in every filtered column, and verify that the filter range includes all of the data. Clear the settings to restore the full view.

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.