AutoFit Columns in an Excel PivotTable
It's possible to AutoFit Excel PivotTable columns automatically.
by Thomas Duff on 8/16/2016
Recently we published a tip on how to AutoFit columns in an Excel spreadsheet.
One of our readers sent us a follow-up question asking if there was a way to automatically AutoFit columns in an Excel PivotTable when you change a data source. Our resident Excel guru, Sandra Mahan, shares how to do that in this tip.
When you’re in the PivotTable Tools Analyze tab, select Options:
Excel PivotTable Tools option in Ribbon Bar
Excel PivotTable option for AutoFit columns
Here's some additional tricks I like for PivotTables:
Excel PivotTable option for refreshing data
Excel PivotTable option for sorting data
Topic: One Minute Office Magic