Forum Discussion
Natalie_Law
Nov 06, 2019Copper Contributor
Pivot table paste with format
While I sorting in pivot table, I can paste value and format to any other sheet.
I tried to paste value and format, it does really work to paste without the sorting feature, but it cannot show the cell background colour.
How can I copy the sorted pivot table with word format and background colour?
Thank you
1 Reply
- JKPieterseSilver ContributorThis has been asked before, please see: https://techcommunity.microsoft.com/t5/Excel/Pasting-Pivot-Table-as-Values-losing-Borders-and-formatting/m-p/160125