| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
any way to copy and paste values from pivot table and keepformatting?
I'd like to copy and values from a pivot table and paste them to a new
workbook in a way where the formatting remains. Does anyone know how to do this? I have excel 2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
any way to copy and paste values from pivot table and keepformatting?
copy pivot table | paste special | click values | ok
On Apr 8, 6:46*am, eggman2001 wrote: I'd like to copy and values from a pivot table and paste them to a new workbook in a way where the formatting remains. Does anyone know how to do this? I have excel 2003. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
any way to copy and paste values from pivot table and keep formatting?
After doing this
copy pivot table | paste special | click values | ok just right-click on the paste & do a paste special | click formats | ok -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
any way to copy and paste values from pivot table and keepformatting?
How do I 'copy pivot table'? Select All | Copy ?
If I do Paste Special in a new workbook, it tries to link the paste back to the original workbook, which I don't want. On Apr 7, 10:27 pm, "Max" wrote: After doing this copy pivot table | paste special | click values | ok just right-click on the paste & do a paste special | click formats | ok -- Max Singaporehttp://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
any way to copy and paste values from pivot table and keep formatting?
Select the pivot/parts thereof*, then click Edit Copy (from the menu
command) to copy, then do the paste special as values & as formats *either manually (for parts) or via right-click inside the pivot Select Entire Table -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "eggman2001" wrote in message ... How do I 'copy pivot table'? Select All | Copy ? If I do Paste Special in a new workbook, it tries to link the paste back to the original workbook, which I don't want. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing pivot table along with a copy and paste for each page fie | Excel Discussion (Misc queries) | |||
| how to copy a pivot table and "paste special" formats in excel 07 | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Pivot table copy and paste | Excel Worksheet Functions | |||
| copy/paste pivot table | Excel Worksheet Functions | |||
Hybrid Mode
