---
title: "Slicers in Google Sheets: How to Add, Use and Save Them"
canonical: "https://www.owox.com/blog/articles/slicers-google-sheets"
updated: "2026-10-05"
---

# Slicers in Google Sheets: how to add, use and save them

A slicer is a filter control that sits on the sheet and filters the tables, pivot tables and charts built on one data range. This guide shows how to add and customize a slicer, how to keep its selection for everyone, how one slicer controls several pivot tables, and how slicers differ from filters and filter views.

[Google Sheets Tips](/blog/topics/google-sheets-tips) · Updated October 2, 2026 · [Vadym Kramarenko](/team/vadym-kramarenko) · 9 min read

![Slicers in Google Sheets: how to add, use and save them](https://cdn.owox.com/www/content-marketing-article/slicers-google-sheets/thumbnail/1-2fs5hy.png/public)

A slicer is a filter control that floats on the sheet. To add one:

1.  Click a cell in your data, a pivot table or a chart.
2.  Click **Data > Add a slicer**.
3.  In the panel on the right, choose the column to filter by.
4.  Click the slicer on the sheet and choose the values to show.

The slicer filters the table, the pivot tables and the charts on that sheet that are built on the same data range.

Four rules, from [Google’s help page on slicers](https://support.google.com/docs/answer/9245556) (checked in October 2026), explain most of the surprises:

*   One slicer filters one column. To filter by two columns, add two slicers.
*   A slicer applies to all charts and pivot tables in the sheet that use the same data set. It does not apply to formulas that read the same range.
*   Several slicers on the same data must have the same data range.
*   A selection is private and is not saved unless you set it as the default.

## Add a slicer step by step

### Step 1: Click inside the data

The example is a sales table with a date, region, salesperson, product, units sold, revenue and month.

![Google Sheets table of sales with the columns Date, Region, Salesperson, Product, Units Sold, Revenue and Month](https://cdn.owox.com/www/webflow/68db9c561482c8f75dd71845_image6.png/public)

### Step 2: Data > add a slicer

![The Data menu in Google Sheets with the Add a slicer item](https://cdn.owox.com/www/webflow/68db9cd84c691d28f09279d4_image22.png/public)

### Step 3: Choose the column

A slicer box appears on the sheet with the text “Select column first”, and the **Slicer** panel opens on the right. Check the data range and pick the column, here Region.

![The Slicer panel in Google Sheets with the data range and the Column list open: Date, Region, Salesperson, Product, Units Sold, Revenue, Month](https://cdn.owox.com/www/webflow/68db9d23cf5c08cc54105935_image14.png/public)

### Step 4: Place the slicer

Drag the slicer to a free spot and resize it by its handles. It shows the column name and “All” while nothing is filtered.

![A Region slicer set to All placed under the sales table in Google Sheets](https://cdn.owox.com/www/webflow/68db9d6e925f1f078e26d3d5_image29.png/public)

### Step 5: Filter

Click the slicer. It offers the same two ways of filtering as a normal filter:

*   **Filter by values:** uncheck the values to hide. **Select all** and **Clear** switch everything on or off.
*   **Filter by condition:** a rule such as “greater than”, “text contains” or “date is after”.

![A Region slicer opened in Google Sheets with only North checked; the table above shows the three North rows and the slicer reads 1 of 4](https://cdn.owox.com/www/webflow/68db9dacb74389874cd51e20_image40.png/public)

With only North checked, the table shows the three rows of that region and the slicer reads “1 of 4”.

## Keep the selection: set it as default

By default a selection is yours alone: other people who open the file do not see it, and it is gone when you close the file. To keep it, open the three-dot menu of the slicer and click **Set current filters as default**. The selection is then saved and applied for everyone who has access to the spreadsheet.

![The three-dot menu of a slicer in Google Sheets with Edit slicer, Copy slicer, Delete slicer and Set current filters as default](https://cdn.owox.com/www/webflow/68db9e40504ecfafaf772f90_image17.png/public)

The same menu holds **Copy slicer** and **Delete slicer**. Selecting the slicer and pressing Delete also removes it. Deleting a slicer does not touch the data.

## Edit and customize a slicer

Choose **Edit slicer** in the three-dot menu. The **Data** tab of the panel holds the data range, the column and the **Apply to pivot tables** checkbox.

![The Data tab of the Slicer panel with a data range, the column Region and the Apply to pivot tables checkbox ticked](https://cdn.owox.com/www/webflow/68db9ed7357ab48d191d0ccd_image7.png/public)

The **Customize** tab holds the title, its font, size, format and color, and the background color of the slicer.

![The Customize tab of the Slicer panel with the title Filter by Region, font settings and an orange background color, and the restyled slicer on the sheet](https://cdn.owox.com/www/webflow/68db9f2d5ab6da8db83c0e91_image13.png/public)

A title that says what the control does (“Filter by Region”) and a color that stands out help readers who did not build the sheet notice that they can filter it.

## One slicer for several pivot tables

A slicer controls every pivot table on the sheet that is built on the same range. Here two pivot tables summarize the sales table: revenue by salesperson and units sold by product.

![A pivot table in Google Sheets with the sum of revenue for four salespeople and a grand total of 465,300](https://cdn.owox.com/www/webflow/68db9fe2593d933c422dc729_image32.png/public)

![A pivot table in Google Sheets with the sum of units sold for Laptop, Smartphone and Tablet and a grand total of 192](https://cdn.owox.com/www/webflow/68db9fcaa9010f9cdcf31f21_image27.png/public)

Click inside one of them, add a slicer and choose the column Month. **Apply to pivot tables** is ticked.

![The Slicer panel with the column Month and the Apply to pivot tables checkbox ticked](https://cdn.owox.com/www/webflow/68dba123357ab48d191ee122_image23.png/public)

Choose January in the slicer:

![A Month slicer opened next to two pivot tables with only January checked](https://cdn.owox.com/www/webflow/68dba160925f1f078e28e644_image20.png/public)

Both pivot tables now show January only.

![Two pivot tables filtered by the Month slicer: revenue of 117,000 for two salespeople and 42 units for two products](https://cdn.owox.com/www/webflow/68dba1b38268d24919d2163f_image16.png/public)

The column in the slicer does not have to be in the pivot table. Month is neither a row nor a value in these two tables, and the slicer still filters them, because it works on the source rows.

If a pivot table does not react, compare its range with the range of the slicer: they have to be the same. A pivot table built on B2:H12 and a slicer on B2:H100 are not connected.

## Two slicers on one pivot table

Each slicer filters one column, and several slicers combine: a row has to pass all of them.

![A sales table in Google Sheets and under it a pivot table of revenue with products in rows and four regions in columns](https://cdn.owox.com/www/webflow/68dba27f593d933c422f3075_image12.png/public)

Add one slicer for Region and one for Product, both on the same data range.

![The Slicer panel with the column Region](https://cdn.owox.com/www/webflow/68db9eb9e92034129476d6f4_image31.png/public)

![A Region slicer opened with only East checked](https://cdn.owox.com/www/webflow/68dba3354c691d28f0958b5f_image33.png/public)

![A Product slicer opened with only Tablet checked](https://cdn.owox.com/www/webflow/68dba380a9010f9cdcf5186b_image4.png/public)

With East and Tablet selected, the pivot table shows the revenue of tablets in the East region only. The same pair of slicers also filters any chart on the sheet that is built on this range, which is how a simple [dashboard](/product/dashboards) is made: a few [charts](/blog/articles/charts-for-visualization-google-sheets) and [pivot tables](/blog/articles/pivot-tables-google-sheets) on one tab, and a row of slicers above them.

## Slicers, filters and filter views

|  | Filter | Filter view | Slicer |
| --- | --- | --- | --- |
| Where it is | In the header row | In the header row, under a saved name | A box on the sheet |
| Who sees the result | Everyone with access | Only you, while the view is applied | Only you, unless set as default |
| Does it stay | Until someone removes or changes it | Saved views can be reopened by anyone with access | Not saved, unless set as default |
| Who can use it | Editing needs edit access | Viewers can create temporary views; saving needs edit access | Anyone with access can adjust it; adding or removing needs edit access |
| What it filters | The rows of the range | The rows of the range | Tables, pivot tables and charts on the same data |

Use a filter when the whole team should see the same rows, a filter view when each person needs their own view of a table, and a slicer when the readers of a report should be able to filter its charts and pivot tables without editing anything. For filtering with a formula, see the [FILTER function](/blog/articles/google-sheets-filter-function).

## Common problems with slicers

**⚠️ Problem:** The slicer does not change a pivot table or a chart.

✅ **Solution:** The slicer and the pivot table or chart use different data ranges, or they are on different tabs. Open **Edit slicer** and make the range the same; put the slicer on the tab where the pivot table is.

**⚠️ Problem:** Formulas next to the pivot table ignore the slicer.

✅ **Solution:** Slicers do not apply to formulas. A SUM over the source range keeps adding all rows. Take totals from the pivot table, which the slicer does filter.

**⚠️ Problem:** The selection is gone after reopening the file, or a colleague sees something else.

✅ **Solution:** Selections are private until saved. Use **Set current filters as default**.

**⚠️ Problem:** New rows are not filtered.

✅ **Solution:** The data range of the slicer ends above them. Extend it in **Edit slicer**, together with the range of the pivot tables.

**⚠️ Problem:** Add a slicer is not available.

✅ **Solution:** Adding or removing a slicer needs edit access. With view access you can still use the slicers that are there.

**⚠️ Problem:** Two slicers contradict each other and the table is empty.

✅ **Solution:** All slicers apply together. Set one of them back to all values.

## Related guides

*   [Pivot tables](/blog/articles/pivot-tables-google-sheets): The tables slicers are most often used with.
*   [Pivot charts](/blog/articles/pivot-charts-google-sheets): Charts built on a pivot table.
*   [Pivots and charts](/blog/articles/pivots-and-charts-in-google-sheets): Combine both in one report.
*   [Charts in Google Sheets](/blog/articles/charts-for-visualization-google-sheets): Chart types and settings.
*   [FILTER function](/blog/articles/google-sheets-filter-function): Filter with a formula.
*   [How to sort data](/blog/articles/how-to-sort-data-google-sheets): Sorting and basic filters.
*   [Data validation](/blog/articles/data-validation-google-sheets): Dropdowns that keep the filtered columns consistent.

## A slicer filters the rows that are in the sheet

A dashboard with slicers looks live: readers click, charts move. It is live only in the sense that it re-filters the rows already in the tab. If those rows were pasted from an export, every reader is slicing the same old snapshot, and the missing months are simply not in the list.

The [OWOX Data Marts extension for Google Sheets](https://workspace.google.com/marketplace/app/owox_data_marts/94902851409) covers that half. A data analyst publishes a data mart (a table or an SQL query in your data warehouse) and makes it available for reports. In Sheets you open the extension, pick the data mart, tick the columns you want and run it. The rows land in a tab, ready for your formulas.

![Google Sheets with the OWOX Data Marts extension open beside an ad spend table: the Unified Ad Spend data mart, nine of fourteen columns ticked and a Save & Run button – the rows in the sheet come from a governed data mart, not a pasted export](https://cdn.owox.com/www/content-marketing-article/slicers-google-sheets/screens/1.png/public)

What changes for the person who maintains the sheet:

*   **Refresh replaces re-export.** _Refresh current report_ in the extension menu re-runs the same pull, and a scheduled refresh keeps the tab current without anyone touching it.
*   **The source is written on the sheet.** The header cell of an imported tab carries a note with the data mart it came from, the time of the import and a link to the report.
*   **No SQL and no warehouse access needed.** The analyst decides which data marts and columns are available. You choose from that list.

The extension does not write or change the analyst’s SQL. Slicers, pivot tables and charts are then built once on that tab and keep working on each refreshed set of rows. The extension comes with the OWOX Cloud plans of [OWOX Data Marts](https://www.owox.com/app-signup); [spreadsheet reporting](/features/spreadsheet-reporting) describes both ways data reaches a sheet.

## FAQ

## Frequently Asked Questions

How do slicers help in data analysis?

Slicers simplify complex data by letting users filter quickly. They help focus on key insights, speed up reporting, and make dashboards easier to navigate and present.

How do I remove a slicer in Google Sheets?

Click the slicer, open its three-dot menu and choose Delete slicer, or select the slicer and press Delete. Removing a slicer does not change your data, pivot tables or charts; it only removes the filter control.

Why is my slicer not working in Google Sheets?

Check three things. The slicer and the pivot table or chart must use exactly the same data range and sit on the same tab. Slicers do not apply to formulas, so a SUM next to the table keeps adding all rows. And a selection is private until you choose Set current filters as default, so colleagues may see unfiltered data. The filtered column does not have to appear in the pivot table.

How do slicers differ from regular filters in Google Sheets?

Slicers are visual and interactive, floating above your data. They don’t change the dataset structure and are ideal for shared dashboards, unlike standard filters embedded in rows.

Can I use multiple slicers in Google Sheets?

Yes, you can add multiple slicers to filter by different fields. Each slicer can control one column, and they work together for layered, interactive filtering.

How do I add a slicer in Google Sheets?

Go to Data > Add a slicer, choose the column you want to filter, and position the slicer on your sheet for easy data interaction.

## Who wrote this

![Vadym Kramarenko](https://cdn.owox.com/www/webflow/6798e703afdf787334941cde_Vadym-Kramarenko.png/public)

[Vadym Kramarenko](/team/vadym-kramarenko) Growth Marketing Manager

Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks.

[LinkedIn](https://www.linkedin.com/in/vadim-kramarenko/) · [All articles](/team/vadym-kramarenko)

[Google Sheets Tips](/blog/topics/google-sheets-tips)

## Related articles

[Google Sheets Tips · UNIQUE Function in Google Sheets: Syntax, Examples and Errors · October 2, 2026](/blog/articles/unique-function-google-sheets)

[Google Sheets Tips · XLOOKUP vs VLOOKUP in Google Sheets: The Key Differences · October 2, 2026](/blog/articles/key-differences-of-xlookup-vs-vlookup)

[Google Sheets Tips · Pivot Tables and Charts in Google Sheets: From a Raw Table to a Report · October 2, 2026](/blog/articles/pivots-and-charts-in-google-sheets)

[See all articles →](/blog/articles)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Google Sheets Tips](https://www.owox.com/blog/topics/google-sheets-tips) — /blog/topics/google-sheets-tips.md
- [Vadym Kramarenko](https://www.owox.com/team/vadym-kramarenko) — /team/vadym-kramarenko.md
- [dashboard](https://www.owox.com/product/dashboards) — /product/dashboards.md
- [charts](https://www.owox.com/blog/articles/charts-for-visualization-google-sheets) — /blog/articles/charts-for-visualization-google-sheets.md
- [pivot tables](https://www.owox.com/blog/articles/pivot-tables-google-sheets) — /blog/articles/pivot-tables-google-sheets.md
- [FILTER function](https://www.owox.com/blog/articles/google-sheets-filter-function) — /blog/articles/google-sheets-filter-function.md
- [Pivot charts](https://www.owox.com/blog/articles/pivot-charts-google-sheets) — /blog/articles/pivot-charts-google-sheets.md
- [Pivots and charts](https://www.owox.com/blog/articles/pivots-and-charts-in-google-sheets) — /blog/articles/pivots-and-charts-in-google-sheets.md
- [How to sort data](https://www.owox.com/blog/articles/how-to-sort-data-google-sheets) — /blog/articles/how-to-sort-data-google-sheets.md
- [Data validation](https://www.owox.com/blog/articles/data-validation-google-sheets) — /blog/articles/data-validation-google-sheets.md
- [OWOX Data Marts](https://www.owox.com/app-signup)
- [spreadsheet reporting](https://www.owox.com/features/spreadsheet-reporting) — /features/spreadsheet-reporting.md
- [Google Sheets Tips · UNIQUE Function in Google Sheets: Syntax, Examples and Errors · October 2, 2026](https://www.owox.com/blog/articles/unique-function-google-sheets) — /blog/articles/unique-function-google-sheets.md
- [Google Sheets Tips · XLOOKUP vs VLOOKUP in Google Sheets: The Key Differences · October 2, 2026](https://www.owox.com/blog/articles/key-differences-of-xlookup-vs-vlookup) — /blog/articles/key-differences-of-xlookup-vs-vlookup.md
- [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md