Tip of the week # 588
4 November 2019

Exclude data from your PivotTable report using Slicers (Microsoft Excel) *

If you have large amounts of information in Excel you probably (read: hopefully) use the powerful table management features. 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

  1. Tip 474: Filter data in a PivotTable and PivotChart using Slicers (tip_474.php)
  2. Tip 429: Quickly format and enable filtering of your data (tip_429.php)
  3. Tip 426: Fast filtering (tip_426.php)


* Unless stated otherwise, these tips were written for Microsoft Office 2010.