Excel Web Sheet Views: Filter Your Work Without Hiding Theirs
Enter a Sheet View before sorting or filtering a shared worksheet. It separates your working view from other people’s sorting and filtering; it does not create a private copy of the cells.
Microsoft offers Excel for the web free. The Excel team’s Sheet View announcement describes its rollout to all web users, and its later web Sheet View link announcement also states all-web-user availability. This guide uses the browser app, not a paid desktop subscription. Those announcements are documentation, not evidence of a live account test.
Before you start
Use a disposable workbook already stored in OneDrive or SharePoint, with permission to edit. A downloaded local copy does not provide the same Sheet View workflow. Microsoft notes that saved views are visible to others with access to the workbook, and cell edits remain shared. Sheet View requirements and behavior.
No invitation or sharing change is needed for the solo exercise. For an optional collaboration check, use only an existing approved workbook and an authorized participant. Do not upload private records or add recipients just to test a view.
Prepare a queue with checkable results
Enter this synthetic block at A1:E7. There is one heading row and six records.
| Ticket | Owner | Status | Hours | Priority |
|---|---|---|---|---|
| Q101 | Ana | Open | 3 | High |
| Q102 | Ben | Open | 5 | Low |
| Q103 | Ana | Closed | 2 | Low |
| Q104 | Cy | Open | 4 | High |
| Q105 | Ana | Open | 1 | Low |
| Q106 | Ben | Closed | 6 | High |
The complete queue contains 6 tickets and 21 hours. Ana’s open work is Q101 and Q105: 2 tickets and 4 hours. These expected sets are calculated from the fixture, not inferred from a screenshot.
Use the table or range’s header filter controls; if the range has none, select A1:E7 and use Data > Filter. Microsoft documents the browser filtering workflow in Filter data in a range or table. Keep all five fields together; a ticket’s hours must not become attached to a different ticket.
Create, name and leave the view
Microsoft’s Sheet View instructions provide this sequence:
- On this worksheet choose View > Sheet View > New.
- Filter Owner to Ana and Status to Open. Within the resulting records, sort Hours largest to smallest.
- Select Temporary View in the Sheet View menu, replace the name with Ana open queue, and press Enter.
- Choose View > Sheet View > Exit to return to Default. Select the saved name from the Sheet View menu when you need it again.
The view menu belongs to the active worksheet. Saved views are not access controls. Hiding rows or columns in Default can affect all views, so this exercise uses filters inside the new view instead. Microsoft’s platform and visibility notes.
Verify content, not just the view’s name
While Ana open queue is active, the two visible tickets should be Q101 then Q105, with hours 3 then 1. Q103 must be absent even though Ana owns it: its status is Closed. Q102 and Q104 are Open but fail the Owner condition. This tests that both criteria are active.
After exiting to Default, verify that the original six tickets are still present, assuming Default had no pre-existing filters. Returning to a previously filtered Default view is not the same as clearing every filter. For this clean fixture, reconcile all six IDs and 21 hours before proceeding.
Reopen Ana open queue and expect Q101 and Q105 again. A view with a correct name but the wrong records has not passed. Check the active sheet, both filter criteria and the Hours sort before changing any source data.
Test a changed record in the practice copy
First exit to Default so you can find every ticket by its ID. Change Q105’s Status from Open to Closed, leaving its Owner and Hours unchanged. Reopen the saved view and reapply its filter if needed. Only Q101 now qualifies, totaling 3 hours.
The complete source still contains 6 tickets and 21 hours: filtering changed which records qualified, not their existence or hours. Restore Q105 to Open in Default, then reopen/reapply the view and expect the original two tickets again.
This is a useful distinction from an immutable report snapshot. A saved view describes how to look at the workbook; it is not a frozen export of the previous values. The Excel team’s web introduction confirms that cell-level edits propagate regardless of the view.
Optional two-person acceptance check
If an authorized collaborator is already available in the same practice workbook, agree on the test before changing anything. Keep your Ana view active while the other person uses a separate view for Ben’s open work. The expected independent results are:
- Your view: Q101 and Q105, 4 hours.
- Their view: Q102, 5 hours.
- Complete underlying queue: all six tickets, 21 hours.
Do not claim collaboration isolation based solely on the solo exercise. Each participant must actually check their visible IDs while the other changes their own sort or filter. If someone’s rows change unexpectedly, stop, confirm both are inside separate Sheet Views rather than Default, and retest on the synthetic file. This guide did not perform a multi-user session.
Troubleshooting and safe cleanup
- Sheet View is missing or unavailable: confirm the browser app, editable workbook and approved cloud location. Do not bypass an organization restriction or buy a desktop license on the assumption that it fixes the underlying file state.
- The saved name disappeared: check the active worksheet and whether you named the temporary view before leaving it. The web introduction distinguishes temporary views from ones saved for reuse.
- A colleague sees your changed value: that is not a failed filter-isolation test. Editing a cell changes the workbook; use a separate disposable file for experiments that must not affect shared data.
- Someone can see your view: expected. Do not put confidential labels in view names or treat hidden records as protected information.
For cleanup, leave the practice view and restore Q105 to Open. Keep the named view if useful. Avoid deleting a saved view in a shared real workbook without checking whether others rely on it.
Related reading: sorting and filtering explains the distinction between record order and visibility, including a separately scoped desktop Advanced Filter section. Comments and collaboration is a desktop-scoped companion, not evidence of browser menu parity.
Documentation checked 23 October 2026. Record membership, sort order and totals were independently checked outside Excel. No sign-in, sharing action, native UI execution or screenshot is claimed.