(The dialog looks identical to the 2013 version.) Excel 2011 (Mac)Ĭlick anywhere inside the pivot table, and then go to the PivotTable tab (in purple) > Data group > Options (or right-click and choose PivotTable Options). In the PivotTable Options dialog, under the Layout & Format tab, uncheck Autofit column widths on update under Format, then click OK. In the PivotTable Options dialog, under the Layout & Format tab, uncheck Autofit column widths on update under Format, then click OK.Ĭlick anywhere inside the pivot table, and then go to PivotTable Tools > Options tab > PivotTable group (far-left group) > Options (or right-click and choose PivotTable Options). Here’s how to fix it: Excel 2013 (PC)Ĭlick anywhere inside the pivot table, and then go to PIVOTTABLE TOOLS > Analyze tab > PivotTable group (far-left group) > Options (or right-click and choose PivotTable Options). This can quickly become an exercise in frustration because each time you refresh you have to go through and fix all your pivot table column widths. However, every time you add new data or shuffle things around (or anything that causes the pivot table to refresh), your columns will autofit again. So what I generally do is tighten up the column widths to avoid these unsightly double wides.

This can make for insanely wide pivot table columns. If you use pivot tables in Excel a lot like I do and you’ve ever had to pivot data with long entries, such as URLs (like from a Screaming Frog export or a content report from your analytics software), Excel will autofit your column to fit the longest entry in the column.

Excel 2013 create pivot table options