98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables
Pivot Tables
Resolved · Low Priority · Version 2003
Jane has attended:
Excel Advanced course
Pivot Tables
Can you copy and paste certain sections of a created pivot table to another work sheet?
RE: Pivot Tables
Hi Jane
Thanks for the post - and sorry i have not got back to you sooner
there are two ways to paste section to other spreadsheets first you could do a standard copy and paste on the selected data in the pivot table
secondly you can double the data area of the pivot table and youm will get specific data on another sheet, the data may vary so try this a few times and see how you get on
If you need any further help just reply to this post
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move to edge of data blockWhen data is held in a block, however large, use the Ctrl key with your cursors to move quickly to the far edge of the block. Works with all 4 direction keys. |