Filtering to find just what you're looking for
Okay sooo. Last lesson we sorted our tracking sheet without scrambling it, which, if you're the person Casey is in my house, felt like a real accomplishment. Sorting's great when you want to see everything in a new order. But sometimes you don't want everything. You just want the piece that matters right now.
That's what filtering is for. Sorting rearranges the whole table. Filtering hides the rows you don't need and shows you only the ones that match something specific. Same data underneath, you're just choosing what to look at.
Why this actually matters
Here's the thing. A tracking sheet is only useful if you can find what you're looking for in it fast. If you've got three months of entries and you need to know "how much did I spend at Costco in October," scrolling through the whole list with your eyes is how mistakes happen, and it's slow, and you'll stop doing it. Filtering gets you there in about ten seconds.
This connects to an opinion I keep coming back to. Most people don't have a spreadsheet problem, they have a question problem. You need to know what you're actually asking before you go clicking buttons. "I want to see everything from the pharmacy this year." "I want to see anything over $100." "I want just Tuesdays." Know the question first. Then filter to it.
How to actually filter
In Google Sheets, click any cell in your data, then go to Data > Create a filter. You'll see little triangle icons appear at the top of each column. In Excel it's basically the same thing under the Data tab, look for the filter button, same triangle icons show up.
Click the triangle on the column you want to filter by. Say it's your Category column. A little box pops up with checkboxes for every unique value in that column, food, gas, whatever your five categories are. Uncheck everything except the one you want, hit okay, and boom, your sheet only shows those rows. Everything else is still there, just hidden.
To get everything back, click the triangle again and hit "select all," or just clear the filter entirely.
You can also filter by condition instead of a checklist, things like "greater than," "contains this text," "is not empty." That's the one I use for dates a lot, filtering to just this month, or just last week.
A caution that's saved me more than once
Turn autosave on before you start playing with filters, adn honestly before you do anything in a shared sheet. I learned this one the hard way, not with filtering specifically, but close enough it applies.
Dawson, my youngest, spilled apple juice straight onto the keyboard mid-sentence while I was typing out a formula. I lost about twenty minutes of work because autosave was off and I hadn't saved in a while. That was the day I turned autosave on for good and I have not shut up about it since. Filters don't usually destroy your data, they just hide rows, but if you're in there clicking around and rearranging things too, you want the safety net running in the background so a juice spill, a toddler on your lap, or you just closing the tab by accident doesn't cost you anything.
A few things that trip people up
Filtering only searches the column you clicked. If you filter Category to "food" it won't also filter by date at the same time, unless you set a second filter on the date column too. You can stack filters, food AND this month, and it'll show you rows matching both.
Also, filters can make you think data is missing when it's really just hidden. If your totals look weird after filtering, check whether a filter's still on somewhere before you panic. I've done that, stared at a number thinking I broke a formula, and it was just a leftover filter from twenty minutes earlier.
And don't confuse "filter" with "delete." You're not removing anything. It's more like putting reading glasses on that only let you see what you asked for.
Try it
Open your tracking sheet from the last couple lessons. Turn on the filter. Pick one category and filter down to just that. Then try a date filter, just this week or just this month. See how fast you get to the answer compared to scrolling and squinting.
That's the whole skill. It's not fancy. It just answers the question you actually have, which is the point of the whole sheet in the first place.
Before next time
Filter your sheet down to one category and jot down what you spent there. Next lesson we'll use that same idea to start pulling quick totals without retyping a single number.
- C