In this tutorial, you will learn how to use slicer in google sheets.
When you’re working with large datasets in Google Sheets, it can be hard to get the information you’re looking for. Skimming through hundreds of rows to find the info you need is time consuming and doesn’t provide good insights into your data. Fortunately, Google Sheets has a number of different tools for filtering what data you view from a dataset, and one of those tools is Slicers. Slicers work a little differently from regular filter views in that they’re essentially buttons that float on top of the spreadsheet and can be used to control what data makes it into the table.
While slicers may be intimidating to start with, they’re actually quite simple to use once you understand how they work. Read on to learn how to take advantage of this powerful tool in Google Sheets.
Adding a Slicer
The first step to using slicers is to add one to your spreadsheet. Here’s how:
Select the data you want to filter and open the Data menu, then choose Add a Slicer
A floating Slicer element will appear above the cells. Note that you can reposition it as needed by dragging and dropping.
To get started filtering with the slicer, you need to select a column to filter by. Double click on the slicer to open the Slicer Sidebar, then choose a column from the Column dropdown
Now the column is selected, click on the slicer again and then on the word All to open the filtering menu
A list of values in that column will appear with checkboxes beside each to toggle its visibility in the filter. Adjust the filter as desired. The number of entries that will be visible with the current filter will display on the Slicer. Click OK when you’re done
After hitting OK, the filter will be applied to your data and only matching lines will display
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to use slicer in google sheets. Want more? Check out all the Google Sheets Tutorials.