Pasting Results as Text

Pivot tables can be copied to other applications as plain text. Formatting styles are not retained in this method, but you can edit the table data after you paste it into the target application.

  1. Click a table in the Viewer to select it.
  2. From the menus choose:

    Edit > Copy

  3. Open your word processing application.
  4. From the word processor's menus choose:

    Edit > Paste Special...

  5. Select Unformatted Text in the Paste Special dialog box.
  6. Click OK to paste your results into the current document.
Figure 1. Pivot table displayed in Word
The Marital status table in plain text format in Microsoft Word.

Each column of the table is separated by tabs. You can change the column widths by adjusting the tab stops in your word processing application.

Next