Forum Discussion
Pasting Pivot Table as Values... losing Borders and formatting
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!
If you select ONLY the table of the pivot you can copy and paste values with the table formatting.
Select only the header row and the data, if you include the filter row it won't work. If you include a blank row it won't work. if you include a blank column it won't work.
Why this is the only way to get the formatting with the data I have no idea.
- Thank you - this is the only thing that worked for me.
I looked everywhere and tried the previous suggestions without consistent success. Now I know why. Thank you!
glumthrone8 wrote:If you select ONLY the table of the pivot you can copy and paste values with the table formatting.
Select only the header row and the data, if you include the filter row it won't work. If you include a blank row it won't work. if you include a blank column it won't work.
Why this is the only way to get the formatting with the data I have no idea.
glumthrone8 This is the real answer. All the other methods bring the formatting over, but do not bring the cell colors, borders, etc. Glad I scrolled all the way to the bottom to find this. Thanks!
