When Old Presentations Are Still In Circulation

This past week I heard from a coworker that I had the pleasure of working with before taking the position I currently have. We've crossed paths a few times at various work events, and usually, when he's calling me it's because assistance is needed with the student assessment system we use. However, this time, it was because another fellow co-worker shared a slide deck from a presentation two-plus years ago and while he hadn't attended that particular tech session he tried his best to follow along with my slide deck. Of all things, it's one of my favorites within Google Sheets, Filter Views.

The issue he was having? He was composing his own student data for his classroom and was keeping his total students tested for that week at the top but wanted to be able to filter the students listed below those totals based on certain criteria. After some troubleshooting as he was getting an error saying that he couldn't filter because of cells being merged, I helped him set up his filters beginning on row three, instead of the common row one. I'll be honest, I had forgotten that you can place multiple filters throughout your spreadsheet if you need to. So, if you're like my co-worker and want your totals at the top and frozen, you can still filter. Thanks for testing my memory Jonathan.

If you'd like to see how easy it is to add filters that are not in the top row, I invite you to watch the two-minute tutorial below. Until next time.