In this tutorial, we’ll explain how to use a slicer in Google Sheets. We’ll also explain what a Google Sheets slicer is.
You may have seen a tool called Slicer while browsing menus in Google Sheets. This useful tool allows you to filter the tables, charts and Pivot Tables of your spreadsheet. We will show you how to use it in this article.
Slicers are a very useful feature of Google Sheets. This increases the power of Pivot Tables and Pivot Charts in Google Sheets.
Also read: How to Freeze Rows or Columns in Google Sheets
With Slicers, you can analyze your data more interactively. You can create really stunning looking and interactive reports and dashboards right inside your Google Sheets worksheets.
- What is a Cutter?
- How to create and use a Slicer in Google Sheets
- Editing and customizing Slicers
What is a Cutter?
Slicer is a Google Sheets tool that lets you filter tables, pivot tables, and charts quickly and easily with just a click/drag of a button.
This feature floats on top of your grid and is not bound to any cells, so you can easily move it around your window, align it, and position it however you like.
Slicers are called as such, because they truncate your data, similar to filters, to provide you with customized data analytics. However, it is better than filters because it is much more visually appealing and user-friendly.
How to Create and Use Slicers in Google Sheets
Now that we understand what a slicer is, let’s now create and use this cool feature of Google Sheets. Here’s how to create and use a Slicer in Google Sheets:
1. Select the chart or table where you want to apply the slicer. As an example, we will use a pie chart so that you can see how easy the data is to filter. Open the menu and click Data > Add Slicer.
2. You will then see the cropping tool which looks like a floating toolbar. You can move it wherever you like in your sheet.
3. Then, select the column to filter in the sidebar that is displayed. If you don’t see the sidebar, double click Slicer to open it.
4. You will see the column labels for the data you are using in the Column drop-down list. Select one and you will see it displayed in the cropper.
5. Click the filter icon or the drop-down arrow on the slicer to apply the filter to the column. You will see that you can filter by conditions, such as text containing keywords or values that are greater than a certain number. You can also filter by value by deselecting the values you don’t want, leaving the values you want to be marked.
6. Click “OK” to apply the filter and you will immediately see the data and chart or table updated. You can also see the number of filtered items on the slicer itself.
7. Return to this place to change or remove filters as needed.
Also read: How to Insert Images Into Cells In Google Sheets
Editing and Customizing Slicers
You can change your data set, filter column or view of your slicer. Here’s how to edit or customize a slicer:
1. Select the Slicer tool, click the three dots at the top right, and select “Edit Slicer.”
2. This reopens the Slicer sidebar with tabs for Data and Customize. Use the Data tab to customize the range of data or the Columns drop-down to select a different filter column.
3. Use the Customize tab to change the title, font style, size, format, or color, or change the background color.
Points to remember when using slicers in Google Sheets
As a closing note, here are some important points to keep in mind when using slicers in Google Sheets:
- You can connect slicers to more than one table, pivot table, and/or chart.
- You can only have one slicer to filter by one column.
- You can apply multiple slicers to filter one data set according to different columns.
- Slicers apply to all tables and charts on a worksheet, as long as they have the same basic data source.
- Slicer only applies to active sheet
- Slicers do not apply to formulas on sheets.
That’s how to use the Slicer in Google Sheets. I hope this article helped you! Thank you for visiting and don’t forget if you find this article useful, please share it with your friends too.
