Temporary Filter in Google Sheets: How to Use One

To apply a temporary filter in Google Sheets without changing what collaborators see, open the sheet in a browser and choose Data > Filter views > Create new filter view. Set the filter using the column menus, then close the view when finished; filter views are saved with the spreadsheet, so delete the view if you do not want to keep it.

What a temporary filter means in Google Sheets

Google Sheets has two related ways to filter rows. A standard filter is applied to a range on the sheet and changes the displayed rows for people viewing that sheet. A filter view lets you sort or filter the same data in a separate view, so you can investigate a subset without imposing that arrangement on collaborators. This is usually what people mean by a temporary or personal filter.

A filter does not remove records or change the values in filtered-out rows. It changes which rows are shown while the filter is active. The data remains in the spreadsheet, and clearing or closing the filter restores the broader view. That distinction matters when a colleague thinks a customer, order, or task has disappeared: it may simply be excluded by a filter condition.

Filter views are not necessarily disposable. Google Sheets keeps them as named views in the spreadsheet until someone removes them. They can be reused, which is handy for recurring checks, but a one-time view should be deleted if it would confuse people later. A view can also be visible to people with access to the file, so do not treat its name or criteria as private.

Create a filter view step by step

These steps are for Google Sheets in a desktop web browser. If the data is in a shared file, make sure you have permission to create or change views. It is safer to give the filter range clear column headings and avoid blank rows splitting the data into separate blocks.

Open the spreadsheet and click a cell inside the data range. If the data has headers, confirm that each column has a clear heading.
Choose Data > Filter views > Create new filter view. Sheets opens the data in a filter-view mode and displays a bar above the grid.
Check the range shown in the filter-view bar. If it does not include all the intended rows and columns, adjust the range before relying on the results.
Click the filter control in the heading of the column you want to use. Select or clear individual values, or choose a condition such as text contains, date is, or greater than, depending on the column.
Repeat for other columns if needed. Conditions on different columns work together, so a row must meet the active criteria to remain visible.
Give the view a useful name in the bar, such as Open orders or March follow-up. Close the view using the X at the right of the filter-view bar when you are done.

For example, a project tracker might have Status in column B, Owner in column C, and Due date in column D. A view that selects Status = In progress and Owner = Priya shows only rows matching both selections. It does not change the status values, reassign work, or delete other tasks.

Filter by values, conditions, and dates

Each column’s filter menu offers ways to narrow the displayed records. Filtering by values is useful when the column contains a short set of repeated entries, such as region names or task statuses. You can select the values to keep and clear the others. For a large list, the search box in the menu can help locate a particular value before selecting it.

Conditions are better when you need a rule rather than a hand-picked list. For text, you might show entries that contain a word; for numbers, you might show amounts above a threshold; and for dates, you might focus on dates before or after a chosen point. The exact choices depend on the type and contents of the column. If dates or numbers are being treated as text, a condition may not behave as expected, so check the cell formatting and underlying values.

You can also sort from a column’s filter menu. Sorting in a filter view changes the order presented in that view, not the underlying cell contents. To combine criteria, apply them one column at a time. For instance, selecting one region and then filtering a sales column to values above a threshold displays rows that satisfy both selections, not either one independently.

Filter view versus a standard filter

Choose a filter view when you want to explore data without changing the active view for other collaborators. Choose a standard filter when a shared, sheet-wide filtered display is appropriate or when you are working alone and need a quick filter. A standard filter is commonly created with Data > Create a filter. Filter icons then appear in the header row, and the chosen criteria affect the shared sheet view.

The key difference is collaboration, not whether records are edited. Neither kind of filter deletes excluded rows. But a standard filter can make rows disappear from the shared display for others, which can interrupt someone who is using the same sheet. A filter view keeps your own filtering and sorting separate from the standard sheet view, making it a better choice for independent analysis.

Google Sheets is not Microsoft Excel, even though both programs have filtering features. Excel’s AutoFilter and, in supported versions, Sheet View have their own commands and collaboration behavior; the Google Sheets menu path above does not apply in Excel. If you move a workbook between the programs, verify the filters and saved views rather than assuming they transfer identically.

What collaborators can and cannot see

While you are in a filter view, collaborators can continue looking at the sheet without having your filter criteria applied to their normal view. This is useful when several people are reviewing one shared list in different ways. One person can focus on overdue items while another looks at a specific team, without either filter needing to become the common display.

However, a filter view is part of the spreadsheet rather than a private browser-only setting. Other people with access may be able to see and use saved views, subject to their file permissions. Give views descriptive, neutral names and avoid putting confidential information in a view name. Also distinguish filtering from editing: changing a cell while in a filter view changes the underlying spreadsheet data and can affect everyone who uses the file.

Make a one-time view temporary

If you only need the filter once, create a filter view, use it, and then delete it. Closing the view with the X stops displaying it, but closing is not the same as deleting: the named view remains available in the spreadsheet. To remove it, open that filter view and use its options to delete it. The precise control may look different as Google updates the interface, so check the filter-view bar and its options rather than deleting rows from the sheet.

If you want to keep a useful setup, leave the view saved and name it clearly. A named view such as Unassigned tickets is more helpful than Filter view 3. Before deleting a view someone else created, check whether it is used by teammates; deleting a view removes that saved configuration, not the filtered-out records.

Common problems and fixes

Some rows do not appear in the filter range: Check the range shown in the view bar. The selected data may not include rows added below the original range, or blank rows may have separated the dataset.
A condition gives unexpected results: Check for inconsistent data types, extra spaces, spelling differences, or dates stored as text. A column that mixes numbers and text can make filtering less predictable.
A collaborator says the sheet looks different: Confirm whether you used a standard filter or a filter view. A standard filter changes the shared sheet display; a filter view is intended to keep your filtering separate.
You closed the view but still see it listed: Closing a view exits it; it does not erase the saved view. Open it again and use its delete option if it should not remain in the file.
You cannot create or change a view: Check your access level and whether the file is open in a desktop browser. Some actions may be restricted by the owner’s sharing settings or unavailable in a mobile interface.

When results seem incomplete, clear the criteria one column at a time instead of assuming the data has been lost. Also check whether another filter is active in a different column: multiple criteria narrow results cumulatively. If you need to show every row again, remove the active selections or exit the view and return to the unfiltered sheet.

Alternatives when a filter view is not enough

For a short, one-off review, a filter view is usually the simplest option. If you need a durable report for people who should not interact with filter controls, copy the relevant results to a separate sheet or create a formula-based report. A separate sheet can be easier to present, but copied data may become stale unless you refresh it; formulas can keep results linked to source data but require more setup.

For repeated team workflows, consider keeping a small set of clearly named filter views rather than creating a new one every time. For example, a support team could maintain views for Unassigned, Waiting for customer, and Due this week. Agreeing on names and ownership helps avoid duplicates and makes it easier for colleagues to choose the right view. Avoid using a filter as a substitute for access controls: hiding rows is not a way to secure sensitive data.

Frequently Asked Questions

Does a filter view change the sheet for everyone?
A filter view is designed to keep its filtering and sorting separate from collaborators’ normal sheet view. A standard filter, by contrast, changes the shared display. Editing cell values still changes the underlying shared data regardless of which view is open.

Is a Google Sheets filter view temporary?
It can be used temporarily, but Sheets saves filter views in the spreadsheet. Closing one exits it; it does not necessarily delete it. Delete the saved view if you do not want it to remain available.

How do I remove a temporary filter in Google Sheets?
For a filter view, open the view and use its options to delete it. For a standard filter, use Data > Remove filter. Removing a filter changes the display or saved view, not the underlying rows.

Can I filter by more than one column?
Yes. Apply criteria in multiple column menus. The displayed rows must match the active criteria across those columns, so adding another condition usually narrows the result further.

Can I use filter views in Google Sheets on a phone?
The instructions here are for the browser interface on a computer. The Sheets mobile app may not expose the same filter-view controls, so create or manage saved filter views in a desktop browser if the option is not available on your device.

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.