In addition to exporting a pivot report, you can select, copy and paste data from the pivot grid into other programs, including Excel and Word.
Selecting Cells
You can select a continuous range of cells, multiple cells that are not within a continuous range and all cells in the data area of any pivot report.
Continuous Range
To select a continuous range of cells, do one of the following:
Click the initial cell, hold the SHIFT key and use the arrow keys to select the range of cells.
Click the initial cell, hold the SHIFT key and click the last cell in the range.
Click the initial cell, hold the left mouse key drag and the cursor over the appropriate cells to select the range of cell
Non-Continuous Cells
To select multiple cells that are not within a continuous range, hold the CTRL key and click the cells, one by one.
All Cells
To select all the cells in the data area, click CTRL+A.
Copying Cell Values to the Clipboard
Copy cell values by selecting the required cells and pressing CTRL+C or CTRL+INS. Then, access the program of your choice (Excel, Word, Notepad, etc.) and use CTRL+V to paste the copied data (You can also right-click your mouse and select Paste from the menu that appears).
