Solved

How to keep an excel column width fix

Posted on 2014-10-28
3
131 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA: Conversion $ vs € and vise versa 14 41
Excel - conditional formatting with symbols 4 29
Bar graph 15 42
Filter an Excel list by multiple criteria 6 38
A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

685 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