Waffle Bytes

(Part of my administrative assistant series on Google Sheets.) Below is a summary of all the topics covered in Session #5 of the series I have been doing for support staff.  In this session we covered how to use filters to view needed data.  We also learned about and created filter views, so we could quickly grab data that is needed multiple times and keep the main spreadsheet with all viewable data.  Session 5 - Intermediate Formulas (December 13, 2017) How to Use Filters Filter Views

Today I open a spreadsheet, and notice that there is a new icon if you have your filtering turned on.  Instead of the blue down arrow: Now there is an icon of 3 green graduated lines: This inverts into a green box with white lines when that column is activated: It is much more noticeable now when you have it turned on!

Back in May I showed how to use filters in a spreadsheet to show specific data without deleting it.  If there are several different ways you need to filter data, you can take this one step further and use Filter Views.  Filter Views are saved views of the data using any combination of filters you need.  You can have multiple filter views saved, so anytime you return to the spreadsheet you can apply the filter with a couple clicks.  To set up filter views: 1. Click on the small arrow to the right of the filter icon, and select "Create new filter view" 2. The spreadsheet will gain a dark gray border around the data, and an additional area at the top of that border that displays the filter name and range on the left, and on the right filter settings & "x" to close the filter and return to the full spreadsheet. 3. Set up the filter view to view the data you wish it to display.  In my example, I'm planning future PD for those that struggled with the...