Right-click on a cell in the pivot table, and choose Table Options
Remove the check mark from AutoFormat table
Add a check mark to Preserve formatting
Click OK


summervi wrote:
I apply word wrap on column headings in my pivot table. This expands the
header row to 6 lines high. Then I manually resize the row back to 3 lines
high to conserve space. However, now when I alter the filters on the table,
the pivot table resizes the header back to 6 lines high. How can I lock the
header height? I've managed to do this somehow on some older spreadsheets,
but even when I try to use the format painter to transfer the settings from
sheets that do have a fixed header row height to my new pivot table row, it
still can't keep the row height fixed less than the word wrap wants it to be.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html