Filtering: Finding the Rows That Matter

Lesson 4 · taught by Pip

Sorting puts every row in order. Filtering does something different and just as useful: it temporarily hides the rows you don't care about, so only the ones you do are left in view. Your data stays whole underneath — nothing is deleted — you've simply pulled a curtain across the rest.

Think of a colander draining pasta. The water rushes through the holes; the pasta stays. A filter on your sheet works the same way: it lets the rows you don't want fall out of sight and keeps the ones you asked for. Lift the filter, and everything pours back.

What filtering answers

Filtering answers "show me only the ones that...". You set a condition, and the sheet displays just the rows that meet it.

Show me only sales from March. Only customers in California. Only orders over $100. Only the rows where the status says "unpaid." Out of a thousand rows, a filter can leave you looking at the seven that actually matter right now. That focus is the whole point — you can't think clearly about a thousand rows, but seven you can hold in your head.

Turning on a filter

Nearly every spreadsheet has a Filter button, usually near a little funnel icon. Click into your table, turn on filtering, and a small dropdown arrow appears at the top of each column.

That arrow is your control. Click it, and the spreadsheet offers you choices for that column — a list of every value to tick or untick, plus options to filter by number range, by date, or by a text search. Pick your condition, and the matching rows stay while the rest tuck away. The row numbers down the side will jump (1, 4, 9...) — that's your clue that rows are hidden in between, not gone.

The kinds of conditions

Filters come in a few flavors, each suited to a kind of column.

By category (a list of choices). For a text column like "City" or "Status," the filter shows every distinct value. Untick the ones you don't want — leave only "California," only "unpaid."

By number range. For a number column, you can ask for "greater than 100," "between 50 and 200," "less than 10." Now you're looking at only your big orders, or only your small ones.

By date. For a date column, filter to a month, a year, or "after January 1st." This is how you isolate one season or one quarter from a sheet that spans years.

By text search. Type a word, and the filter keeps only rows that contain it — every row mentioning "refund," say. Handy when you don't know the exact value, just a piece of it.

You can stack filters across several columns at once. Filter City to "California" and Amount to "over $100," and you see only large California orders — two curtains drawn at the same time.

A gentle warning

A filter only hides rows; it doesn't change them. That's usually a relief, but remember it cuts both ways. If you copy a filtered view to paste elsewhere, most tools copy only the visible rows — good when you want exactly the filtered set, surprising if you forgot the filter was on. When in doubt, clear the filter and confirm the full sheet is back before you do anything drastic.

Why this matters

Real data is mostly rows you don't need at this moment. Filtering is how you cut through the crowd to the handful that answers today's question — without losing or harming the rest. Combined with sorting, it's the everyday toolkit for exploring a sheet before you ever summarize or chart it.

Your turn

Open a sheet with a few hundred rows if you can:

1. Turn on Filter and click a column's dropdown arrow.
2. Filter a text column to a single category — show only one city, one status, one type.
3. Add a second filter on a number column, like "greater than" some amount. Notice how few rows remain.
4. Clear all filters and watch the full sheet return. Nothing was lost.

Next, we'll start turning those rows into single, summary numbers with formulas.