Solved

How to keep an excel column width fix

Posted on 2014-10-28
3
118 Views
Last Modified: 2014-10-28
Hi,

When I refresh an Excel pivot table, the column width is automatically fit to the contents (auto fit)

I would like to avoid this. I want to keep the width to a specific value.

How can I do it?

Thanks
0
Comment
Question by:Karl001
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40408897
You can set this in the PivotTable options.  Right-click on the PivotTable, select "PivotTable Options..." at the bottom of the shortcut menu.  On the bottom of the first tab (Layout & Format), turn off "Autofit column widths on update"
autofit-Glenn
0
 

Author Closing Comment

by:Karl001
ID: 40408917
Thanks
0
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40408935
You're welcome.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now