Skip to content

Google Sheets power tips: How to use filters and slicers

If you’re building a large spreadsheet in Google Sheets or need to read one that has a hefty amount of data, it’s helpful to apply filters to it. A filter lets you hide specific data (such as numbers or text) inside a range of cells that you select so that you can see what your spreadsheet looks like without this information. In other words, it filters out the data that you don’t want to see in your spreadsheet.

For example, you can design a filter that shows only cells that have numbers that are 50 or greater inside them, and another filter that shows only cells containing numbers of 30 or less. You could then switch between these two filters to see your spreadsheet in these different ways — and then return to your spreadsheet’s original state with its full cell data.

To read this article in full, please click here

Source:: Computerworld