How do I set the column width in a pivot table ?

[#1]

Hi Everyone,

Is there a way of specifying the exact width of a column in a pivot table. Up until now I've been modifying the width manually by dragging the vertical border. For accuracy, I would like a more exact method of object formatting.

Thanks in anticipation

MV

[MK_QSL · Accepted solution]

Right Click on Pivot Table Column Cell

Fit Columns to Data

[#3]

Many thanks Manish.

It sort of works but it's not as exact as Excel where you can specify the column width and height of rows.

MV