In Google Sheets, select your data, choose Data, then Add a slicer, set the column to Category, and use the Filter by values list to tick the categories you want. The sheet, and any pivot table or chart built from the same range, narrows to match. You can add a second slicer for Payment mode and use both at once.
How do I add a slicer?
- Click inside your expense data, or select the whole range including the header row.
- Choose Data, then Add a slicer. A floating box appears on the sheet.
- In the side panel, on the Data tab, check the Data range. If your data has headers, it should include row 1.
- Under Column, choose Category.
- Click the slicer box and open its drop-down. Under Filter by values, untick Select all and then tick just the categories you want, or use Filter by condition for rules such as Text contains.
- Drag the slicer to a spare area of the sheet, away from the data.
What can a slicer filter on?
- Filter by values: tick categories, such as Groceries, Fuel and Dining.
- Filter by condition: for a number column, Greater than 2,000, or Is between; for dates, Date is after or Is before.
- A text column with Text contains, useful for finding one merchant name across many rows.
- Any column in the range, so one slicer can use Mode and another use Month.
Say your log has 120 rows and a hypothetical total of ₹86,400. With the Category slicer set to Groceries, a total formula that sits in the same range may not change by itself, since SUM counts hidden rows too. Use =SUBTOTAL(109,D2:D500) for a total that follows filtered rows. Setting 109 means SUM, ignoring rows hidden by the filter.
Can I use more than one slicer?
Yes. Add a slicer per column you want to control. Each one filters the same range, and the conditions combine, so Category equals Dining and Mode equals Card shows only dining spend by card. If a slicer shows no rows, one of the combinations has no matching entries; clear a slicer to find out which.
| Task | Slicer setting | Result |
|---|---|---|
| Only food | Category filter by values: Groceries, Dining | Food rows only |
| Big payments | Amount filter by condition: Greater than 5,000 | Large rows only |
| One mode | Mode filter by values: UPI | UPI spend only |
| Both | Dining plus Card | Dining paid by card |
How do I add a slicer to a pivot table?
Click inside the pivot table, then choose Data, Add a slicer. Sheets sets the data range to the pivot's source, and the slicer then controls what the pivot shows. If you cannot see the pivot respond, check that the slicer's range is the same range as the pivot's source.
Slicer or Filter view: which suits a shared sheet?
A slicer sits on the sheet, so people can see which filters are active. In a shared sheet, a slicer set by one person may show up for others too, so be sure whoever opens the sheet knows what is filtered. A Filter view, found under Data, Filter views, is saved separately, and it does not change what others see on the main sheet. Use Filter views when several people look at the same log, and slicers for a dashboard you control.
What should I check last?
- Headers are in row 1 and each column has one type of data.
- The slicer's range covers new rows; use a range like A1:E500 or whole columns.
- A SUBTOTAL formula is used for totals that must follow the filter.
- Slicers are placed outside the data so they are not hidden by filtering.
When the log gets long, importing beats typing. SpendixAI takes statements as PDF, CSV or Excel and lets you filter and group transactions in its Report builder, so your sheet slicers become the part you use for personal layouts rather than for everyday cleaning.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

