http://blogs.office.com/b/microsoft-excel/archive/2012/05/14/changing-column-widths-in-pivot-tables.aspxWho could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way. In this first one, she shows us how toen-USTelligent Community 1.5.134.15456 (Build: 5.5.134.15456)http://blogs.office.com/b/microsoft-excel/archive/2012/05/14/changing-column-widths-in-pivot-tables.aspx#31349Mon, 28 May 2012 03:35:20 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31349Jaiveer<p>Found. It works for 2007 also.</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=31349" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2012/05/14/changing-column-widths-in-pivot-tables.aspx#31234Thu, 10 May 2012 19:12:02 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31234Lindsay Hughes<p>This should be the default setting, or there should be some way to enable this as the default setting. &nbsp;I have to do this everytime I make a pivot table (which can be a dozen times a day in some projects)</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=31234" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2012/05/14/changing-column-widths-in-pivot-tables.aspx#31225Wed, 09 May 2012 18:07:25 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31225Stacey Armstrong<p>Thanks for the comment Joao. Yes, I&#39;m always looking for ways to save time. </p> <p>Stacey Armstrong</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=31225" width="1" height="1">http://blogs.office.com/b/microsoft-excel/archive/2012/05/14/changing-column-widths-in-pivot-tables.aspx#31221Wed, 09 May 2012 12:54:45 GMT53587256-c606-4c9b-bad4-97c86b12ce62:31221jpgpinto<p>Nice article Stacey. It&#39;s one of those options that people don&#39;t look up on the dialog boxes that open and keep adjusting the width of the columns without knowing that there is already an option for that in Excel. Regards. jppinto</p> <div style="clear:both;"></div><img src="http://blogs.office.com/aggbug.aspx?PostID=31221" width="1" height="1">