How do I share a filtered view without changing what other spreadsheet viewers see?

If you’re working in Google Sheets, create a filter view instead of applying the standard filter. Google’s guidance says a standard filter is visible to people with spreadsheet access, and editors can change it. A filter view applies sorting and filtering to an individual view, and multiple people can use different filter views at the same time. [S1]

On a computer, choose Data > Create filter view, set the location filter, and save the view. You can optionally share its URL. [S1] Use a descriptive name, such as “Location — North,” to help coworkers identify it. If you’re unsure which kind of filter is active, verify that before changing anything.

Check whether you created a filter view or used the standard filter. Google recommends verifying this distinction before collaborating. [S1] If you only applied the standard filter, don’t describe it as a separate saved view. Create a filter view and set the criteria there instead.

For example, suppose a sheet has equipment records for several locations. Create a filter view for “North location,” apply that location criterion within the view, and save it. The goal is to present that perspective without changing the standard filter other viewers see. This example doesn’t confirm how a particular spreadsheet is currently configured.

You can optionally share the saved filter view’s URL. [S1] Before sending it, verify that you’re sharing the intended saved view rather than relying on an unsaved temporary view. A viewer can create a temporary view, but it will not be saved. [S1]

Also check that your coworker can access the spreadsheet through your usual sharing process. Google’s guidance says a view URL can be shared, but it doesn’t establish spreadsheet access or permission settings. If your coworker can’t open the sheet or view, follow your normal access process rather than changing the standard filter to work around it.

Use this sequence for a Google Sheets handoff:

1. Confirm the file and the rows or columns you intend to filter.
2. On a computer, choose Data > Create filter view—not the standard filter. [S1]
3. Apply the criteria and any sorting inside the filter view.
4. Save the view with a descriptive name, such as “Location — North.”
5. Recheck that it’s the intended saved view, then optionally share its URL. [S1]
6. Tell the recipient what the view is called and check access through your usual process.

A handoff note could say: “Please open the saved filter view ‘Location — North.’ This is a filter view, not a change to the standard filter.” Replace the example name with the one you used.

These steps are specific to Google Sheets. The guidance cited here doesn’t establish filter-view behavior in other spreadsheet applications or the access permissions for a particular sheet. [S1]