In this tutorial we’ll take a look at basic filtering in Excel, but more specifically how to filter by selection. We will also discuss how to do all this without the use of a mouse, utilizing keyboard shortcuts or key tips only.
Tag Archives | Filters
Here is howto get rid of those pesky categories that you’ve eliminated from your data range, but still appear in the PivotTable filter list…..
Here is a clever way to display Yes or No instead of the values for your PivotTable…..
When you filter data in a PivotTable, sometimes your rows or columns will disappear if there is no data. Here is an option that keeps those rows and columns visible…..
Timelines for PivotTables is a great tool that allows you to filter your PivotTable data by time. Let’s see how that works…..
Did you know that your charts will dynamically adjust as you filter the underlying data? Let’s see how…..