Thursday, May 24, 2012

How to Copy a Pivot Table to Another Worksheet


Copy the Worksheet
1. Click on the worksheet that contains the Pivot Table. You can do this easily by clicking the appropriate worksheet tab that appears at the bottom of the Excel window.
2. Right-click the worksheet tab again. A pop-up menu will appear. Choose the 'Move or Copy' option. Another pop-up menu appears.
3. Click the 'Create a copy' check box. Then click once on the existing worksheet in the menu list before which you wish to place the copy of the Pivot Table.
4. Press the 'OK' button. Excel copies the Pivot Table to another worksheet and places the copy in the specified worksheet location.
Copy the Pivot Table
5. Click on the worksheet that contains the Pivot Table you wish to copy.
6. Click once on an empty cell in the upper left of the Pivot Table, just above the Pivot Table data.
7. Drag the mouse down and to the right until you reach an empty cell on the lower right of the Pivot Table.
8. Right-click on the selected Pivot Table cells and choose the 'Copy' option. Alternately, press the 'Ctrl' and 'C' keys on your keyboard to copy the information.
9. Click in the worksheet where you wish to place the copied Pivot Table. Press the 'Ctrl' and 'V' keys, or right-click and choose the 'Paste' command.

Blogger news