How to Insert and Use Slicers to Filter Data in Google Sheets

When presenting financial summaries, project trackers, or customer rosters to managers or team members, standard spreadsheet filtering can feel clunky. Opening column filter menus, unticking checkboxes, and reapplying conditions interrupts presentation flow. In Google Sheets, you can elevate your spreadsheets into interactive dashboards by utilising Slicers.

Slicers are floating, user-friendly interactive filter buttons that sit directly on top of your worksheet. Clicking a slicer filters tables, pivot tables, and connected charts simultaneously without requiring users to dive into raw data menus.

Step 1: Prepare Your Data Table

Before adding a slicer, ensure your data is organised cleanly:

  • Verify that your data has clear, single-row column headers (e.g. Department, Region, Sales Rep, Status).
  • Remove any merged cells within the data range, as merged rows prevent filters from indexing properly.

Step 2: Insert a Slicer

Adding a slicer to your worksheet is straightforward:

  1. Click anywhere inside your dataset or highlight the specific range of cells.
  2. Navigate to the Data tab on the top menu bar.
  3. Click Add a slicer.
  4. A floating slicer box will appear on your canvas, alongside the Slicer sidebar on the right.
  5. In the sidebar under Data, click the Column drop-down menu and choose the field you wish to filter (for instance, Department or Quarter).

Step 3: Filter Data Interactively

Using the slicer is effortless for anyone viewing the sheet:

  1. Click the Filter icon on your new floating slicer card.
  2. A pop-up menu appears displaying all unique values from that column.
  3. Click Clear to deselect all items, then tick only the specific categories you want to view (such as “Marketing” and “Design”).
  4. Click OK.

Google Sheets will immediately hide unselected rows, dynamically updating connected charts and pivot tables on your screen.

Step 4: Customise Slicer Appearance for Dashboards

To match your corporate theme or dashboard colour scheme:

  1. Click on the slicer card to select it, then click the three-dot vertical menu in its top corner and select Edit slicer.
  2. In the right sidebar, switch to the Customise tab.
  3. Adjust the Title (e.g. “Select Department”), font style, text size, and background colour.
  4. Drag and reposition the slicer tile above or beside your data summaries.

Frequently Asked Questions

Do slicers affect what other collaborators see in real time?

By default, filters applied through slicers apply only to your personal view unless you choose to set the slicer as default for all users. This allows multiple team members to explore different departmental views simultaneously without disrupting each other’s workspace.

Can I connect multiple slicers to the same sheet?

Yes. You can add multiple slicers (such as one for Year, another for Country, and a third for Sales Rep). As you adjust each slicer, Google Sheets combines the filters dynamically to drill down into exact data segments.

Get the best tech tips delivered straight to your inbox.

Join thousands of readers mastering Apple, Google, Microsoft, and Linux.