How to Create a Filter in Google Sheets

When you are staring at a massive spreadsheet containing thousands of rows of sales data, employee records, or inventory counts, it is impossible to manually locate specific information. You need a way to temporarily hide the clutter and focus only on the data that matters right now. Google Sheets solves this problem with its powerful “Filter” tool, which allows you to narrow down your view based on specific text, numbers, or even cell colors.

How to Turn On the Filter Tool

Activating a filter takes only a single click.

1. Open your Google Sheets document.
2. Click anywhere inside the data table you want to filter. (You do not need to highlight the entire table; just clicking a single active cell is enough).
3. Look at the toolbar at the top of the screen. Locate the icon that looks like a small funnel.
4. Click the funnel icon.
5. You will notice that the header row of your table (Row 1) has transformed. Every column header now has a small green “Filter” icon (an inverted triangle with three lines) sitting on the right edge of the cell. Your data is now ready to be filtered.

How to Filter Data by Specific Values

Once the filter is active, you can use it to hide specific rows.

1. Decide which column you want to filter by. For example, if you have a “Status” column and only want to see projects marked “Pending,” click the green Filter icon inside the “Status” header cell.
2. A large drop-down menu will appear.
3. Look at the bottom section of the menu. You will see a list of every unique value that exists in that column, with a checkmark next to each one.
4. Click the Clear button. This instantly unchecks every box.
5. Now, click the checkbox next to the specific word you want to see (e.g., “Pending”).
6. Click the green OK button at the bottom of the menu.
7. The spreadsheet will instantly hide every row that does not contain the word “Pending.” The hidden data is not deleted; it is simply folded out of view. You will notice the row numbers on the left side of the screen skip (e.g., Row 1, Row 4, Row 12), proving that rows are hidden.

How to Filter Data by Condition

If you are working with numbers or dates, manually checking boxes for hundreds of different prices is inefficient. You can use conditional logic instead.

1. Click the green Filter icon in your desired column header.
2. In the drop-down menu, click on Filter by condition to expand the options.
3. Click the box that says “None” to reveal a list of mathematical and logical rules.
4. You can select rules like Text contains, Date is before, Greater than, or Is between.
5. For example, choose Greater than and type “500” into the value box.
6. Click OK. The sheet will now only display rows where the number in that specific column is higher than 500.

How to Turn Off the Filter

When you are finished analyzing your data and want to see the entire spreadsheet again, simply look back up at the main toolbar and click the funnel icon a second time. The green triangles will disappear from your headers, and all hidden rows will immediately return to the screen.