Google Sheets Filter Just for Me? Use Filter Views

Yes. In Google Sheets, use a filter view to sort or narrow rows for your own view without changing the filter other collaborators see. Open the sheet in a web browser, choose Data > Create a filter view, then set the conditions you want.

How to create a filter view

Filter views work on a range of cells with column headings. If your data has no header row, add one first: descriptive headings make it easier to tell which column you are filtering and help prevent a header from being treated like an ordinary record.

Open the spreadsheet in Google Sheets on a computer. Select a cell in the data range, or select the range you want the view to cover.
Choose Data > Create a filter view. Sheets displays filter controls for the columns and a bar indicating that a filter view is active.
To filter a column, click its filter control. Choose values to include, or use the condition options to show rows matching a rule. For example, a status column can be limited to “In progress.”
To sort within the view, open a column’s filter control and choose a sort order. You can filter one column and sort another.
Give the view a useful name in the bar at the top, such as “My open tasks.” Close the view when you are done; you can reopen a saved view later from the filter views menu.

The view changes what rows you see, not the underlying cell values. The exact controls may vary slightly as Google updates Sheets, but the key distinction is that you create a filter view rather than turning on the ordinary sheet-wide filter.

What “just for me” means when collaborating

A filter view lets each person examine the same spreadsheet with a different filter or sort. If you apply a filter view to show only your team’s records, another collaborator can work with the sheet or use a different filter view without having your filter take over their screen. This makes filter views useful when several people need different slices of a shared list at the same time.

There is an important distinction between a view being isolated and being private. A named filter view is saved in the spreadsheet, and other people with suitable access may be able to find and use it. You can also share a link that opens a particular view. “Just for me” means its display settings do not impose your filter on everyone; it does not mean the saved view is secret or that its source data is hidden from other spreadsheet users.

Changes to the data itself are different from changes to a view. If you edit a cell, delete a row, or add information to the shared spreadsheet, you are changing the shared file. A filter view is not a separate personal copy and does not create a private workspace for editing.

Filter views versus the regular filter

Google Sheets has both a regular filter and filter views, and they solve related but different problems. With a regular filter, someone turns on filtering for the sheet or range and applies conditions using the column controls. That shared filter state can affect what collaborators see, which can be disruptive when several people are working at once.

A filter view is the better choice when you want a reusable, individual arrangement of the same data. You can make several views for different tasks—one for overdue work, another for a particular department—and switch between them without repeatedly changing the sheet-wide filter. Use a regular filter when the group intentionally wants one common filtered display and does not need separate views.

Use a filter view for personal sorting, checking a subset, or keeping several saved ways to inspect shared data.
Use a regular filter when a shared, temporary filter is appropriate for everyone using that sheet.
Use a separate sheet or file when people need different editable data, not merely different ways to view the same records.

Neither kind of filter deletes records. A filtered-out row remains in the spreadsheet; it is simply not shown in the current filtered display. Before deleting or editing a row, check that you understand whether the filter is hiding other records that might also be affected by your selection.

Useful examples for everyday work

Suppose a shared task tracker has columns for owner, due date, status, and priority. You could create a view named “My active tasks,” filter the owner column to your name, and exclude completed work. A project manager could make a separate view for high-priority tasks, while a teammate checks items assigned to them. Everyone is looking at the same rows and updates, but their current displays can differ.

For a sales sheet, a view might show orders from one region and sort them by order date. In an event list, one view could show registrations that still need follow-up. These are display choices, not new copies of the underlying records. If a colleague updates an order’s region or a task’s status, the row may enter or leave a view because the data now matches different filter conditions.

Filter views can also help with review work: sort a range by a date or amount to inspect unusual entries, then close the view to return to the broader sheet. If the data is important, make sure the view’s range includes the relevant rows and columns. A view that covers only part of a growing list may not show newly added records as expected.

Saving, naming, and sharing a view

Give saved views names that explain their purpose rather than their creator alone. “Unassigned requests” is more useful to a teammate than “View 2.” Saved filter views belong to the spreadsheet, so collaborators with appropriate permissions may see them in the available filter views list. That can be helpful for team workflows, but it is another reason not to treat a view as confidential.

When you want someone to open a particular view, use the sharing option or link available for that filter view, if it appears in your Sheets interface. A link does not grant access to the spreadsheet by itself: the recipient still needs permission to open the file. Also, a shared link is not a security boundary. It points to a way of viewing the spreadsheet, rather than creating a restricted copy of its rows.

To stop using a view, close it with the control in the filter-view bar. To manage saved views, open the filter views menu and select the view you need; available management options can depend on your access and the current interface. Avoid deleting a named view if coworkers rely on it.

Permissions, privacy, and mobile use

Filter views are for organizing what a person sees, not for controlling who can read data. If a collaborator should not see certain records, do not rely on a filter to conceal them. A user with access to the spreadsheet may be able to change or remove filters, open another view, or otherwise inspect rows that are still part of the file. Use appropriate file-sharing permissions or a separately controlled spreadsheet for genuinely restricted information.

Likewise, do not confuse a filter view with protected ranges. Protection can limit who edits certain cells, but it does not necessarily hide those cells or rows from readers. Consider who can open the file and what information it contains before sharing it.

Google’s full filter-view creation and management workflow is intended for the desktop web version of Sheets. The mobile apps may offer basic ways to work with filters, but the interface and filter-view controls are more limited. If you cannot find Data > Create a filter view on a phone or tablet, open the spreadsheet in a desktop browser rather than assuming the feature is absent from the file.

Common problems and fixes

Your filter affects a coworker: Check whether you created a regular filter instead of a filter view. Close the regular filter if appropriate, then create a filter view for your own inspection.
The headings appear in the results: Check that the selected range includes the header row and that the data is structured as a single table with one heading per column.
Some expected rows are missing: Open each column’s filter settings and check selected values and conditions. Also confirm that the saved view covers the full data range, especially if rows were added later.
You cannot create or save a view: Your access level or the current interface may limit what you can do. Ask the owner for the necessary permission, or make a copy if you are allowed to and need a separate working version.
You cannot find the view on mobile: Use Sheets in a desktop browser to create and manage filter views, where the complete controls are available.

If the rows appear in an unexpected order, check whether a sort is active in the view. Sorting changes their displayed order; it does not rewrite values in the cells. If you need to change the actual data, make the edit deliberately and remember that it affects the shared spreadsheet.

When another approach is better

If you only need a one-time personal look at the data, a filter view is usually the simplest option. If you need your own editable copy, use File > Make a copy when you have permission. A copy is separate from the original, so later edits to one file do not automatically update the other; that can be a drawback when everyone needs current information.

For a report that should display selected records in a separate area, a formula-based output or a dedicated report tab may be more suitable than changing the view of the source table. That approach takes more planning and can require maintaining the report as the source data changes. For access control, share a separate file with only the intended data and appropriate permissions rather than trying to hide rows with a filter.

As a rule of thumb, choose a filter view for a different perspective on shared records, a copy for independent editing, and a separate access-controlled file when the audience should not have access to the full source data.

Frequently Asked Questions

Can I filter a Google Sheet without changing what others see?
Yes. Create a filter view with Data > Create a filter view in the desktop browser version. Avoid changing the ordinary shared filter if you want collaborators to keep their own display.

Can other people see my Google Sheets filter view?
A saved, named view is part of the spreadsheet and may be available to collaborators who have suitable access. It is not a private or confidential filter. You can share a link to a view, but recipients still need access to the file.

Does a filter view hide rows from other users?
No. It changes the rows displayed in that view; it does not remove the rows or restrict access to them. Do not use filters to protect sensitive information.

Will sorting in a filter view rearrange the shared data?
Sorting within a filter view changes the displayed order for that view. It does not move the underlying cell contents into a new order for everyone. Editing or deleting cells, by contrast, changes the shared spreadsheet.

Can I create a filter view in the Google Sheets app?
The full create-and-manage workflow is available in Sheets on a desktop browser. Mobile controls are more limited, so use a computer browser if you need to create, name, or manage a saved filter 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.