Forum Discussion
Pivot Table Data Centering
On my pivot table, I can format to have the data centered in my columns, but once I exit that table it all goes back to un-centered. Is there a command that makes it stay centered. The Worksheet I ...
HelloWTF1,
Yes. This happens because Microsoft Excel resets PivotTable formatting unless you tell it not to.
To keep your data centered, click inside the PivotTable, open PivotTable Options, and enable “Preserve cell formatting on update.” Then apply center alignment again.
Microsoft confirms this behavior and setting here:
https://support.microsoft.com/en-gb/office/pivottable-options-27c02eb7-27de-4b3f-9677-c48e3fe7637b
Once that option is turned on, your centering will remain instead of reverting when you leave or refresh the PivotTable.