In this article:

Slicers in Google Sheets - The Ultimate Guide [2024]

May 8, 2024

If you have ever used filters for your Google Sheets workbooks before, slicers are an additional feature that will definitely upgrade your workflow. If you haven’t used either of these tools before, this guide will teach you how to use them in the easiest way possible. 


Before we get to how to use it, let us take a look at what it is.

What is a Slicer in Google Sheets?

A slicer is an interactive toolbar that allows you to sort through your spreadsheet based on specific values and data. You can use them to change visible information in your spreadsheet through the use of an easily accessible widget.

Widget Sample

We will give an example on the use of these but let’s try to differentiate slicers versus filters before we get started.

Google Sheets Slicer vs Filter: What's the Difference?

Both a Slicer and a Filter will perform the same functions and allow you to sift or refine through your data given specified values or conditions. However, you will have to reactivate and deactivate your filters every time you change your conditions.

Shifting between views might also get a little tedious and be less intuitive when there are multiple people using your sheets or when there are several columns you want to categorize through. Slicers can be helpful in these types of cases.

How to Add a Slicer in Google Sheets

We have created a sample sheet for your convenience. Click here to access the sheet and follow along at home.

1. Prepare and Select your data range

Here we have a long list of tasks assignments and their respective due dates.

Data for processing

2. Go to Data in the File Menu and Select “Add A Slicer”

Adding the widget

3. The Slicer tool will appear and should be ready to use!

Successfully adding widget

You will see a dark gray tool appear alongside an editor tab at the right. We will check how to use our widget below.

How to Use Slicer in Google Sheets

1. In the Slicer editor, choose a column you want to filter by

Choosing a Specific Column

For our sample, we want to be able to quickly see task assignments per person so we select the “Assigned To” Column.

2. In the widget, press the All dropdown menu.

Opening Options

The dropdown menu will show the several options you want to filter by. It will also show all unique values in your chosen column. By default, they will all be checked and visible

3. Press Clear to deselect other values

Resetting to null default

4. Select your chosen value

Selecting values

Let’s select Autumn Calhoun to see all tasks assigned to her. You can select multiple options to set them as visible in your workbook.

5. Press OK. 


Now we can only see the tasks for Autumn. You can go back to your widget and select other people or select several people to see them simultaneously. 

How to Edit the Slicer Widget

You can adjust the slicer widget and fully customize it to your preference by following these steps:

1. Click on your widget to select it

Handling bars

This should display a handling box with blue points around your widget. You can use these points to adjust the width and height of your widget.

2. Click the three dots on the right hand side of your widget

Getting to the editing menu

This will open up several options you can use to modify, duplicate or delete your slicer. Here we let us continue to edit our widget.

3. Select Edit Slicer

Options for Widget Adjustment

4. Go to the Customize Tab

You can customize the display settings and fonts in the editor in the customize tab.

Customize Sidebar

After fully adjusting your widget, you can continue to use it for other functions. You can also use this for multiple columns and or values to help you sort through large datasets.

Simply add another slicer assigned to another column. Utilizing this feature will help you create an interactive and intuitive space where you and your teammates can share a Google Sheet efficiently.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->