Quick Guide to Copying PivotTable Data in Excel

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.