Forum Discussion
Pivot table font size
Dear all, I would like to costumise the font size of each column in my pivot table, but through the pivot table styles menu I am only allowed to make it bold, or italic and so on, while the font ...
I found your question while trying to answer this for myself.
Eventually I figured it out:
- Click any cell in your Pivot Table
- Press Ctrl+A ("select all") which will select the Pivot Table, itself.
- Apply font size/color/etc formatting from the Home Ribbon.
This change will "stick" even after refreshing and changing filter settings.
Also, FYI, the "Normal" Text Style (Home --> Cell Styles --> "Good, Bad, and Neutral") apparently sets the default font for PivotTable contents. But I found it very difficult to use that style to achieve my desired result since it alters most of the rest of my workbook, too.