Resize a Column or Row of a Pivot Table

Adjust the width and height of the columns or rows to better view the data.

By Mouse

  1. Hover over the heading border.

  2. Click and drag the border. A dotted line appears to indicate the pending size.

    Pivot table column border dragged to the left
  3. When the cell is properly sized, release the cursor.

By Menu

  1. Right‐click a heading, and then select Height... or Width...
  2. Set the new Pixel size.
    Sample Resize Column dialog.
  3. Click OK.