How to display text in Pivot Table using "Wrap Cell Text"

[#1]

Hi,

When I use pivot table to display long text, the mouse over text will be chop off at around 500 char in IE.

In order to overcome this, I increace the value for "Wrap Cell Text" to a bigger number, but this causes all the other cell height to expand also.

And this caused the data in the pivot table to be hard to read and scroll.

Is there any way to make the pivot table behave like the table in MS Excel where the cell height is adjusted automactically?

[Anonymous · Accepted solution]

Unfortunately no, at least as far as I know.

You either have the 1 line cell heightor a set cell height which applies across the board.