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:
Here’s some additional tricks I like for PivotTables: