Set the size of a PivotTable list and its elements

Set the size of a PivotTable list

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. On the toolbar, click Commands and Options , and then click the Behavior tab.
  3. Do one of the following:

    Change the height or width of the control

    1. Clear the Auto fit the control check box.
    2. Place the pointer on one of the selection handles of the PivotTable list, and then drag the pointer in the direction you want.

    Automatically resize the control on a Web page to fit its contents

    1. Select the Auto fit the control check box.
    2. If you want to prevent the PivotTable list from expanding beyond a specified size, type a value in pixels in the Maximum height box and/or the Maximum width box.

Note   Scroll bars appear within the PivotTable list when more data is available than will fit in the area.

Change the width of a column in the row, column, detail, or data area

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Point to the right boundary of the field label until the pointer changes to Pointer with perpendicular double-headed arrow.
  3. Do one of the following:

Note   You cannot adjust the height of the rows in a PivotTable list.