Google Sheets Filter Only for Me? Use Filter Views

Yes. In Google Sheets, use a filter view when you want to sort or filter rows without changing what collaborators see. In a browser, open Data > Filter views > Create new filter view, then set the conditions you need; the view is saved separately from the sheet’s shared, ordinary filter.

Why a regular filter is not personal

Google Sheets has two features that can look similar but behave differently. A regular filter is created with Data > Create a filter. It adds filter controls to the selected range, and the resulting filter state is shared: when someone changes the ordinary filter, other collaborators can see the changed rows too. That is inconvenient when several people are working in one spreadsheet and each needs a different slice of the same data.

A filter view is designed for that situation. It applies sorting and filtering as a named view rather than replacing the sheet’s shared filter state. For example, a sales team can keep a common table intact while one person views the West region, another checks overdue accounts, and a third sorts by sales amount. Each person can work in a different view without making the others’ current view jump to a different set of rows.

“Only for me” describes the effect on other people’s view, not a privacy setting. A filter view does not conceal rows from collaborators or restrict who can read the underlying data. Anyone who already has access to the spreadsheet may still be able to open the data and use other views, depending on their permissions.

Create a filter view in a browser

Filter views are available in Google Sheets in a desktop web browser. To create one, open the spreadsheet and follow these steps:

Select a cell in the table you want to filter. If the data is not in a clearly defined block, select the intended range so the view does not include unrelated cells.
Choose Data > Filter views > Create new filter view. Sheets opens the range in a filter-view mode, usually marked by a dark bar across the top of the grid.
Check the range shown in the bar. If it is wrong, adjust the range there before applying conditions.
Use the filter control in a column heading to filter by values, conditions, or other options available for that column. You can also sort using a column’s control.
Give the view a useful name in the bar, such as West region or Open orders. Close the view with the X at the right side of the bar when you are done.

Google Sheets saves filter-view settings so you can reopen the view later from Data > Filter views. Name views by their purpose rather than by the person who made them; a name such as “Needs follow-up” remains useful even if the team changes. Exact labels or placement can vary as Google updates the interface, but the distinction between creating a filter and creating a filter view remains important.

What happens when you use one

A filter view changes how the rows are displayed, not the cell contents. Filtering a Status column to show only “Pending,” for instance, hides other rows from that view; it does not delete them, clear their values, or move them to another sheet. Likewise, sorting within a filter view changes the displayed order for that view rather than intentionally reorganizing the shared data for everyone.

Edits to cells are different from view settings. If you edit a value while a filter view is open, you are editing the shared spreadsheet, and people with access can see that edit. The view is not a private copy or a way to make isolated edits. Before changing data, check that you are editing the intended row—especially if the filtered results hide many surrounding records.

Filter views are useful for recurring work because their conditions can be kept under a recognizable name. A view for “Invoices due this week,” for example, can save a team member from rebuilding the same filter each time. You can create multiple views for different tasks rather than repeatedly changing one standard filter.

Filter views compared with the ordinary filter

Choose the feature based on whether the filter state should be shared:

Use a filter view when collaborators need independent ways to inspect the same dataset, or when you want a saved, named arrangement of filters and sorting.
Use Data > Create a filter when the group wants one shared filter state and it is acceptable for filter changes to affect what collaborators see.
Use a separate sheet or spreadsheet when people need genuinely different working copies, different access permissions, or a curated subset of data rather than just a different view.

A regular filter can still be useful for a small sheet or a task where one person is working alone. But it is not the best answer to “How can I filter without disturbing everyone else?” In a collaborative spreadsheet, a filter view is the feature intended for independent viewing.

Share a view without confusing it with access

Filter views can be named and shared with collaborators, including by sharing a link to a particular view where that option is available. Sharing the view is not the same as sharing the spreadsheet itself: a recipient still needs permission to open the file. A link to a view does not bypass the document’s sharing settings or grant access to people who otherwise cannot open it.

Also, do not treat a filter view as a way to hide confidential information. A collaborator with access to the spreadsheet may be able to change or clear filters, inspect other rows, or use another view. If certain people must not see particular records, use appropriate sharing permissions and a separate file or data source designed for that access boundary. Hiding rows, applying a filter, or naming a view “private” does not make its contents private.

If the goal is simply to give a colleague a convenient starting point, name the view clearly and tell them which range or conditions it represents. If the goal is to limit data access, change who can access the file or provide a properly restricted copy instead.

Common problems and how to fix them

“My filter changed what my coworker sees.” You may have used Data > Create a filter, which creates the shared ordinary filter. Close it or clear it as appropriate, then make a filter view from Data > Filter views > Create new filter view.
“I cannot find Filter views.” Open the file in a desktop browser and check the Data menu. The Sheets mobile app does not provide the same full filter-view workflow as the desktop browser. If the menu remains unavailable, check your access level and whether the file is open in a compatible editing mode.
“The view is filtering the wrong cells.” Review the range displayed in the filter-view bar. A range that omits a column or includes extra rows can produce confusing results. Recreate or adjust the view using the full table, including the intended header row.
“A row seems to have disappeared.” It may simply fail the active filter condition. Clear the condition or switch to another view to check; filtering does not itself erase the row. Be cautious before editing or deleting anything based only on the visible subset.
“Someone else cannot open my view.” Confirm that the person can access the spreadsheet first. A view link does not override file permissions, and a collaborator may need to open the file in a browser and select the view from the Data menu.

Alternatives when a view is not enough

If people only need to inspect different categories, separate filter views are usually the simplest option. If they need different data-entry workflows, consider separate tabs with clear labels, while remembering that tabs in the same spreadsheet generally share the same file-level access. If different groups must see different records for confidentiality or policy reasons, use separate files with carefully controlled permissions instead of relying on filters.

For a report that should display a changing subset without users operating filter controls, a formula-driven summary or a dedicated reporting tab may be more appropriate. That approach requires someone to design and maintain the report, and it does not replace access controls. Choose it when the audience needs a stable presentation, not merely a personal way to explore the same table.

Frequently Asked Questions

Can multiple people use different filters in the same Google Sheet?
Yes. Each person can use a filter view to apply a different set of filters or sorting without changing the other collaborators’ current view. Avoid changing the ordinary shared filter if independent views are the goal.

Does a Google Sheets filter view change the data?
No. Filtering hides rows from the current view, and sorting changes the displayed order in that view. Editing a cell, however, changes the shared spreadsheet data.

Can I make a filter view private?
Not in the sense of hiding records or making the view inaccessible to everyone else. A filter view is a separate viewing arrangement, not a security control. Use file permissions or separate, restricted files to control who can see data.

Can I create filter views in the Google Sheets app?
The full filter-view workflow is intended for Sheets in a desktop web browser. If you need to create or manage a view, open the spreadsheet in a browser and use the Data menu.

Will my filter view still be there later?
Named filter views are saved with the spreadsheet and can be reopened from Data > Filter views. If you cannot find one, make sure you are in the correct spreadsheet and have access to the file.

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.