October 12, 2020

How to Use the Google Sheets Slicer: Filtering Data by Value or Condition

Google Sheet spreadsheet
SECTIONS
  1. Filter by Value
  2. Filter by Condition
  3. Further refining your filters

If you are not yet aware, Google Sheets has a new feature called the Slicer. This will come in handy when you need to see individual entries but have to automatically hide entries that do not fit a certain criterion. To add a Slicer, click Data in the main menu and then click Slicer on the drop-down menu that will appear. 

Data option in menu clicked. A drop-down menu appears. Slicer option highlighted.
Slicer option highlighted.


A small floating widget will appear on the sheet. When you click on the widget, a sidebar will appear on the right side. You have to select the column you will use to filter the data. Click on the drop-down box below the Column label. A list of column labels will appear (corresponding to the column headers you placed). Select one.

Slicer widget floating in the worksheet.Slicer sidebar appearing on the right side of the worksheet.
Slicer widget floating in the worksheet. On the right side of the worksheet, the Slicer sidebar is available.



Filter by Value

For our example, we first selected the date column. When we click on the inverted triangle symbol on the left end of the slicer widget, a drop-down menu will appear, with the Filter by value open by default. 

Slicer. Date column selected. Filter by values.
Filter by values option.


Below the filter by values, a list of existing values under the column appears, with all values checked. If we want to display only entries for June 29, uncheck all the other values and then click Ok

Slicer. Filter by value. Date column selected. All other dates unchecked except for June 29.
All other dates unchecked except for June 29.


The sheet will look like this:

Worksheet listing only entries for June 29. All other entries automatically hidden by the Slicer. 
Worksheet listing only entries for June 29. All other entries automatically hidden by the Slicer. 


Note the jump in numbering from row 46 to row 534. It works even if the rows of the same value do not appear in succession. For example, if we want to list only orders of a 12-egg set, the result will look like this:

Worksheet listing only entries for 12-egg set orders. 
Worksheet listing only entries for 12-egg set orders. The jumps between the rows are more obvious here.

Filter by Condition

More sophisticated filtering can be done if we select Filter by condition instead of Filter by value

Slicer. Filter by condition selected. No condition selected.
Filter by condition selected


The filter by condition allows you to filter strings, dates, and numbers.

Let’s say we want to filter out individual orders less than $60.00. To do so, we first set the selected column to one corresponding to the total price, and then on the slicer widget, we select Filter by condition. Afterward, we click on the drop-down box below the Filter by condition, and look for Greater than or equal to option. A box will appear below it after clicking the option. Type in the number, and then click Ok.

Slicer. Filter by condition selected. Greater than or equal to condition selected. 60.00 set as value.
Greater than or equal to condition selected. 60.00 set as value.


Our sheet will look like this:

Worksheet, only with profit greater than 60 dollars listed.

Further refining your filters

This sounds like an easy job, but that’s because we are dealing with a limited number of filters. Perhaps you need a more powerful data tool that will give you more granular insights...

At this point, we'd be remiss not to bring up our all-in-one data tool, Lido. With a few clicks, you can now access all your relevant business metrics without going through the hassle of finding the data and then slicing every which way to process it. Let our platform do it all for you!

Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.