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:

excel-pivottable-tools-options-ribbon-bar-20160816-1

pivottable-options-autofit-column-width-20160816-2

Here’s some additional tricks I like for PivotTables:

pivottable-options-refresh-data-20160816-3

pivottable-options-sort-data-20160816-4

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s