+ Reply to Thread
Results 1 to 3 of 3

Stop column width from changing on pivot table....?

  1. #1
    myk
    Guest

    Stop column width from changing on pivot table....?

    Hello All,

    I have a worksheet where I need a column to be 315 pixels wide all the
    time. This column is part of a pivot table. Whenever I change the
    page option though (via the pull-down list), the column that needs to
    stay at 315 pixels shrinks back in size to something smaller. Any
    ideas on how to get it to stay at 315 pixels wide?

    TIA,

    myk


  2. #2
    Rafael Guerreiro Osorio
    Guest

    RE: Stop column width from changing on pivot table....?

    Myk,

    Just uncheck the Autoformat table option, in the Pivot Table Options Page
    (Table Option in context menu)...

    Best,

    RGO

    "myk" wrote:

    > Hello All,
    >
    > I have a worksheet where I need a column to be 315 pixels wide all the
    > time. This column is part of a pivot table. Whenever I change the
    > page option though (via the pull-down list), the column that needs to
    > stay at 315 pixels shrinks back in size to something smaller. Any
    > ideas on how to get it to stay at 315 pixels wide?
    >
    > TIA,
    >
    > myk
    >
    >


  3. #3
    myk
    Guest

    Re: Stop column width from changing on pivot table....?

    perfect - thank you!

    myk


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1