Filter Zoho Sheet Without Changing Collaborators' Views

Quick answer: Apply an ordinary filter to work with your own view. Zoho documents user-level filtering that leaves other collaborators’ filters undisturbed. Save a useful set of criteria as a named filter when it should be reusable. Avoid Set as Document Filter unless you intend to change the initial view for first-time openers. Zoho’s filter overview explains these three uses.

A personal view does not make edits private. Use filtering to choose which records you see; use the spreadsheet’s sharing permissions to control access to the file.

Requirements and scope

This is an English-language Zoho Sheet web walkthrough based on official documentation checked on October 16, 2026. The web service is updated continuously; no numbered release is asserted.

Use a synthetic practice file with edit access for creating the data. For the collaboration check, use two different, already authorized user accounts, each in its own session. Two tabs signed into the same account are not a two-user test. If another authorized participant is unavailable, do the single-user steps and leave the collaboration check unverified.

Zoho’s overview says saved named filters are accessible to collaborators including read-only users. It does not establish that every role can create, rename, or delete them. Have an appropriate editor or owner perform management steps when those controls are unavailable.

1. Create the practice order table

In a sheet named Orders, enter these headers and eight synthetic records in A1:E9. Keep Amount numeric, without typed currency symbols.

Row	A: Order	B: Region	C: Product	D: Amount	E: Status
2	1001	East	Cable	120	Open
3	1002	West	Adapter	85	Closed
4	1003	East	Stand	160	Open
5	1004	North	Cable	95	Open
6	1005	West	Hub	140	Closed
7	1006	North	Adapter	70	Open
8	1007	East	Hub	100	Open
9	1008	East	Cable	200	Closed

Before filtering, count eight records and verify that each amount belongs to the intended order. The last two records are deliberate boundary cases: 1007 is exactly 100, and 1008 is above 100 but Closed.

Keep this as one rectangular table with one header row. In a real sheet, first identify the complete record range; a blank row or an unrelated table beside it is a reason to select the boundaries explicitly.

2. Apply your own filter

1. Select A1:E9 and choose Data → Filter.
2. In Region’s filter, retain East.
3. In Status’s filter, retain Open.
4. For Amount, choose Custom Filter and set Is greater than to 100.

These are the web controls described in Create, apply & manage filters. Criteria offered by the dialog depend on the data type.

The expected visible order IDs are 1001 and 1003, with amounts 120 and 160. Check the IDs, not merely a two-row count: an incorrect condition could return two different records.

Why the other East orders disappear:

• 1007 fails the strictly-greater-than test. A value of 100 is not greater than 100.
• 1008 fails Status = Open even though its amount is 200.
• Every West or North order fails Region = East.

The two qualifying amounts total 280, calculated from the original sample. Filtering is not a request to delete the other six records.

3. Verify two independent views

Before either participant changes criteria, have both confirm the same eight-record practice table. Then use this check:

Participant	Action	Expected visible order IDs
User A	Apply East, Open, Amount > 100	1001, 1003
User B	Leave their view unfiltered	All eight IDs
User B	Apply Region = West in their own view	1002, 1005
User A	Recheck their view without changing it	1001, 1003

Ask each participant to read the IDs from their own screen. Do not test by replacing shared cell values: that checks editing, not filter isolation. If User B already had a filter, establish their baseline first rather than mistaking it for a change caused by User A.

If either view unexpectedly follows the other, check the signed-in identities, current criteria, and whether the participants opened the same saved-filter link. Record what actually happened before relying on the feature in a busy shared workbook. The expected isolation follows Zoho’s documentation; this article does not claim an observed two-user test.

4. Save and share the named filter

With User A’s three conditions active:

1. Open the toolbar Filter arrow and select Name This Filter.
2. Enter East open over 100 and confirm with OK. Use a unique name.
3. Reapply it from Named Filters.
4. Copy the resulting address-bar URL and give that filter-specific link to an existing collaborator who needs the same view.

Zoho documents the changed URL in its named-filter instructions. A meaningful name should describe the conditions rather than claim the data is permanently complete or approved.

Have User B open that link and verify 1001 and 1003. This is an intentional choice to see the saved view; it is separate from the earlier isolation check. If access is denied, check the file’s access settings with the owner. Do not make the file public simply to deliver a filtered view. The sharing guide describes file visibility separately from filters.

A named filter is not a private note: Zoho says collaborators can access saved filters. Avoid confidential information in filter names. A filter also does not limit the recipient to the matching records. Do not share a workbook containing data the recipient must not be able to access just because those rows are currently hidden.

5. Clear, manage, and distinguish the document default

Use Clear Filter to remove an active criterion and inspect the full table. Clear the criteria in Region, Amount, and Status before expecting all eight records. Manage Named Filters provides rename, delete, and reorder controls. Check whether colleagues use a saved view before deleting it.

Set as Document Filter sets the initial filter for people opening the spreadsheet for the first time and also affects its published version. It is not documented as forcibly replacing every current user’s active view. During export, Zoho says only the currently visible filter is retained; the other named filters do not accompany the exported file. These limits are in the web filter guide.

For this practice, leave the document default unchanged. If a shared default needs correcting, have the file owner review it deliberately. Clearing a personal criterion is not evidence that a separately configured document default has been removed.

Independent checks with worksheet formulas

Place these formulas in H2:H4, outside A:E. They check the sample’s criteria directly, rather than trying to infer a total from which rows happen to be visible.

Cell	Formula	Expected result
H2	=COUNTIF(B2:B9;"East")	4
H3	=COUNTIFS(B2:B9;"East";E2:E9;"Open")	3
H4	=COUNTIFS(B2:B9;"East";E2:E9;"Open";D2:D9;">100")	2

The narrowing sequence is four East records, three that are also Open, and two that are also above 100. The COUNTIF guide covers a single criterion; the COUNTIFS guide covers the AND combination used here. Syntax was checked against the official COUNTIF and COUNTIFS references. All criteria ranges cover the same eight rows.

Optional: sort the practice data safely

Sorting is a separate operation; the documentation’s personal-filter promise should not be stretched into a promise about private sorting. Use a separate practice copy and clear filters before trying this variation.

Select the complete A2:E9 record block, excluding the header, then use Data → Sort → Custom Sort. Set Region ascending and Amount ascending within Region. Zoho documents that menu in Sort data present in cells.

The independently expected order is 1007, 1001, 1003, 1008, 1006, 1004, 1002, 1005: East first, then North, then West, with amounts increasing inside each region. Keep all five columns in the selection so a quantity or status cannot be detached from its order. If your dialog handles headers separately, confirm the selected row boundaries before applying the sort.

Troubleshooting and platform differences

• Nothing remains visible: Clear each criterion and rebuild one at a time. East alone should produce four IDs.
• 1007 is included: Check whether you selected greater than or equal to instead of greater than.
• 1008 is included: Recheck Status = Open.
• Numeric comparisons are missing: Inspect the Amount values and their actual types; changing display formatting alone is not proof of numeric conversion.
• A newly appended record is missing: Inspect the filter’s saved range. This example uses an explicit A1:E9 range and makes no automatic-expansion promise.
• A shared link shows different records: Check the current underlying data and the saved range/criteria. A reusable filter is not a frozen snapshot.
• A downloaded file lacks your saved views: Refer to the export limitation above; keep reusable views in the Zoho file when that is the requirement.

Zoho has separate Android instructions for named filters. Do not rely on older announcements saying named filters were unavailable on mobile. This article does not verify Android, iOS, Windows, or macOS workflows.

Verification: Documentation checked on October 16, 2026; the sample’s matching rows, counts, total, and sort order were checked independently. Not tested in Zoho Sheet, including collaboration, named-filter sharing, and export.