AutoFit Columns in an Excel PivotTable

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:



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s