I built a quick gift list for my four kids. I included sizes of a few common items that I keep up to date, and made up a few other items to build the sheet for this purpose. It's relatively small and on one page for example sake. but picture this as my master holiday list, all family members included & 4 children's wish lists -oh! how many rows I need each year, the chaos can be overwhelming. Let's introduce Filters.
To enable your filter, highlight your "header" row. Click on your "Sort & Filter" button and then click on "Filter" (highlighted below with arrows). (or use quick key shortcut CTRL+SHIFT+U) when your filters are on, you will notice the drop down arrows on your header row titles.
Below is a list of what you get when you click on those drop down arrows. As long as you have all of your column titles being filtered, you can manipulate what you see w/o messing up the integrity of your data in your rows. (I didnt mention the text filter, I will save that for another Monday)
Now, let's say I was headed to Dick's Sporting Goods. I filtered by the location column, and then sort A-Z on the item column. So as I head through each department I can quickly see what I want to buy, and all the other rows of data are no longer distracting me.
If you have any questions using filters, feel free to email me :) firstname.lastname@example.org. Check back next week for another Monday Night Nerd post.