ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can i "copy" data from a pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/126600-how-can-i-copy-data-pivot-table.html)

hans

How can i "copy" data from a pivot table?
 
I would simply like to 'copy' data from a pivot table!

When i have data in a pivot table and i select part of it (or complete
table) i cannot "copy" this data (to paste somewhere else). When i select
data and right click; "copy" is NOT one of the options i can choose from??

Can someone help me please?
Thanks.

Ron Coderre

How can i "copy" data from a pivot table?
 
Even though the pop-up menu doesn't list the Copy command,
you can still copy the range by using either:

<edit<copy.....from the main menu
OR
Hold down the [Ctrl] key and press [C].....that's the shortcut for
<edit<copy

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"hans" wrote:

I would simply like to 'copy' data from a pivot table!

When i have data in a pivot table and i select part of it (or complete
table) i cannot "copy" this data (to paste somewhere else). When i select
data and right click; "copy" is NOT one of the options i can choose from??

Can someone help me please?
Thanks.



How can i "copy" data from a pivot table?
 
Hi

Try Edit/Copy instead.

Andy.

"hans" wrote in message
...
I would simply like to 'copy' data from a pivot table!

When i have data in a pivot table and i select part of it (or complete
table) i cannot "copy" this data (to paste somewhere else). When i select
data and right click; "copy" is NOT one of the options i can choose from??

Can someone help me please?
Thanks.





All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com