Filter dropdowns work fine when you are the only one reading the sheet. The moment someone else has to use your workbook — a manager opening the monthly report, a colleague who has never seen the file — buttons beat menus. Slicers and the timeline panel in RixSheets turn filtering into clicking: a slicer shows the values of one field as pressable buttons, and a timeline gives dates a slide control. Both drive every table or pivot they are connected to.
What slicers solve
Auto filters hide inside column headers; slicers sit on the sheet in plain sight. That changes the experience of using a workbook:
- The filter options are visible without hunting — anyone can see that North, South and West are clickable.
- Selection state is obvious: pressed buttons show exactly what is currently in scope.
- One slicer can drive several pivots at once, so a dashboard of three summaries stays consistent with a single click.
- Mistakes are cheap: clearing a slicer is one button, not a hunt through filter menus trying to remember what was changed.
There is a quieter benefit too: slicers document the sheet. A newcomer who has never seen your workbook can look at two slicers and a timeline and understand instantly what the page answers — which is far more than a wall of filtered rows ever communicates on its own.
Insert and connect a slicer
- Build or select the pivot table you want to filter — slicers are most useful on pivots, and work with tables too.
- Open Insert, Slicer and choose the field whose values deserve buttons. Good candidates are low-cardinality fields: Region, Channel, Status, Product family.
- Place the slicer panel beside your data, sized so every button is readable.
- Click a button to filter to that value; hold the multi-select control to keep several values active at once.
- Click again or use the clear control to remove the filter.
- To synchronize views, connect the same slicer to other pivots sharing the source data — one click now filters them all.
Filter dates with the timeline panel
Dates deserve better than a checkbox list. The timeline panel is built for them:
- Open Insert, Timeline and select the date field from your pivot or table.
- Choose the level that matches the question — years, quarters, months or days.
- Drag the range handles to select a window, such as Q2 through Q3, and the connected pivots narrow instantly.
Because the timeline understands calendar structure, "last two quarters" is a drag, not a formula. Combine one timeline for dates with two or three slicers for categories and you have an interactive dashboard page without writing a single expression.
A small dashboard, assembled
To see how little effort is involved, build the standard layout once:
- Pivot one — revenue by region, placed top left.
- Pivot two — top products by units, top right, same source range.
- Slicer: Region — connected to both pivots.
- Timeline: Date — set to quarters, also connected to both.
- Chart — a column chart on pivot one and a doughnut on pivot two.
- Title row — one merged line saying what the page answers and for whom.
Now every reader — including the ones who will never touch a filter menu — can narrow both summaries to the South region in Q2 with two clicks, and both charts redraw with them. That whole page takes minutes to assemble and none of it breaks when the source data grows, because the pivots refresh from their range and the controls stay connected.
Design tips for interactive sheets
| Tip | Why it helps |
|---|---|
| Limit slicers to two or three fields | Every panel costs screen space and attention |
| Put slicers above or beside the pivot | Readers scan controls before data |
| Label a small dashboard title | A one-line note of what the page answers |
| Use Recommended Charts beside slicers | A visual that reacts to the same filter doubles the impact |
| Group related pivots on one sheet | Shared slicers keep every summary in step |
Slicers versus filters versus Advanced Filter
Use the right tool for the audience. Auto filter is for you, mid-task, on raw data. Slicers and timelines are for other people, or for yourself next month — visible, forgiving, hard to break. Advanced Filter is for complex criteria, such as three conditions joined with AND and OR logic, extracted to a separate location. A reporting workbook typically ends up with advanced filter criteria on a setup sheet and slicers on the dashboard.
Pair with charts and AI
Slicers become far more persuasive when a chart reacts next to them — insert a column or doughnut chart wired to the pivot and every click redraws the picture; see charts in RixSheets. And when you inherit a workbook with slicers you do not recognize, ask the AI chat panel which pivots and fields each slicer controls. The assistant reads the workbook through its tools and answers in plain language, with AI pages unlimited on every plan.
What to explore next
- Pivot tables in RixSheets — the summaries slicers are made for.
- Sort, filter and dedupe — cleaning data before it reaches a dashboard.
- Advanced Filter — criteria-driven filtering for power cases.
- Charts in RixSheets — the visuals that react to every click.