Google Sheets Filter Views: Create, Use, and Share Them

A Google Sheets filter view is a saved way to sort or filter a table without changing the view other collaborators are using. In a computer browser, open the sheet and choose Data > Create a filter view; set conditions or sort columns, then close the filter-view bar to leave the view.

What a filter view does

A filter view displays selected rows from a range, in an order you choose, while leaving the underlying rows and cell values in the spreadsheet. For example, a project tracker might contain every task, owner, due date, and status. You can make a view that shows only overdue tasks, or one that sorts the full list by owner, without making a separate copy of the tracker.

Filter views are especially useful in shared sheets. Each person can use a different saved view, so one collaborator can examine tasks assigned to Sam while another looks at open tasks. The view changes what is displayed for the person using it; it does not delete rows or rewrite the data. A view is saved with the spreadsheet, so it can be reopened rather than rebuilt each time.

A filter view is not the same as hiding rows manually. It records a reusable set of filtering and sorting choices for a data range. It is also not a privacy feature: hiding a row in a view does not prevent someone with spreadsheet access from seeing that row in the source data or in another view.

Create a filter view

For the clearest results, start with a rectangular table: one header row, one record per row, and a consistent type of information in each column. Then create a view in Google Sheets in a web browser:

Open the spreadsheet and click a cell inside the table. Check that the table has clear column headings and does not include unrelated data immediately beside it.
Choose Data > Create a filter view. Sheets opens a filter-view interface over the selected data range. Check the range shown in the dark toolbar; adjust it if the table includes extra columns or leaves out records.
Click the filter icon in a column heading. Use the available values or conditions to specify which rows to display. For instance, in a Status column, select Open to hide rows with other statuses.
Use the column menu to sort if needed, such as sorting a due-date column from earliest to latest. Give the view a useful name in the toolbar, such as Open tasks by due date.
Close the filter view using the X at the right of its toolbar. The view is saved with the sheet and can be selected again from Data > Filter views.

Names that describe both the selection and the purpose are easier to recognize than labels such as View 1. Examples include Invoices awaiting approval, West region sales, or Tasks due this week. If the view does not show the expected records, check its range and criteria before saving it as a standard workflow.

Filter rows and sort within a view

Each column’s filter menu offers choices based on the data type. You can select particular values, such as a department or status, or set a condition, such as text that contains a word or a number greater than a threshold. Date columns offer date-related conditions. The exact options depend on the selected column and the content Sheets recognizes in it.

For example, suppose a sales table has columns for Region, Rep, Month, and Revenue. A filter view could select North in Region and set Revenue to be greater than a chosen amount. You could then sort by Revenue to bring higher values to the top. The view is useful for reviewing the matching records, but it does not create a new report or a separate copy of those records.

Sorting and filtering can be combined. A filter decides which rows are visible; a sort decides the order in which the visible records appear. To return to a broader view, reopen the filter menu and clear the criteria or choose another saved view. Be careful to distinguish clearing a filter from deleting data: clearing criteria restores hidden rows to the display.

Filtered-out records remain in the spreadsheet. This matters when totals are involved: a regular SUM over a range can still include values in rows hidden by a filter. If you need a total that responds to filtered rows, choose a suitable subtotaling approach and verify its behavior with your sheet’s data rather than assuming that a hidden row is excluded from every calculation.

Using filter views with collaborators

A standard filter and a filter view behave differently in a shared spreadsheet. Applying a standard filter can change the displayed rows for other people working in that sheet. A filter view is designed to let people examine a data range using their own saved sort and filter settings, without forcing everyone else to adopt that same display.

Filter views are useful when several people need different slices of the same data at once. A coordinator could inspect unassigned work while a team member checks completed items. Both can use the same source table instead of maintaining competing copies, which also reduces the risk of one copy falling out of date.

You can share a link to a particular view by opening it and copying the browser address. A link does not grant spreadsheet access: recipients still need permission to open the file. Their ability to create or change saved views depends on their access to the spreadsheet and the controls available to them. If a recipient cannot edit a view, check the file’s sharing permissions rather than assuming the link itself changes access.

Open, rename, and manage saved views

To use a saved view again, choose it from Data > Filter views. Sheets displays the saved criteria and sort order for that view. This is more reliable than applying a collection of filters from memory, particularly when a sheet has many columns or the criteria are not obvious from the view’s name.

When you are in a view, use its toolbar to update the name or range where those controls are available, and use the column menus to change the filters or sort. Close the view when finished. If a view is no longer useful, open the saved view and use the toolbar’s options to delete it; deleting the view removes the saved setup, not the spreadsheet’s rows or values. Review the confirmation and make sure you are deleting the view rather than clearing its conditions.

It can help to agree on a simple naming convention for a team sheet. Put the purpose first, then a distinguishing detail: for example, Review queue — West or Open orders — oldest first. Avoid names that imply access restrictions, because a filter view only changes what is displayed and does not conceal information from authorized spreadsheet users.

Common problems and how to fix them

The view includes extra blank rows or misses records: Check the range shown in the filter-view toolbar. A blank row inside the table, or unrelated content adjacent to it, can make it harder to identify the intended data range. Set the range to cover the header and all relevant records.
A value seems missing from the filter menu: Confirm that the value is actually in the selected range and that it is written consistently. For example, Open, open, and Open with a trailing space may be treated as distinct text. Also check for a filter condition that already excludes the row.
Filtering a column gives unexpected results: Check whether the column mixes types, such as dates stored as text alongside real date values, or numbers alongside text. Standardize the source data where practical, then reopen the filter menu and review the available conditions.
A collaborator says the rows changed for everyone: Confirm that you created a filter view rather than applying a standard filter with Data > Create a filter. A standard filter is a shared sheet display; filter views are the better choice for individual analysis in a busy shared file.
The total did not change after filtering: Filtering hides rows from view, but it does not remove their values. A formula that totals the full range may still count hidden records. Check the calculation method and whether it is intended to respond to filtered rows.
The view is difficult to use on a phone: Creating and managing views is generally easier in the desktop browser interface, where the filter-view toolbar and column menus are available. If the controls are missing in a mobile app, open the file in a computer browser or consult the app’s current capabilities.

Filter views compared with other options

Choose a filter view when you want a reusable, interactive way to inspect part of a shared table without imposing your display choices on other collaborators. Choose a standard filter when the sheet should have one shared filtered display and that behavior is appropriate for everyone using it. For a sheet used by a team, explain which approach is in place so collaborators are not surprised by changing rows.

Google Sheets also has the FILTER function, which returns matching data into a formula result area. That is different from a filter view: the function can create a separate, formula-driven output that updates as source data changes, while a filter view changes the displayed rows in the selected source range. Use a formula-based result when you need a distinct output area for a report or downstream calculations; use a filter view for interactive review of the original table.

Neither approach is a substitute for access control. If certain people must not see sensitive rows or columns, do not rely on filters, hidden rows, or a saved view. Use appropriate file permissions and a separate, properly restricted data source where necessary. A filter view is a convenience for organizing work, not a security boundary.

Good practices for reliable views

Well-structured source data makes filter views much more predictable. Keep one header row, avoid merged cells in the table, and use one record per row. Do not place explanatory notes or totals inside the middle of the data range; put summaries above or below it, or on a separate sheet. Consistent date, number, and text formats make condition menus easier to interpret.

Before relying on a view for a recurring review, test it against a few records you know should match and a few that should not. Give it a clear name, confirm the range includes new rows when relevant, and tell collaborators whether they should use the view or the standard sheet display. For important reporting, verify counts and totals against the source rather than treating a filtered display as proof that excluded data no longer exists.

Frequently Asked Questions

How do I create a filter view in Google Sheets?
In a computer browser, open the sheet and choose Data > Create a filter view. Check the range, set conditions or sorting from the column menus, name the view, and close its toolbar when finished.

Does a filter view change the spreadsheet for everyone?
It is intended to let a user apply a saved view without imposing the same filtered display on other collaborators. A standard filter is different and can affect the shared display, so select the command that matches how the sheet is being used.

Do filter views delete or hide data permanently?
No. A view temporarily hides nonmatching rows from its display; the rows and values remain in the spreadsheet. A filter view is not a way to protect or conceal data from people who have access to the file.

Can I share a Google Sheets filter view?
You can open the view and copy the browser address to direct someone to it. The recipient still needs permission to access the spreadsheet, and the link does not grant new permissions.

What is the difference between a filter view and the FILTER function?
A filter view interactively changes which source rows are displayed. The FILTER function returns matching data as a formula result in another area. Use the first for reviewing a table and the second when you need a separate, updating output.

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.