Google Sheets Filter View: How to Lock It

Google Sheets has no separate lock switch for a filter view. To keep people from changing a saved view, create and name the view, then give people who should not alter it Viewer access rather than Editor access. You can protect cells or a sheet to limit data edits, but sheet protection does not lock the filter-view settings themselves. The steps below explain the distinction and how to set up a view that is less likely to be changed.

A filter view lets you sort and filter a shared table without changing the view other people currently have open. It is useful for keeping a saved way to inspect data, such as a list of overdue tasks. However, people with editing access may be able to change saved filter views. If collaborators need to edit spreadsheet data but must not change the view, Google Sheets does not provide separate permissions for those two actions.

What You’ll Need

A Google account with access to the spreadsheet. You will need Editor access to create or manage a saved filter view and to change sharing settings.
A spreadsheet with a clearly defined table. Ideally, it has one header row, no blank rows inside the data, and a consistent value type in each column.
A decision about who should be able to edit the spreadsheet. People who only need to view it should be assigned the Viewer role. Editors can change spreadsheet content and may alter saved views.
Optional: a copy of the spreadsheet if you are about to change access for a large group or a business-critical file. Confirm that the right people can still use the document after changing permissions.

Step-by-Step

Check the table before creating the view. Open the spreadsheet in a web browser and identify the full data range, including the header row. For example, if the table occupies columns A through F and rows 1 through 300, make sure all six columns have headers and that there are no unrelated notes immediately beside the table. A clean range helps Sheets apply sorting and filter criteria to the intended rows.
Create a filter view. Click a cell in the table, then choose Data > Create a filter view. Sheets opens the range in a filter-view mode, usually marked by a dark bar across the top of the data. Check the range shown in that bar. If it does not include all the table rows and columns, adjust it before setting criteria. A normal filter and a filter view are different: the normal filter affects the shared sheet view, while a filter view is a saved view that collaborators can use independently.
Name the view so its purpose is clear. Click the name field in the dark filter-view bar and enter a descriptive name, such as Overdue tasks or West region orders. A name that explains both the data and the condition is easier to recognize than Filter view 1. If the view has a range field, verify that it includes the header row and the complete table. Sheets saves filter-view changes as you make them, so there may not be a separate Save button.
Set the filters and sorting you want to preserve. Use the filter icons in the header row to choose conditions, such as showing only one status or excluding blank values. Use the same controls to sort a column if the view should open in a particular order. Check the displayed rows before moving on. Filtering a date column, for example, can produce unexpected results if some entries are stored as text rather than dates.
Close the view and confirm it is listed. Click the X at the right of the filter-view bar to exit. To reopen or check the saved view, use Data > Change view or the filter-view option shown in the Data menu. Menu wording can vary slightly as Google updates its interface. Select your named view and confirm that the criteria and sort order appear as intended. If the view is missing, confirm that you created a filter view rather than turning on a standard filter.
Choose the access level for each collaborator. Click Share in the upper-right corner. In the sharing window, review both the people listed under access and the General access setting. For someone who only needs to inspect the sheet, change their role to Viewer. If general access is set to anyone with the link, select the appropriate role there too. If the file is restricted, add viewers by email as needed. Do not leave a person as an Editor if your goal is to prevent them from changing the saved view.
Check that editing access is limited as intended. Review the Share window again after making changes. Editors can change spreadsheet data and may modify filter views; the Viewer role is the practical way to stop a recipient from saving changes to the shared file. A viewer may still be able to inspect data or use available filtering options for their own session, depending on the interface and access conditions. The important distinction is that a viewer cannot edit and save changes to the shared spreadsheet as an editor can.
Protect important cells separately, if needed. If some collaborators must remain editors but should not change particular cells, choose Data > Protect sheets and ranges, select a range or sheet, and set the permitted editors. Use this to restrict edits to the protected data. Do not treat protection as a lock for the filter view: it controls cell or sheet editing, not who can change a saved filter-view configuration. If the view itself must remain controlled, limit Editor access or keep the master spreadsheet under a small number of editors.

Common Mistakes

Looking for a lock icon or a view-level permission. Google Sheets does not offer a dedicated setting that makes one saved filter view read-only while leaving the rest of the spreadsheet editable. Changing the sharing role is the meaningful control over whether a person can save changes to the file.
Using a regular filter instead of a filter view. A regular filter changes the shared sheet display and can affect what other collaborators see. If the aim is to save a personal or named arrangement, create a filter view from the Data menu and verify its name in the view bar.
Assuming protected ranges lock the view. Protection can stop selected users from editing protected cells, but it does not provide a separate permission for filter-view settings. Protect data when data editing is the concern; manage sharing roles when saved-view editing is the concern.
Leaving general access too broad. Changing one collaborator to Viewer does not necessarily change a separate anyone-with-the-link setting. Check both individual access and General access so the file is not still editable by a wider group than intended.
Forgetting that a filter hides rows rather than deleting them. A filtered-out record is still in the sheet. Before sharing a view, make sure recipients understand that they are seeing a filtered set and can clear or change conditions if their role and interface allow it.

Tips

Use names that describe the view’s purpose, not who created it. Names such as Open requests by priority remain useful when team members change.
Keep the header row included in the filter range and avoid merged cells in the table. A single, continuous data range is easier to sort and filter reliably.
Make a separate filter view for each common way of reviewing the same data. For example, save one view for unassigned items and another for items due this week instead of repeatedly replacing one set of criteria.
Before changing sharing roles, identify which collaborators genuinely need to edit cells. Assign Viewer access to readers and keep Editor access limited to people who need to maintain the file.
If editors must update the data but must not change the master view, consider keeping a controlled master file and collecting edits in a separate input sheet or document. Review and transfer submitted changes rather than giving every contributor Editor access to the master.
Share a link to a particular filter view when it helps a recipient find it quickly. A link can make the intended view easier to open, but it does not override the spreadsheet’s access permissions or make the view immutable.

Troubleshooting

The filter-view option is missing. Confirm that the file is open in Google Sheets in a browser and that you have sufficient access. If you have Viewer or Commenter access, you may not be able to create or save a filter view. Ask the owner for Editor access if you are responsible for setting it up, or ask an editor to create the view.

The view is not keeping its criteria. Reopen the view from the Data menu and check that you are editing the named view rather than using a temporary or standard filter. Confirm that the conditions are applied to the correct column and that the range includes the relevant records. If you do not have permission to save changes, ask an editor to update the view.

Someone changed or removed the saved view. Check who has Editor access and reduce it for people who only need to read the sheet. Google Sheets does not provide a separate restore or lock control for a single filter view. If the file has version history available, an owner or editor can use File > Version history > See version history to inspect earlier spreadsheet versions and restore one if appropriate. Restoring a version can affect other changes, so review it carefully first.

A collaborator still says they can filter the data. Filtering data for personal inspection is not the same as saving a change to the shared view. Verify the collaborator’s role in the Share window. If they are a Viewer, they should not be able to save edits to the shared spreadsheet. If they need to edit cells, understand that Sheets does not offer a role that permits cell editing while specifically forbidding changes to filter views.

Rows appear to be missing after you protect the sheet. Protection does not remove rows, and a filter view may still be hiding rows that do not meet its conditions. Exit the filter view or clear its criteria to check the full table. Also confirm that the filter range reaches the last row of the data.

Frequently Asked Questions

Can I lock just one filter view in Google Sheets?

No. Sheets does not have a setting to lock an individual saved filter view while leaving other editing permissions unchanged. Limit Editor access to prevent recipients from saving changes to the spreadsheet, or keep the master view managed by a small group of editors.

Can people with Viewer access use a filter view?

They can open and inspect the spreadsheet, and the options available for filtering can depend on their access and the current Sheets interface. They cannot save edits to the shared spreadsheet as an editor can. If a viewer needs a specific view, share the view link or explain which named view to open.

Does protecting a sheet stop someone changing the filter view?

No. Data > Protect sheets and ranges is for restricting edits to cells or sheets. It is not a filter-view permission control. Use sharing roles to control who can edit the file and its saved views.

Can editors still change the data if they cannot change the filter view?

There is no built-in permission that separates those capabilities. Editors can edit spreadsheet content and may also change saved views. If that separation is essential, use a controlled master file and collect edits through another file or process.

Will a filter view change what everyone else sees?

A filter view is designed to let people work with their own saved view without changing another collaborator’s current view. A standard filter is different and can affect the shared sheet display. Create and name a filter view when you need a saved, separate arrangement.

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.