Inside Microsoft Excel

Give your slicers a face lift (2010/2013)

Inside Microsoft Excel

by Kara Hiltz

Excel’s new PivotTable filters, slicers, can give your worksheet a dashboard-like feel. While your slicers have their own tab on the Ribbon that lets you control a great deal about how they look and operate, you might have noticed something missing. There’s no group for adjusting a slicer’s font settings.

Fortunately, you can change a slicer’s font attributes, but you have to use a bit of a workaround. You need to create a new[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)