How to add FILTER in Google Sheets

0
160

How to add FILTER in Google Sheets: When working on a Google sheets with many rows of data, if you only want to only data that you want to see. That’s where filters come in.

This article focuses on tricky ways to find all the entries for a particular item in Google Sheets.

Filters in Google Sheets allow you to pare down your data to only look at certain rows at one time. Filters enable you to quickly find all the entries for a particular item. This guide is about add FILTER in Google Sheets.

How to add FILTER in Google Sheets

Step 1. Click any single cell/select raws inside a data set.

Step 2. On the Data tab, in the Sort & Filter group, click Filter.

add filter in GOOGLE SHEET
add filter in GOOGLE SHEET

Step 3. Drop-down arrows will appear in the header of each column.

Step 4. Click the drop-down arrow for the column you want to filter.

add filter in GOOGLE SHEET
add filter in GOOGLE SHEET

To remove the filter, on the Data tab, in the Sort & Filter group, click Clear. To remove the filter and the arrows, click Filter.

LEAVE A REPLY

Please enter your comment!
Please enter your name here