How to set stable row height on excel pivot table

After creating pivot table and set format as I wish, how can I to set stable row height on excel pivot table.

Whenever data refresh earlier formats of raw height changed. Even set "preserve cell formatting on data update. 

March 6th, 2015 3:15pm

1. Highlight the rows for which you wish to set the row height then:-

Home tab

Cells group

Click on the drop down arrow beneath:-

Format

 - then click on:-

Row Height . . .

The window called:-

Row Height

 - should open.

2. In the window called:-

Row Height

 - enter the number that you want to set the row height to (I set it to 15) then click:-

OK

You should see the row height change.

Save the Workbook.

Close and re-open the Workbook.

3. Update your underlying data for the Pivot Table then refresh the Pivot Table.

My Pivot Table row height correctly remained at the 15 I had set it to.

Free Windows Admin Tool Kit Click here and download it now
March 7th, 2015 10:05am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics