Zoho Sheet · Tables and references · Beginner
Filter Ordinary Table Records with Slicers in Zoho Sheet
Add a slicer to a regular Zoho Sheet table, compare single and multiple selections, and reconcile visible records without confusing a filter with deletion.
Documentation-qualified; independently checked record subsets; no live slicer execution · Editorial standards
Quick answer
Select a cell in an ordinary table and use Format → Table → Add Slicer. Choose a field such as Region. Use the slicer’s General settings to choose single or multiple selection, and its Clear option to remove the restriction. This targets the original table, not a pivot report. The controls are documented in Zoho’s table slicer help.
Scope and prerequisites
This guide describes the rolling English web editor using official documentation read on 21 October 2026. No numbered web release, mobile parity, account-level availability, or native test is asserted. Use an existing authorized account with a private synthetic workbook. If the documented control is unavailable in your free account, stop and check current help; do not begin a paid trial or assume entitlement from this article.
No sign-in, account change, workbook upload or screenshot was performed for this guide. The expected results below are independent calculations and reader acceptance checks, not observed application results.
Create a six-record table
Create a private workbook named Table-Slicer-Practice, record its editor URL locally, and name the first sheet Orders. Enter this block in A1:D7:
| Order | Region | Status | Amount |
|---|---|---|---|
| R101 | East | Open | 120 |
| R102 | West | Closed | 80 |
| R103 | North | Open | 60 |
| R104 | North | Closed | 40 |
| R105 | East | Closed | 30 |
| R106 | West | Open | 70 |
The complete set contains six distinct order IDs and totals 400. Keep this original list in the article available as your control; do not move it into rows that the slicer might hide.
Select A1:D7, choose Format → Table, pick a style, and confirm A1:D7 in the creation dialog. Check that the four labels are the table headers and all six records belong to the table. The table creation reference describes this process. If table creation is new to you, first complete tables and named ranges.
Do not create a pivot for this exercise. Leave other table filters cleared before adding the slicer so another restriction cannot silently affect the comparisons.
Add Region as the visual control
Select any cell in the table. Choose Format → Table → Add Slicer, select Region and confirm with OK. Zoho also documents an Add Slicer option in the table side pane. Confirm the buttons correspond to East, North and West, not the Status field.
In the slicer’s General settings choose single selection, then choose East. Inspect the visible order IDs before calculating anything: the intended subset is R101 and R105, with amounts 120 and 30, totaling 150.
Choose West instead. In single-selection mode the intended subset is now R102 and R106, also totaling 150. The equal totals deliberately make this a useful test: a total of 150 alone cannot tell you whether the slicer actually changed regions. The order IDs must change too.
If additional IDs remain visible, inspect the active selection mode and existing filters. Do not delete the unwanted rows to force the expected result.
Test multiple selection explicitly
Use Clear in the slicer side pane and verify all six records are available again. In General, enable multiple selection. Select West and North, leaving East unselected.
The expected IDs are R102, R103, R104 and R106. Their independent total is 250, from 80 + 60 + 40 + 70. The missing East records account for the remaining 150, so 250 + 150 reconciles to the original 400.
Do not assume an ordinary SUM formula represents only visible records, and do not replace a formula with the expected total. This exercise checks membership by order ID and sums that listed subset independently. A summary formula that includes filtered-out records is a different test from whether the slicer selected the right records.
Use Clear again and verify all original IDs and amounts. Clear the slicer’s restriction before changing unrelated filters or taking a screenshot for someone else. A visual filter is not an access restriction; someone who can clear it may see the other records.
Make labels readable, then preserve the result
The slicer’s Design settings provide header, style, font and button-layout controls. Keep the header meaningful, such as Region, and inspect that all three region labels remain readable. Cosmetic changes should not change the selected records; repeat the West/North membership test if you change the layout.
Finish with the slicer cleared and all six records intact. Wait for the workbook to finish saving, then close and reopen its recorded URL. Select Orders, confirm the same table, and repeat the single-West and multi-West/North checks. These are required reader checks; persistence was not tested by the author.
If you no longer need the control, clear it first, select the slicer itself, and use its side-pane Delete option. Do not select the table’s data range. Reconcile all six records afterward rather than assuming removal of a control proves the data is unchanged.
Troubleshooting
- The buttons show Open and Closed: the slicer uses Status rather than Region. Recreate the control for the intended field; keep the source data intact.
- West still totals 150, but you doubt it changed: compare IDs R102/R106 against East’s R101/R105. Identical totals are not identical records.
- Selecting North replaces West: inspect the single/multiple-selection setting before trying again.
- Clear does not restore six records: another table filter may still apply. Review all restrictions and the actual table source range before treating records as missing.
- A pivot elsewhere does not change: this is an ordinary-table slicer. Do not infer a connection to a separate pivot. Use the separate pivot slicer and timeline guide for that workflow.
Verification limits: Original record counts and subset arithmetic were checked independently. Native UI, free-account feature entitlement, table-slicer persistence, styling and export behavior remain untested. No application screenshot or downloadable template is claimed.