Filter Google Sheets Without Affecting Others

To filter a shared Google Sheet without changing what collaborators see, use a filter view: in a browser, open Data > Filter views > Create new filter view, then set your filters or sort order. A standard filter is shared sheet state, so it can change the view for everyone; a filter view lets each person work with a separate display of the same data.

The quickest way to filter privately

Open the spreadsheet in Google Sheets on a computer browser and select a cell in the table you want to examine. Choose Data > Filter views > Create new filter view. Sheets opens a filter-view interface with controls on the column headers. Use those controls to select values, set conditions, or sort. The filtering and sorting in that view do not hide or reorder rows in the ordinary sheet view seen by other collaborators.

Give the view a useful name in the name field at the top of the sheet, such as “Open orders” or “My region.” Filter views are saved, so you can close one and return to it later using Data > Filter views. If you do not see the option, check that you are using Sheets in a desktop browser and that you have permission to work with the spreadsheet.

What a standard filter does in a shared sheet

A standard filter is useful when the people using a sheet want to work from one common filtered display. To create one, select the data range, including its header row, and choose Data > Create a filter. Filter buttons appear in the header cells. Open a button to filter by values or conditions, or to sort the range. Other people viewing the sheet can see the standard filter and its effects, and collaborators with suitable access may change its settings.

That shared behavior is why a regular filter can be surprising in a busy workbook. One person may filter a Status column to show only “In progress,” while another is trying to review every record. The second person may see a restricted set of rows, even though no data has been deleted. Clearing the filter restores the rows to view, but it also changes the shared display. Use a standard filter when a common view is intended; choose a filter view when collaborators need independent ways to inspect the same table.

How filter views work

A filter view is a saved arrangement of filters and sorting for a data range. It changes how that range is displayed to the person using the view, not the underlying records or the ordinary view used by everyone else. Multiple collaborators can use different filter views to answer different questions at the same time—for example, one person can inspect overdue tasks while another looks at completed tasks.

It is important to distinguish a private view from private data. A filter view is not a copy of the spreadsheet, a hidden personal workspace, or a security boundary. People who can access the sheet may still be able to see its underlying data by changing views or using other permitted features. Also, edits to cell contents are edits to the shared spreadsheet. If you change a customer name or enter a new status while a filter view is active, that change affects the source data and collaborators can see it.

Create, adjust, and return to a filter view

Prepare the table. Make sure it has one clear header row and consistent columns. Click within the data or select the intended range.
Open a new view. Choose Data > Filter views > Create new filter view. Check that the highlighted range covers the intended records and headers.
Set the criteria. Open a column’s filter control and choose the values to show, apply a condition, or sort the results. You can set criteria on more than one column, such as Region equals West and Status equals Open.
Name the view. Use a descriptive name so you and other sheet users can identify its purpose in the Filter views menu.
Close or switch views. Close the filter-view interface when finished, then select the saved view again from Data > Filter views whenever you need it.

Changing criteria within a filter view changes that saved view, not the source records. If you want to preserve a useful setup, give each distinct purpose its own view rather than repeatedly repurposing a view whose name no longer matches its settings.

Choose the right data range

Good range selection prevents confusing results. Include the header row and all rows and columns that belong to the table, but avoid including a title, notes, or unrelated data above or beside it. If a sheet contains multiple tables, create a view for the relevant table rather than treating the entire worksheet as one dataset. A consistent layout—one record per row and one kind of information per column—makes filtering much easier to interpret.

For example, a volunteer roster might have columns for Name, Team, Availability, and Training status. A filter view for “Training still needed” can show records where Training status is not complete, while another view groups the roster by Team. If a blank row divides the roster, or a second table sits immediately next to it, confirm the selected range rather than assuming Sheets has identified exactly the intended table. A filter can only make sensible choices from the range and headers it is given.

Useful situations and examples

Filter views are especially helpful when a spreadsheet is a shared work queue, schedule, inventory list, or project tracker. They support different questions without asking the whole team to adopt one temporary filter. A sales team might save separate views for each territory; a project group might use one view for tasks assigned to each person and another for tasks due soon. For a class roster, an instructor could filter by section while an administrator reviews a different section at the same time.

Filtering is not the same as making a summary. A filter view narrows the visible records; it does not create a separate report or calculate totals by itself. If you need a reusable summary, a pivot table, chart, or formula-based report may be more appropriate. Likewise, do not use a filter view to conceal sensitive information from collaborators: anyone with access to the source sheet may have access to data that is merely filtered out.

Collaborator access and edits

Filter views separate display choices, not editing rights. A collaborator’s access level still determines what they can do to the spreadsheet. If someone has permission to edit the data, filtering the view does not stop them from changing cells; if someone has view-only access, a filter view does not grant editing permission. Treat data changes, sharing permissions, and display preferences as three different things.

There is also a practical difference between sorting in a filter view and rearranging records in the normal sheet. A sort performed as part of your filter view changes the order displayed in that view, so it does not impose that order on collaborators’ normal views. If you instead sort the underlying range outside a filter view, you are changing the shared sheet’s arrangement. When working with a team, use a filter view for personal investigation and coordinate before making structural changes to the shared table.

Common problems and how to fix them

Other people still see the same rows disappearing. You may have created a standard filter with Data > Create a filter, rather than a filter view. Open Data > Filter views and create or select a view instead.
The filter includes the wrong cells. Close the view and check the table boundaries and header row. Remove unrelated title rows, blank separators, or neighboring tables from the intended range where possible.
A view is hard to find later. Use a clear name and reopen it from Data > Filter views. Names such as “My view” are less useful when several views are saved.
A collaborator sees a different set of results. Confirm that they are using the same named filter view and that its criteria have not been changed. A regular filter and a filter view are different controls, even if both display filter icons.
You cannot create or change a view. Check your access to the file and try the desktop browser interface. Google Sheets’ mobile apps and browser layouts may not expose the same filter-view controls as Sheets on a computer.

Filter views compared with alternatives

Use a standard filter when everyone should see and work with the same filtered range. Use a filter view when people need independent filters and sorts on shared data. If you need to share a fixed selection without changing the original table, copy the relevant records to another sheet or create a separate report—but remember that a copied range may not stay synchronized with the source.

Other tools solve different problems. Hiding rows manually is a sheet-level presentation change, not a substitute for an independent filter view. Protected ranges can restrict editing of selected cells, but they do not make filtered-out data confidential. For sensitive information, use appropriate sharing permissions and a separate file or dataset containing only the information a person is allowed to access. For calculations or an automatically updated output, consider a formula or a pivot table rather than treating a filter as a reporting tool.

Frequently Asked Questions

Can two people filter the same Google Sheet differently at the same time?
Yes. Each person can use a filter view with different criteria, so their displayed results do not have to match. Use filter views rather than a standard filter for independent views.

Does a Google Sheets filter view hide data from other users?
No. It changes the display for the person using that view; it does not remove access to the underlying records or protect them from collaborators who can access the sheet.

Will edits made in a filter view affect the original sheet?
Yes. A filter view is another way to look at the same spreadsheet, not a duplicate. Editing a cell changes the shared source data even though the filter or sort settings are local to the view.

How do I remove a filter view?
Open Data > Filter views and select the view you want to manage. Use the controls in the filter-view interface to manage or delete that saved view; closing the view only exits it and does not delete its settings.

Can I use filter views in the Google Sheets mobile app?
Filter-view creation and management are intended for Sheets in a desktop browser, and the mobile app may not provide the same controls. For reliable setup and management, open the spreadsheet in a computer browser.

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.