pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

resolvedResolved · 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 courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Move to edge of data block

When 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.

View all Excel hints and tips


Server loaded in 0.09 secs.