How to Delete a Filter View in Google Sheets

To delete a filter view in Google Sheets, open the spreadsheet in a web browser, go to Data > Change view, and select the saved view you want to remove. In the filter-view toolbar, open the options or gear menu and choose Delete view; this removes the saved view, not the spreadsheet rows or values.

Delete a filter view step by step

Filter views are managed from the Google Sheets interface, rather than from a cell’s filter dropdown. Follow these steps in the spreadsheet that contains the view:

Open the spreadsheet in Google Sheets in a browser. If you have several similar files open, check the document name before making a change.
Select Data > Change view. This menu lists the saved filter views available in the spreadsheet.
Choose the filter view you want to delete. Sheets opens that view and displays its filter-view toolbar above the grid.
Open the toolbar’s options menu, commonly shown as a gear icon, and choose Delete view. Read the prompt if one appears and confirm the deletion.

The view should disappear from the list under Data > Change view. If the toolbar or menu looks different, check that you opened a saved filter view rather than a regular sheet filter. Google can update its interface, so the menu wording or icon placement may vary; look for the active view’s options and the Delete view command.

What a filter view is

A filter view is a saved way to display a subset of a sheet’s rows. It can include a filter condition, a sort order, and a chosen range. For example, a project tracker might have one view showing tasks assigned to Maya that are not complete, and another showing every task due this week. The underlying table remains in the sheet; the view controls what is visible while it is active.

Unlike a simple filter applied to the sheet, filter views let people use different filtered displays without requiring everyone to share one temporary filter state. This can be useful when several collaborators need different slices of the same data. A saved view is a reusable configuration, not a separate copy of the data or a private duplicate spreadsheet.

That distinction matters when deleting one. You are removing a named arrangement of filters and sorting, not deleting the rows that arrangement displayed or hiding them permanently. A row omitted from a view can still be present in the sheet and visible in another view or in the unfiltered grid.

What happens when you delete one

Deleting a filter view removes that saved view from the spreadsheet’s available views. It does not delete cell contents, formulas, formatting, rows, columns, or the source data range. It also does not delete other filter views. If the view was the only way you remembered how to find a particular group of records, you will need to recreate its conditions if you want that display again.

Deleting a view is different from editing it. If you only want to adjust a condition, open the view and change its filter or sort settings instead. If you want to keep the original and try a different setup, check whether the view’s options offer Duplicate, then edit the copy. That approach is helpful when a carefully configured view is used regularly by a team.

Be cautious about changes to the cells themselves while a view is active. Removing the view does not undo edits someone made to the data while using it. For instance, deleting a view that showed overdue invoices will not reverse a changed due date or restore a cleared amount.

Filter views and regular filters are different

A common source of confusion is that Google Sheets has both regular filters and filter views. A regular filter is usually turned on with Data > Create a filter. It adds filter controls to the column headers and changes which rows are displayed in the sheet. If you are using a regular filter, there may be no named view to delete. To remove that filter, use Data > Remove filter.

A filter view is a saved named configuration. It is opened through Data > Change view, and its toolbar identifies the active view. Its settings can be saved for reuse without treating the view as a separate worksheet. You can often recognize it because the filter-view toolbar appears above the sheet and the view has a name.

Deleting a filter view is therefore not the same as clearing a filter condition. If you want to keep the saved view but show more rows, open it and clear or adjust the relevant column filter. If you want to remove the saved configuration entirely, use Delete view. If you want to return the whole sheet to an unfiltered state, close the view or remove the regular filter, depending on which feature is active.

Considerations when collaborating

Before deleting a view in a shared spreadsheet, consider whether another person relies on it. A saved filter view belongs to the spreadsheet’s shared set of available views, so removing it can affect other collaborators who use that view. It does not, however, erase the data those people were viewing. If you are unsure whether it is still needed, ask the spreadsheet owner or team before removing it.

Filter views are especially useful in shared tables because collaborators may need different ways to inspect the same records. One person might sort by customer name while another looks at overdue items. A regular filter can be less suitable for that situation because it changes the sheet’s displayed filter state for the people using the sheet. A filter view gives users a named alternative to that shared workflow.

Access also matters. If you cannot see the relevant view or its deletion command, you may not have the access needed to manage the spreadsheet or view. Ask the owner to check your sharing permissions or remove the view. Avoid making a copy of the spreadsheet as a workaround unless that is actually what you want: a copy separates future changes and collaboration from the original file.

If the delete option is missing

When Delete view is not visible, work through these checks before assuming the view is broken:

Confirm that a filter view is open. Select a named item from Data > Change view. A regular filter does not have the same view-options menu.
Look at the active view’s toolbar. Its options may be represented by a gear or another menu icon. Open the toolbar menu, not a column’s filter dropdown.
Check your access. If you can view the sheet but cannot manage its settings, ask an editor or the owner to handle the deletion.
Check that you are in the right file. A similarly named spreadsheet or a duplicate may contain a different set of saved views.
Try a desktop browser. The full filter-view controls are designed for the Google Sheets web interface; a mobile app may not show the same controls.

If the interface appears stuck, close the filter view and reopen it from Data > Change view, then check its options again. You can also reload the browser tab after confirming that any important edits have been saved. Do not use Data > Remove filter as a substitute for deleting a named view: it targets a regular filter and may not remove the saved view you intended to manage.

Can you recover a deleted filter view?

There is not usually a dedicated recycle bin for an individual filter view. If you delete one and immediately realize it was needed, try the undo command while the deletion is still the most recent action and the spreadsheet still offers Undo. The Windows shortcut is Ctrl+Z; on a Mac, use Command+Z. Undo is not a dependable long-term recovery method, especially after other actions or a page reload.

If undo is no longer available, recreate the view by setting up its range, filter conditions, and sorting again. You may be able to infer the setup from a colleague’s notes, a screenshot, or another similar view. Google Sheets version history can help recover earlier spreadsheet states, but restoring an earlier version may affect more than one view or other recent changes. Review what would be changed before restoring a version, and coordinate with collaborators if the file is shared.

Alternatives to deleting a view

Deleting is appropriate when a view is obsolete, duplicated, or no longer useful. Other choices may fit better if you are only trying to tidy the view list or change how the sheet looks:

Rename it: Use the view’s options to give a useful name, such as Open tasks by owner, rather than removing a view people still need.
Adjust its conditions: Open the view and change the filter or sort settings if its purpose is still relevant but its criteria are out of date.
Duplicate before revising: If available in the view options, make a copy first when you want to preserve the original setup.
Close the active view: Closing it stops displaying that view but does not delete it. You can select it again later from Data > Change view.
Remove a regular filter: If the sheet uses a standard filter rather than a saved view, use Data > Remove filter.

For example, suppose a team has a saved view called March orders. If the team now needs April orders, changing the date condition or renaming the view may be more useful than deleting it. If the March report is finished and no one needs its setup, deletion is a reasonable cleanup step.

Frequently Asked Questions

Does deleting a filter view delete rows from Google Sheets?
No. It deletes the saved view configuration, not the rows or cell contents. Rows hidden by that view remain in the spreadsheet.

How do I delete a filter view in the Google Sheets app?
The full filter-view management controls are available in Google Sheets in a web browser. If you do not see the view’s options in the mobile app, open the spreadsheet on a computer browser and use Data > Change view.

Can other people still see a filter view after I delete it?
Deleting a saved view removes it from the spreadsheet’s available views for collaborators. It does not remove the data that appeared in the view. If the view is shared or used by a team, check with its users before deleting it.

What if I only want to clear the filter?
Open the filter view and clear or change the condition in the relevant column. That keeps the saved view. For a regular sheet filter, use Data > Remove filter; this is different from deleting a named filter view.

Can I undo deleting a filter view?
Try Undo immediately after deletion with Ctrl+Z on Windows or Command+Z on Mac. If that is no longer available, recreate the view from its range and filter settings. Version history may help, but restoring an older version can affect other recent changes too.

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.