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.
Technology Tips and News
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.
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.