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
Rebecca has attended:
Excel Advanced course
Pivot tables
how can i build one larger table off smaller pivot tables?
RE: Pivot tables
Dear Rebecca
Thank you for attending Excel Adv. course. I hope it was beneficial to you.
The question you have asked is quite interesting one. Normally Pivot tables are created for summarizing large tables.
I can understand that you might want to summarize information and then gather that information into another table. Normally you can simply copy and paste the data in the pivot table by using Paste Special.
To do this you'd select and Copy the data in the pivot table that you want to copy.
Click on the sheet the data needs to be pasted. Choose Edit Paste Special... (or you can get this option by right-Clicking as well)
Choose values and press OK.
If you want the Formatting (Appearance) to be pasted then without de-selecting any values choose Edit Paste Special and select Format and then OK.
You can repeat this step as many times as you want until you get the desired results.
There is alternative method and that is to double click on the heading of the columns of the pivot table. It will automatically copy and past the result in a separate sheet for you.
Unfortunately it always copies it to another sheet so therefore you'll have to cut and paste the data afterwards.
I hope this has answered your question. If it has then I'd request you to please mark this post as resolved. If you need further clarification then please reply back to this post and I should be able to provide detailed clarification.
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
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:The dual nature of toolbar buttonsMany toolbar buttons are dual purpose, though the two purposes are often linked in some way. For example, Align Left aligns a cell's contents to the left of the cell. However, hold down Shift and press the Align Left button: Excel aligns the cell contents to the right. |