When building PivotTables we want to permanently set the column widths in the PivotTable, but whenever the filter variables for the PivotTable are changed, the column widths reset themselves. So we wonder how we can permanently fix all column widths in the PivotTable so they don’t change.

This is very easy to do in Excel. After your PivotTable is set up and formatted just the way you want, follow these steps if you are using Excel 2007 or Excel 2010:

1. Select a cell in the PivotTable.
2. Display the Options tab of the ribbon.
3. Click the Options tool in the PivotTable group. Excel displays the PivotTable Options dialog box.
4. Make sure the Layout & Format tab is displayed. (See Figure 1.)

 

powerpivot

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

5. Make sure the Autofit Column Widths on Update check box is cleared.
6. Click OK.

If you are using Excel 2013, follow these steps instead:

1. Select a cell in the PivotTable.
2. Display the Analyze tab of the ribbon.
3. Click the PivotTable tool at the left side of the ribbon. Excel displays some options.
4. Click Options. Excel displays the PivotTable Options dialog box.
5. Make sure the Layout & Format tab is displayed.
6. Make sure the Autofit Column Widths on Update check box is cleared.
7. Click OK.

For more Tips & Tricks follow the link: https://plus.google.com/b/115305456689183…/collection/YeJ9ME

Public Courses delivered in our Amelia ST Office, just opposite the Europa Hotel in Belfast City Centre.
Courses can be Delivered on Your Own Premises with the Following Provided at NO EXTRA CHARGE:
• Up To 10 Laptops
• LCD Projector
• Projector Screen & Flipchart
Click here for more info: https://www.mullantraining.com/
Call, Email or Chat Live with an Account Manager now:
T: +442890322228
E: info@mullantraining.com
W: www.mullantraining.com

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks