Google Sheets web app (rolling service) · Data management · Beginner
Filter a shared Google Sheet without changing coworkers’ views
Create a named filter view, check visible order IDs, reopen or share the view, and avoid moving shared records with an ordinary sort.
Documentation-reviewed draft; not tested in Google Sheets. · Editorial standards
Use a filter view for your own subset of a shared sheet. A normal filter is visible to everyone with access, and editors can change it. Filter views let collaborators work with different views concurrently. They do not create private copies of the data. Google’s filter model
Requirements and practice data
These instructions target Google Sheets in a desktop browser. Editors can save named views; viewers can use temporary views that are not saved. Use a practice file or an authorized copy before changing a production sheet.
Enter this synthetic order list in A1:E7. Keep each record on one row and the column headings on row 1.
| Order | Region | Product | Amount | Status |
|---|---|---|---|---|
| 1001 | East | Cable | 120 | Open |
| 1002 | West | Adapter | 85 | Closed |
| 1003 | East | Stand | 160 | Open |
| 1004 | North | Cable | 95 | Open |
| 1005 | West | Hub | 140 | Closed |
| 1006 | North | Adapter | 70 | Open |
Download the plain-text practice records if useful. The download contains comma-separated values, not saved filter settings. You can copy its six records into your practice layout or save a copy as CSV for import.
Before filtering, count six orders, of which four are Open. The amounts total 670. These checkpoints help distinguish hidden rows from missing records.
1. Create an East open-orders view
- Select the complete block A1:E7, including headings.
- Choose Data → Create filter view.
- In Region, filter by values to retain East; in Status, retain Open.
- Sort Amount descending using the column’s filter control.
- Choose Save View, enter a descriptive name such as
East - open - largest first, and save.
Google’s current documentation uses Create filter view, Save View, and Data → Change view. Older screenshots may show different menu organization. Current desktop workflow
Expected visible records: 1003, then 1001, with amounts 160, then 120. Their sum is 280. The West and North records are outside this view; they should not be deleted.
2. Verify collaboration rather than assuming it
Have another authorized collaborator keep the base sheet open while you apply your view. Ask them to confirm that they can still see their own chosen rows. Do this with synthetic data so the test does not disrupt anyone’s work.
Do not edit a real order just to demonstrate a private view. The view isolates the filtering experience; it is not a sandbox for changing source records. Changing a product, amount or status edits the shared data.
Close the view using Close at the top right. Then use Data → Change view to reopen your named view. Only one filter view can be active for you at a time. If you have view-only access, expect the temporary view to disappear rather than persist as an editor-owned saved view. View lifecycle and access
3. Share a useful view without changing access
With the intended filter view applied, copy the browser URL. Send it only through your normal approved sharing process to an already-authorized colleague. A view link identifies the chosen view; it is not a reason to expand the file’s audience.
For a second exercise, create a North/Open view. Expected orders are 1004 and 1006; their amounts total 165. Naming views by region and purpose makes the list easier to revisit than names such as Filter 1.
When a shared filter or permanent sort is appropriate
If everyone should intentionally open the same filtered dataset, use Data → Create a filter on the complete range. For the practice data, filtering East and Open should show the same two records, but it is a shared filter. Remove it when that shared purpose ends.
For a deliberate rearrangement of the source, select A1:E7, then Data → Sort range → Advanced range sorting options. Enable Data has header row, sort Region ascending, then Amount descending. Expected order IDs: 1003, 1001, 1004, 1006, 1005, 1002. Include every record column so products and amounts move together. Avoid this source-reordering exercise in a live shared sheet without agreement.
Troubleshooting
- Coworkers see your filtering: Confirm you created a filter view, not a normal filter. Close the view before comparing the base sheet.
- A new order never appears: Inspect whether the selected view range includes the new row. Test by adding
1007,East,Mouse,40,Opento the practice data; after including it, the East/Open result should contain three records totaling 320. - No rows remain: Remove one criterion at a time. East plus Closed intentionally produces no records in this sample.
- The command is unavailable: Check access and the selected data layout. Investigate merged cells or other sheet features in a copy before removing useful formatting or validation rules from the original.
- A sort mixes up products: Undo immediately if you sorted only one column. Compare the order IDs with the original sample before proceeding.
Related functions and evidence
Use FILTER when you need a separate formula-produced output, and SORT when that output needs an order. A filter view is the better fit here because the aim is navigating the same shared list.
Testing disclosure: Documentation reviewed October 16, 2026; sample filtering, sorting and totals independently calculated. This tutorial has not been tested in Google Sheets, including simultaneous collaborator behavior. No application screenshot is claimed.