pivot tables
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Pivot Tables

resolvedResolved · Low Priority · Version 2003

replyReply Wed 5 Nov 2008, 16:12Delegate Jane said...

Jane has attended:
Excel Advanced course

Pivot Tables

Can you copy and paste certain sections of a created pivot table to another work sheet?

For upcoming training course dates see: Pricing & availability

replyReply Tue 11 Nov 2008, 13:34Trainer Mark said...

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

 

Please browse our web site to find out more about
excel+course and other Microsoft training courses.

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard