Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Pivot Table-automatic column resizing

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    in pivot tables, when refreshing data, often times the column widths change automatically

    Is there a way to lock the columns, so they don't change, or so that you can only change them manually?

    This may have been covered already, but I can't find it.

    Thanks,
    JonH

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    PivotTable columns are automatically sized to accommodate the maximum of field name lengths, "Grand Total" labels, and data values. If you need to increase the size of columns beyond these requirements you could assign a number format to the data values that "pads" them with spaces (e.g., instead of 0.0 use "bbbbbbbb"0.0 where "b" is a space character). Through trial and error you can find a number format that expands your columns to a uniform size larger than their defaults.

    [ This Message was edited by: Mark W. on 2002-02-20 15:28 ]

    [ This Message was edited by: Mark W. on 2002-02-20 15:29 ]

  3. #3
    Guest

    Default

    Jon,

    Go into the pivot table's Options dialog box and uncheck "AutoFormat Table."


    enjoy

    Bariloche

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Jon,

    You may also find that if you have titles for your pivot table, the columns in the pivot will expand to the width of the title. I had that problem myself, however have solved it by placing the title in an merged cell.

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    THANKS,
    the tip on the autoformat was perfect!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •