Pasting Pivot Table as Values... losing Borders and formatting

This just started within the last 30 days or so... it appears that when pasting a Pivot Table as values over itself... borders and formatting are now eliminated. Extremely frustrating as I have the ...

excel

Formulas and Functions

PivotTable

Haytham Amairah
Feb 17, 2018
Hi Brian,

There is a fairly good technique to paste the PivotTable values and formats, but it cost you some extra steps!

You can use the Format Painter to grab the format to the second instance of the PivotTable.

After you paste the PivotTable as values, go to the original PivotTable, highlight it, press Format Painter button, and then paint the second PivotTable!

Another method (Two levels Paste):

Highlight the first PivotTable and copy it.

Go to another location, and press Ctrl+Alt+V to open the Paste Special dialog box.

Select Values and then hit OK.

Press Ctrl+Alt+V again.

Select Formats and then hit OK again!

Haytham Amairah

Silver Contributor

Feb 17, 2018

Hi Brian,

There is a fairly good technique to paste the PivotTable values and formats, but it cost you some extra steps!

You can use the Format Painter to grab the format to the second instance of the PivotTable.

After you paste the PivotTable as values, go to the original PivotTable, highlight it, press Format Painter button, and then paint the second PivotTable!

Another method (Two levels Paste):

Highlight the first PivotTable and copy it.
Go to another location, and press Ctrl+Alt+V to open the Paste Special dialog box.
Select Values and then hit OK.
Press Ctrl+Alt+V again.
Select Formats and then hit OK again!

GaiNafi

Copper Contributor

Apr 03, 2019

OMG you're brilliant !Haytham Amairah Finally my problem is settled using Format Painter. TQVM!

Forum Discussion

Pasting Pivot Table as Values... losing Borders and formatting

Resources