Create a Filter View in Google Sheets for Yourself

To create a filter that changes your view without changing what collaborators see, open the spreadsheet in a desktop browser and choose Data > Create a filter view. Set your filter conditions, give the view a name, and close it when you are done; the important catch is that a saved filter view is stored in the shared spreadsheet, so it is separate from collaborators’ current views but is not private from them.

What a Google Sheets filter view does

A filter view lets you narrow or sort a shared table for a particular task while leaving other collaborators free to work with the same data in their own view. For example, you can show only open requests assigned to you, while a colleague looks at overdue requests. The rows are filtered on screen, not deleted from the sheet.

Filter views are useful when different people need different slices of one source of truth. A project team can keep one complete task list and make named views for each owner, status, or meeting, rather than copying the data into several tabs. Sorting within a view can also make a temporary working order without requiring everyone to adopt that order.

A filter view is not a duplicate spreadsheet or a personal copy. It stores filter and sort settings associated with the spreadsheet. That makes it convenient to reopen, but it also means people who have access to the file may be able to find and use the saved view.

How to create a filter view

Use Google Sheets in a web browser for the full filter-view controls. Before starting, check that your table has a clear header row and that the data forms a continuous range. If the sheet contains several separate tables, select the intended range first so the view does not include unrelated cells.

Open the spreadsheet and click a cell in the table, or select the exact table range, including its headers.
Choose Data > Create a filter view. Depending on the menu layout, filter views may also appear under Data > Filter views.
Check the outlined range shown in the filter-view toolbar. Adjust it if it does not cover the intended table and header row.
Use the dropdown icon in a column header to choose filter conditions, values, or a sort order.
Enter a clear name in the filter-view name field, such as My open requests.
Close the view with the X at the right of the filter-view toolbar. Reopen it later from the filter-views menu.

Google Sheets saves changes to a filter view as you make them; you do not need to create a separate copy of the spreadsheet. If the menu command is unavailable, check whether you have permission to edit the file and whether you are using the browser version rather than a limited mobile interface.

Choose conditions, values, and sorting

Each column’s dropdown gives you options suited to its contents. For a status column, filtering by values lets you keep only entries such as Open or In progress. For a date column, a condition can show dates before or after a chosen date. Text columns can be filtered by rules such as containing a word. The available choices vary with the data and the control presented for that column.

For example, imagine a service tracker with columns for Request, Owner, Status, Priority, and Due date. You could set the Owner filter to Maya and the Status filter to Open, then sort the Due date column from earliest to latest. The resulting view focuses on Maya’s unfinished work, while the underlying tracker still contains every request.

Filter by values: select or clear particular entries, such as one department or several statuses.
Filter by condition: use a rule such as text contains, is empty, or a date comparison when the option is available for that column.
Sort: order the displayed records alphabetically, numerically, or by date to make a review easier.

Combining conditions across columns narrows the results further: choosing a particular owner and a particular status shows rows that meet both selections. If a row seems to have disappeared, it is usually hidden by an active condition rather than removed. Clear or revise the relevant column filter to bring it back into view.

Filter view versus a regular filter

A regular filter is appropriate when the spreadsheet has one shared filtering state. Turning on a standard filter and changing its criteria can affect what collaborators see in that sheet. A filter view is the better choice when people need to inspect the same range differently at the same time.

In practical terms, use a regular filter for a sheet that one person manages or when the group wants the same filtered result. Use a filter view for shared work where one person wants to focus on a subset without imposing that subset on others. A view also has a name, making it easier to return to a recurring selection than to rebuild the conditions every time.

Neither option controls who can see the underlying information. A filter hides rows from the current display; it does not erase them, encrypt them, or stop someone with sufficient access from clearing the filter. If certain people must not see particular data, use appropriate file and sharing permissions or keep that data in a separately restricted file.

What collaborators can see and change

The word “only” needs a little care. Your active filter view does not force every collaborator’s screen to show the same filtered result. Other people can continue viewing the sheet normally or use a different filter view. However, a named view belongs to the shared spreadsheet, not solely to your Google account. Collaborators with access may be able to see it in the filter-view list and apply it.

This distinction matters for naming and privacy. A name such as Open requests - Maya can help the team understand the view, but it does not make the view confidential. Also, avoid treating a filtered result as a safe way to share only selected records: the remaining rows are still in the spreadsheet.

Access rights still apply. People who can edit a spreadsheet generally have broader ability to change its contents and saved settings than people who can only view it. If someone cannot create or modify a saved view, confirm their access level with the file owner. Do not assume a view’s presence grants permission to edit the data itself.

Useful examples for personal workflows

Saved views are most helpful for repeatable tasks. A sales coordinator might make a view for leads assigned to them and not yet contacted. A teacher could filter an assignment table to one class section before checking missing work. In a household inventory, someone might show only items marked for replacement. These examples all keep the same table as the source rather than creating potentially stale copies.

For a weekly review, make the filter conditions describe the recurring question, give the view a recognizable name, and sort by the date that matters. If the data changes, the view continues to apply its conditions to the current range; it is not a frozen report of the rows that matched on the day it was created. That is useful for ongoing work, but it also means the results can change when records are updated or new matching rows are added within the range.

When a spreadsheet grows, verify that the view’s range includes new rows. If the range was set to a fixed block, data added below it may not appear in the filtered results. Expanding the range or setting it to cover the intended table prevents the view from seeming incomplete.

Common problems and how to fix them

The filter-view command is missing: make sure you are in Google Sheets in a browser, have the necessary access, and are not confusing the regular Create a filter command with the filter-view command.
Rows you expect are absent: inspect filters in every relevant column, including filters that select values. Clear a condition to test whether it is excluding the rows.
The view includes the wrong cells: check the range shown in the toolbar. Select the correct table before creating a view or edit the range while the view is open.
Headers behave like data: confirm the first row of the filter range contains the column names. Blank or repeated headers can make a table harder to use and identify.
A collaborator can see your saved view: that is expected for a view saved in a shared file. Rename it if needed, or avoid saving identifying details in the name; do not use a filter view for confidential information.

For the cleanest results, keep one header row, avoid blank rows splitting the table, and use consistent values in each column. For instance, entries such as “In progress,” “In Progress,” and “working” may look like the same status to a person but are separate values to a filter. Standardizing entries makes filters more predictable.

Google Sheets on mobile and the Excel difference

Filter views are easiest to create and manage in Google Sheets on a desktop browser, where the full menu and filter-view toolbar are available. The mobile apps may provide basic ways to view or filter data, but controls can differ and are not a reliable substitute for the browser workflow when setting up a named view. If you cannot find the command on a phone or tablet, open the sheet in a desktop browser.

Excel has its own filtering tools and, in supported Microsoft 365 workbooks, a related feature called Sheet View. It is not the same Google Sheets menu or saved object. In Excel, the commands and availability depend on the version and where the workbook is stored; Sheet Views are intended for collaborative workbooks stored in OneDrive or SharePoint. Do not follow Google’s Data menu path in Excel.

Frequently Asked Questions

Can I create a filter view that only I can see?
A filter view can keep your current filtering separate from collaborators’ current views, but a saved view is part of the shared spreadsheet and may be visible to other people with access. It is not a private or security-protected filter.

Will creating a filter view change or delete rows?
No. Filtering changes which rows are displayed in that view; it does not delete the other records. Clear the filters or close the view to see the full table again.

Can two people use different filter views at the same time?
Yes. That is a key reason to use filter views in a shared sheet: collaborators can work with different views instead of changing one shared filter state for everyone.

How do I find a filter view I saved?
Open the spreadsheet and use the filter-views options under the Data menu to choose the named view. If it is not listed, check that you are in the correct spreadsheet and that the view was saved there.

Can a filter view hide sensitive rows from collaborators?
No. It only changes what is displayed, not who can access the data. Use file permissions or a separately restricted spreadsheet when access to the underlying rows must be limited.

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.