AutoFit Columns in an Excel PivotTable

It's possible to AutoFit Excel PivotTable columns automatically.

Thomas Duff

by Thomas Duff on 8/16/2016

Share this:

Article Details

Date Revised:

Applies to:
Excel, PivotTables

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

Sign in with

Or register

In This Series