Formatting slicers


show more Formatting slicers provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Formatting slicers

Filtering a PivotTable using a slicer helps you and your colleagues visualize which values the filter includes and excludes. You have a lot of control over the slicer's appearance and other characteristics so you can customize it to meet your needs. In this case, I have the Year and Month fields displayed within the slicers, so I can use them to filter my PivotTable. One thing that jumps out immediately is that the slicers aren't visually distinguished from the body of the PivotTable. They are formatted in pretty much the same way. In other words, so they sort of blend in. What I'd like to do is change the style of the slicers so that they stand out a bit more and makes it easier to see which values are included and excluded from the PivotTable.

To change the appearance of the slicer, just click the Slicer. In this case, I'll work with Month and then click the Options contextual tab that appears and then in the Slicer Styles gallery click a new style. To see all the styles ...

Formatting slicers
Video duration: 3m 43s 3h 43m Intermediate

Viewers:

Formatting slicers provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...