Google sheets menu has a Slicer tool on the menu to help you filter pivot tables, charts, or filter tables. The slicer is popular than other filters in Google sheets mainly due to its shortcuts and ease of use. Besides, the slicer can remain as the default settings in your Google Sheets, enabling you to filter your spreadsheet at a glance.
Add the Slicer in Google Sheets.
The steps below will help you apply the slicer on your Google Sheets. This guide will use a pie chart as the best way to see how the data is filtered.
- Highlight or select the table where you want to use the slicer.
- Click “Data” on the menu.
- Select “Slicer” on the drop-down menu.
The slicer will appear as a floating toolbar beside the chart.
You can relocate the entire bar to a place of your convenience on the screen.
- Double click the slicer to open a sidebar.
- Select a column to filter from this sidebar.
Column labels should appear to represent the data you used in the drop-down list.
- Select one of the labels, and it will automatically display on the slicer.
- Click the filter icon to apply a filter to the column.
You can filter the column to only display texts with a particular keyword or value.
- Click the “Ok” button at the bottom of the window to apply the filter.
The data on the chart should update immediately. The slicer also shows you the number of filtered items.
You can repeat the process to clear or change the filter as you wish.
Check out the slicer tool in Google Sheets to conveniently filter your chart or table.