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.
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.
We will give an example on the use of these but let’s try to differentiate slicers versus filters before we get started.
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.
We have created a sample sheet for your convenience. Click here to access the sheet and follow along at home.
Here we have a long list of tasks assignments and their respective due dates.
You will see a dark gray tool appear alongside an editor tab at the right. We will check how to use our widget below.
For our sample, we want to be able to quickly see task assignments per person so we select the “Assigned To” Column.
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
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.
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.
You can adjust the slicer widget and fully customize it to your preference by following these steps:
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.
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.
You can customize the display settings and fonts in the editor in the customize tab.
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.
