How to Add a Slicer in Google Sheets

A slicer in Google Sheets is a visual filter that controls every pivot table and chart on a worksheet at the same time. Add one, point it at a column, and the whole dashboard filters together with one click.

I build slicers into nearly every shared sheet I hand off to a team. For anyone viewing a dashboard, they’re the cleanest filtering experience Google Sheets offers. For anyone building one, they replace a stack of individual filter views with a single set of controls.

This guide covers the full workflow: adding a slicer, pointing it at the right column, customizing its look, cascading multiple slicers together, and fixing one that isn’t working.

What Is a Slicer in Google Sheets?

A slicer is a floating filter object. You add it through the Data menu, connect it to a range, and point it at a single column from your spreadsheet’s data. Every chart and pivot table on the same worksheet that pulls from that range will update the moment you change the slicer’s selection.

Slicers get their name from the fact that they let you cut into your data and grab a particular slice to view. They work like remote controls for a dashboard. One click, every element responds.

Slicers apply to tables, pivot tables, and charts that sit on the same worksheet as the slicer itself. If a pivot table is on a different tab, even when it sources from the same data, the slicer won’t touch it. Keep your dashboard elements on one sheet if you want them all to respond to the same controls.

When to Use a Slicer

Use a slicer when any of these apply:

• You’re sharing the sheet with clients or coworkers who need to toggle filters on and off without touching the data itself
• You want to apply several filters separately to one dataset
• You’re building a dashboard with pivot tables and charts that should all respond to the same selection
• You need filtering that works for people with view-only access (filter views require edit access to change)

Use a regular filter when you only need to narrow a single range temporarily and no one else is looking at the sheet.

How to Add a Slicer in Google Sheets

The process has three parts:

1. Insert the slicer and connect it to a data range
2. Pick the column the slicer should filter by
3. Customize the look and set filter rules

The walkthrough below uses a sample dataset of 245 food sales records with columns for order date, city, product, category, units, and total sales.

On top of that dataset, the worksheet holds two pivot tables (units sold by product, sales by category) and one bar chart (sales by city). The goal is one slicer that filters all three at once.

Step 1: Insert the Slicer

1. From the top menu, click Data, then Add a slicer.
2. In the Select data range dialog, enter the range that covers your source data. For the sample dataset, that’s Sheet1!A1:G245.
3. Click OK. A rounded rectangle appears on the worksheet.

The slicer is a floating object, not attached to any cell. Drag it to wherever it makes sense on the dashboard.

Step 2: Pick the Column to Filter By

A slicer can only filter by one column at a time. Point it at whichever column header matters most for the dashboard (for this walkthrough, City).

1. Double-click the slicer to open the sidebar on the right.
2. Make sure the Data tab is active.
3. Click the dropdown under Column and pick the column name you want the slicer to control. Select City.

The slicer updates to show City as its title. It’s now wired to the City column and ready to filter every pivot table and chart on the worksheet.

Step 3: Customize the Slicer

The Customize tab of the slicer sidebar handles the look. You can change the title, set a background color, pick a font, and adjust spacing. Clean styling matters on a client-facing dashboard, and color-coding helps when you’re running multiple slicers side by side.

The default title uses the column name, which reads a little flat. Change it to something clearer like Filter by City:

1. Open the Customize tab.
2. Type the new title into the input field.
3. Set the font and background color to match the worksheet’s theme.

How to Apply a Slicer

Once the slicer is wired up, pick what you want to filter on. There are two ways to open the filter menu from the slicer toolbar:

• Click the striped triangle icon on the left side of the slicer (the filter icon)
• Click the dropdown arrow on the right side of the slicer title

Both open the same filter menu, which mirrors the one used by regular Google Sheets filters.

You get two filtering modes:

• Filter by condition. Set filter rules based on a logical test (“text contains,” “date is after,” “greater than,” and so on). Good for rule-based filtering that doesn’t depend on exact values.
• Filter by values. Pick specific available options from the column. Good for filtering to a known set of items.

To show only Boston and New York:

1. Click the filter icon on the slicer.
2. Under Filter by values, click Clear to deselect everything.
3. Check the boxes for Boston and New York.
4. Click OK.

Every pivot table and chart on the worksheet updates immediately. The slicer shows “2 of 4” to indicate current filters.

Save Current Filters as the Default

Slicer filters are personal by default. You can see your selection, but other viewers see the unfiltered dashboard unless you lock in your choice. To save current filters as the default for everyone:

1. Click the three-dot menu on the slicer.
2. Select Set current selection as default.

Now anyone opening the sheet sees the filtered view first. They can still adjust the slicer on their end without affecting what others see, which is the whole reason slicers beat filter views for shared dashboards.

Cascading Multiple Slicers on the Same Data

A slicer handles exactly one column. To filter on a second dimension, add a second slicer. Every slicer tied to the same source data cascades automatically, so filters stack.

To add a second slicer for OrderDate, go through the same Data > Add a slicer process, then point the new slicer at the OrderDate column. Rename it Filter by Order Date in the Customize tab.

To refine the dashboard to only orders placed after June 30, 2020, use Filter by condition:

1. Click the filter icon on the new slicer.
2. Expand Filter by condition.
3. From the dropdown, select Date is after.
4. In the second input, pick exact date.
5. Type 6/30/2020 in the third input.
6. Click OK.

The dashboard now respects both filters at once. Only rows from Boston or New York with order dates after June 30, 2020 feed the pivot tables and chart.

Duplicate or Edit a Slicer

The three-dot menu on any slicer holds the rest of the controls: edit, copy, delete, set defaults, and more.

To duplicate a slicer and point the copy at a different range:

1. Click the three-dot menu on the slicer and select Copy slicer.
2. Press Ctrl+V (or Cmd+V on macOS) to paste, then drag the duplicate into position.
3. Click the three-dot menu on the new slicer and select Edit slicer.
4. In the sidebar, change the data range or the column.

This is the fastest way to build a panel of connected controls for a single dashboard.

How to Delete a Slicer

Click the three-dot menu on the slicer and select Delete slicer. You can also click the slicer once to select it and press Delete on the keyboard.

Slicers vs. Filters vs. Filter Views

Google Sheets has three filter tools, and each one has a specific use case.

The short version: slicers are the right choice for any sheet that will be read by more than one person. Filter views are a power user tool for anyone with edit access who wants to save multiple personal views. Regular filters are for fast one-off work.

A few more specific reasons slicers win for dashboards:

• They’re visual, movable objects. Place them anywhere on the sheet, color-coded and labeled.
• They cascade. Two or more slicers stack their filters together.
• They work for view-only collaborators. A client without edit access can still manipulate the dashboard.
• They can be saved as a template. Set default filters once and every viewer starts from the same state.

For more on the filter function itself, see the FILTER function guide.

What to Do if Your Slicer Isn’t Working

A few common failure modes:

• The slicer was copied from another sheet. When you import a slicer from another file, the range reference usually breaks. Copy over the source data into a new sheet first, then build the slicer fresh against the local range.
• The filter rules are too narrow. Click the filter icon on the left side of the slicer and check what’s selected. A filter that excludes everything shows an empty dashboard.
• There’s a second slicer filtering the same data. Two slicers on the same source cascade automatically. One of them may be cutting out data you want in the view. Check every slicer on the sheet.
• The pivot table or chart sits on a different tab. Slicers only filter elements on their own worksheet. Move everything onto one tab or duplicate the element into the slicer’s sheet.
• The source range doesn’t include all the data. If the range was set to a fixed row count and the data has grown, the slicer won’t see the newer rows. Open the slicer’s edit menu and extend the range.

Frequently Asked Questions

More Google Sheets Dashboarding Guides

• How to Create a Google Sheets Dashboard
• How to Make a Google Sheets Pivot Table
• Google Sheets Charts: A Complete Guide
• The FILTER Function in Google Sheets
• Conditional Formatting for an Entire Row
• How to Make a Funnel Chart in Google Sheets

Once slicers are working on one dashboard, copy the pattern to every shared sheet you hand off. The depth of control a viewer gets from two or three well-placed slicers beats any filter view you can build for them.