Quick Guide to Copying PivotTable Data in Excel

Content
  1. Inserting PivotTable data into Excel only takes seconds
  2. Tutorial Excel PivotTable Data
  3. Copy study text

Inserting PivotTable data into Excel only takes seconds

Pivot tables are a powerful feature in Excel. They bring flexibility and analytical capabilities within reach. Pivot tables extract information from large data tables without the use of formulas. When you find the data you want to include in the PivotTable, such as the data in the PivotTable tutorial, copy the sample data into an Excel worksheet.

The instructions in this article apply to Excel 2019, 2016, 2013, 2010; and Excel for Office 365.

Tutorial Excel PivotTable Data

Here’s an example of the data you’ll find in the PivotTable guide:

Cookie sales by region

Representative Region # Orders Total sales
account West 217 $41107
frank West 268 $72707
Harry Northern 224 $41676
Janet Northern 286 $87858
Joe south 226 $45606
Martha East 228 $49017
Maria West 234 $57967
Ralph East 267 $70702
sam East 279 $77738
Tom south 261 $69496

Copy study text

Follow the steps below to copy the sample data to your own Excel file. These steps are relevant for any data you want to copy to Excel, not just the specific data shown in the table above.

  1. Highlight the data in the table above. Select from headline Cookie sales by region Room $69,496 at the bottom of the table.

  2. Right-click (or press and hold) any part of the highlighted text and select To copy in the browser context menu.

    Another way to copy data from a table is to use the keyboard shortcut ctrl+c (Windows) or Command+C (Mac).

  3. Select cell A1 on a blank Excel sheet to make it active.

  4. Go to the tab House .

  5. In Group clipboard select drop-down arrow Insert .

  6. Select Special insert .

  7. In the dialog box Special insert select Text .

  8. Select Okay to paste the data into Excel.

  9. Each piece of data is inserted into a separate cell on the worksheet. If cell A1 was the active cell when the data was inserted into the worksheet, that data will appear in the range A1 to D12.

Leave a Reply

Your email address will not be published.