If you are looking at the menu in Google Sheets, you may have seen a tool called Slicer. This simple feature allows you to filter out tables, charts, or pivot tables in your spreadsheet. We’ll show you how to use them.
What is Slicer in Google Sheets?
As mentioned, you can use slicer to filter data. So you may be wondering how this differs from or better than the filters available in Google Sheets.
It’s simple: a slicer can fit on your sheet, and, with simple buttons, you can filter tables or attached charts. This makes the tool ideal for manipulating data at a glance.
If you use filters in Google Sheets, you can’t save them for reuse. Alternatively, you can save the filter view to sheets and reuse it whenever you want.
Related: How to filter in Google Sheets
But with Slicer, you can set a default filter. This means that everyone who has access to the sheet will see the pre-applied filter when they open the sheet. This is a custom dashboard that you have set up for your team.
Add and use slicers in Google Sheets.
Now that you know what a slicer does, let’s take a look at how to add and use it.
Select the chart or table where you want to place the slicer. For our example, we will use a pie chart so you can see how easily the data is filtered. Go to the menu and click on Data> Slicer.
You will then see a slicer that looks like a floating toolbar. You can move it anywhere on your sheet.
Then, select a column to filter in the sidebar that appears. If you do not see the sidebar, double click on the slicer to open it.
You should see the column label for the data used in the column dropdown list. Select one and you will see it displayed on the slicer.
Click the drop down arrow on the filter icon or slicer to apply a filter to this column. You’ll find that you can filter by condition, such as text that contains more than a certain amount of keywords or values. You can also filter the values you don’t want by selecting the values you don’t want, leaving out the values you want to mark.
Click “OK” to apply the filter and you will see your data and chart or table update immediately. You can also see the number of filtered items on the slicer itself.
Return to these locations to replace or clean the filter as needed.
Related: How to create a pie chart in Google Sheets
Edit or customize slicer.
You can change the appearance of the dataset, the filter column, or your slicer. Select the slicer, click on the three dots in the upper right, and select “Edit Slicer”.
This slicer reopens the sidebar with tabs for data and customization. Use the Datab tab to adjust the data range or the column dropdown to select different filter columns.
Use the Custom tab to change the title, font style, size, format, or color or background color.
More slicer actions
When you select the slicer and click on the three dots, you will see more actions. You can copy or delete the slicer as well as set the current filter by default.
Additionally, you can add multiple slicers to the same dataset. It allows you to configure multiple filters for different columns of data for your chart or table.
For a quick and easy way to filter your table or chart data and keep the filter visible, check out the Slicer tool in Google Sheets.
If you also use Excel, take a look at how to sort and filter the data!