To create a filter view in Google Sheets on a computer, select the relevant data, then choose Data and Create filter view. Set the desired column filters or sort order, save and name the view where prompted, and close it when finished.
A filter view lets collaborators inspect the same table in different ways. It changes the view of the underlying records and does not create a separate copy or restrict access. If you share a saved view’s link, the recipient still needs permission to open the spreadsheet.
- Use a filter view for a separate way to inspect a shared table.
- Include the real header and all related columns.
- Name the view by its criteria.
- Close the view to return to the ordinary sheet.
- Share the view only with people who should have access to the source workbook.
Create a filter view from a complete table
On a computer, open the spreadsheet and identify the header and data rows. Select the intended table, including the header. Choose Data and Create filter view. Use the filter control on the relevant column. Set the values or condition and inspect the result. Save and name the view using the controls available in your interface. Close it when you want to return to the ordinary worksheet.
Try it on an activity register
Suppose a register contains Student ID, Session, Status and Notes. Create a view for confirmed Tuesday sessions. Filter Session to Tuesday and Status to Confirmed. Inspect one known confirmed Tuesday row, one pending Tuesday row and one confirmed Thursday row. Only the first should remain visible. Clear the view and verify that the other records still exist.
Use a clear name
A name such as Confirmed Tuesday sessions is more useful than Filter 1. If the view also sorts by surname or room, mention that only when it matters to the reader. Check whether the view is intended for a continuing workflow or a short review. Clean up obsolete saved views under the team’s process.
Check the boundaries of the view
If the source range stops at row 100, a new record on row 101 might be outside the saved view. Open the view settings and inspect the range. Include the whole record width, so important notes or dates travel with the rows when you inspect the table. Keep other tables and totals outside the range when they should not be filtered.
Back to contents · Next section
Choose a filter view instead of a standard filter when working together
A regular filter is useful when the intended sheet view should use shared criteria. A filter view is useful when one reader wants to inspect a particular subset or order while other collaborators use their own views. On a shared workbook, decide whether the change is for everyone or only for one way of looking at the data.
A teacher and a coordinator need different views
The teacher wants to see entries for their class. The coordinator wants to see pending entries across all classes. Create two named views using the same source table. Check one record that appears in both and another that belongs only in one. Keep the original data structure intact. The views describe different subsets and do not change the records themselves.
A formula report answers a different question
A filter view is a way to inspect the source. FILTER or QUERY can produce a separate formula result in another area. Use a separate report when the reader needs a generated output with its own headings or calculations. Verify its audience separately. A view does not make a private subset out of a shared file.
A viewer may have only a temporary view
Google documents temporary filter views for people who do not have edit access. A viewer can inspect the data through that temporary view where available, while saving a reusable view requires the appropriate permissions. Check the exact account and role before expecting a view to persist. If a teammate needs a saved view, ask an authorised editor to prepare it under the workbook’s process.
Previous section · Back to contents · Next section
Filter by values or conditions deliberately
Use a value selection when the task has a defined set of labels. Use a condition when the rule is based on a threshold, date or another supported test. Read the source cells first. A status with a trailing space can appear as a distinct value, and dates stored as text can behave differently from actual dates.
Choose exact statuses for a review queue
If the queue should contain Pending and Needs review, choose those values. Check a Done record and an entry with a blank status. A blank can be missing data rather than a valid queue state. If the workflow needs to review missing values too, include them intentionally and name the view accordingly.
Test a numeric or date boundary
If the view should show quantities below 10, check values of 9 and 10. If the task includes 10, choose an inclusive condition. For dates, verify a record on the start or end day. Check how the source represents time if the condition is about calendar days. The saved view should match the team’s intended scope.
Remember that filters on different columns work together
If you filter Session to Tuesday and Status to Confirmed, a record must satisfy both restrictions to appear. When the view looks empty, clear one condition at a time in an approved test and inspect which one removed the expected row. Check source spelling and range before assuming the record is missing.
Previous section · Back to contents · Next section
Share the saved view’s link responsibly
Open the intended saved view and use the URL for that view, as Google’s help describes. Send it through the approved sharing channel only when the recipient is authorised to open the workbook. Test the link in the intended access context where practical. A view link can help someone start in the right place. It is not a substitute for permission.
Check what the recipient can see after closing it
A user who can open the source workbook can generally inspect other accessible records. Closing or changing a filter view can reveal rows outside its current subset. If the recipient should receive only confirmed Tuesday sessions, provide a separate approved output containing just those records. Review its contents and access independently.
Verify that the link opens the expected view
Use a named view with a distinctive condition. Open the link and check its name and one known record. If the link opens the workbook but not the expected view, check whether the view was saved, deleted or copied into another file. A copied workbook is a different destination. Use its own correct link and verify the role.
Previous section · Back to contents · Next section
Fix records that appear to have disappeared
Look for an active filter view before editing the source. Close the view and inspect the complete table. If the record is present outside the view, inspect the active criteria. A row can be hidden by any of several filters. Check its exact values and whether the row is within the selected range.
A record appears outside the view’s data range
Open the view and inspect its bounds. Extend them when the new records belong in the same table. Check a known old row and a known new row. Make sure the header remains correctly placed. A view can remain useful for a fixed historical block even when it should not expand, so follow the report’s purpose.
A filter includes an old label
A team may rename Waiting to Pending. Check the saved view’s selected values and the source records. If older records still use Waiting, decide whether both belong or whether the source should be standardised. Update the view to reflect the approved workflow and verify one record under each label.
A row is hidden for another reason
A sheet can contain manually hidden or grouped rows as well as filtered rows. Close the view and inspect the source layout. If the record is still absent, check the appropriate controls and the underlying data. Avoid inserting a replacement record until you know whether the original already exists.
Previous section · Back to contents · Next section
Maintain views that other people rely on
Review important saved views after changes to headers, record ranges or status labels. Open one view at a time and confirm the name still describes what it shows. Verify a known included record and a known excluded record. Test a new row where the table has grown.
Practise a handoff using two views
Create a harmless register with two sessions and two statuses. Build one view for confirmed records and another for Tuesday records. Find a row that appears in both, a row only in one and a row excluded from both. Open and close each view. Verify that a colleague can locate the intended view under the workbook’s sharing rules.
Keep the whole table easy to audit
Use a clear header row and stable column meanings. If a new column is added, review whether it belongs in each view’s range. Give readers a way to return to the ordinary sheet. If the view is used for a fixed submission, verify the exact exported or copied output separately.
Previous section · Back to contents · Next section
Build views for a weekly project meeting
A school event team has a task register with Task ID, Task, Team, Owner, Due date and Status. The meeting lead needs unfinished items across all teams. The logistics lead needs tasks assigned to Logistics. The event coordinator needs overdue items ordered by due date. Use three named views on the same table and have the leads agree on which statuses count as unfinished.
Start the logistics view with Team set to Logistics. To find open logistics items, apply a second condition on Status. Compare the result with a known sample that includes one finished logistics task and one open task for another team. Both should disappear. Add an open logistics task and check that it remains visible. Use the task ID to verify the record if two task titles look alike.
Keep a zero-result view interpretable
When the overdue view is empty, first check that the range reaches the most recent task, that the dates are real date values, and that an older status selection did not exclude newly added categories. Open the unfiltered table and inspect one record you expect to match. If the deadline is stored as text, fix the source value and rerun the check. A correctly empty queue is useful. An empty queue caused by stale criteria can hide work.
If a second team needs a similar view, duplicate the original and change one condition at a time. Keep a meaningful name for each copy and open the copied link from the account that will use it. That check catches a valid filter view link sent to a person who lacks access to the spreadsheet.
Previous section · Back to contents · Frequently asked questions
Frequently asked questions
Can two people use different filter views?
Yes. Filter views let people inspect the same shared data in different ways.
Can a viewer save a filter view?
Google documents temporary views for people without edit access. Use an authorised editor to save a reusable view.
Does the view hide records from people who should not see them?
No. Use an approved separate output and file sharing when the recipient should only receive a subset.
Why is a new row missing?
Check the view range and each active filter.
How do I share a view?
Open the saved view and copy its view URL. The recipient still needs access to the workbook.
Helpful reading
- Google Docs Editors Help on filters and filter views
- How to Freeze Rows and Columns in Google Sheets
- How to Protect Cells and Lock Formula Columns in Google Sheets
- How to Use FILTER in Google Sheets With One or Multiple Conditions
- How to Use QUERY in Google Sheets
Verify the view and the link before relying on them
Check the range, criteria and reader’s access. A saved view should make it easy to find the intended rows without confusing them with a separate dataset.