Tame your computer - display dynamics


04-11-2019
Roem Tip TIme logo

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).

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?

Here’s how:

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.

 

Related tips

 

Upcoming courses

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.

4 November 2019

Karen Roem offers software training and support through her company Roem Ltd.  Contact her by email (Karen@roem.co.uk) or visit her website at  www.roem.co.uk

 
 

Independent, innovative software training company based in Cambridge. Registered supplier to local companies such as AstraZeneca, University of Cambridge, South Cambridgeshire District Council and NHS England.

Roem Limited