Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,118
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Data Source external excel file IH Excel Discussion (Misc queries) 4 November 4th 06 02:42 AM
Count only if another column has data in Pivot Table? [email protected] Excel Worksheet Functions 1 October 10th 06 09:16 PM
Pivot Table external XLS file source change and GETPIVOTDATA refresh mbobro Excel Discussion (Misc queries) 0 July 8th 06 12:45 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"