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. H ow can I lock the header height. I have 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.
Bookmarks