In her regular series for Cambridge Network members, software training expert Karen Roem offers handy tips to help you 'Tame your computer'. This week she explains how to exclude data from your pivot table report using Slicers (Microsoft Excel).
Tame your computer - display dynamics
If you have large amounts of information in Excel you probably (read: hopefully) use the powerful table management feature. It can help you to quickly retrieve and manipulate data in numerous ways.
In tip 474 I told you how to filter your data interactively using Slicers, making it faster and more intuitive to display relevant data from your PivotTables and PivotCharts. Once you have created your Slicers, you can simply click on the first field you want to display, and subsequently hold down CTRL to select non-consecutive items or SHIFT for sequential items. But if your table contains a lot of data this can be a time-consuming task.
So why not exclude fields you don’t want to display?
1. Create the slicer, as normal.
2. While holding down the CTRL key select one or more fields you do not want to show.
To clear a filter, right-click anywhere in the Slicer and select Clear Filter. Or click on the Clear Filter button. Or press ALT + C. Find what works for you.
With thanks to Andy for this week’s tip inspiration.
- Filter data in a PivotTable and PivotChart using Slicers
- Quickly format and enable filtering of your data
- Fast filtering
Our current course schedule can be found online. Book more than one person from your organisation on the same course, on the same date, and you get 10% off.