| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Copy Paste
Hi guys,
I want to copy/paste some data from a pivot table. However, I only want to copy certain "headings", certain lines that are not hidden. When I hit paste, though, all the lines that were hidden show up. I don't want them pasted. Is there a way to get rid of those? Thanks in advance! Joe |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Table Copy Paste
I have not tried this, but Edit/Goto/Special Cells/Visible Cells only should work.
Regards BrianB ================================================= (Matthew Davis) wrote in message . com... Hi guys, I want to copy/paste some data from a pivot table. However, I only want to copy certain "headings", certain lines that are not hidden. When I hit paste, though, all the lines that were hidden show up. I don't want them pasted. Is there a way to get rid of those? Thanks in advance! Joe |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| any way to copy and paste values from pivot table and keepformatting? | Excel Discussion (Misc queries) | |||
| 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) | |||
| Pivot table copy and paste | Excel Worksheet Functions | |||
| copy/paste pivot table | Excel Worksheet Functions | |||
Linear Mode
