- Inserting PivotTable data into Excel only takes seconds
- Tutorial Excel PivotTable Data
- 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:
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.
-
Highlight the data in the table above. Select from headline Cookie sales by region Room $69,496 at the bottom of the table.
-
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).
-
Select cell A1 on a blank Excel sheet to make it active.
-
Go to the tab House .
-
In Group clipboard select drop-down arrow Insert .
-
Select Special insert .
-
In the dialog box Special insert select Text .
-
Select Okay to paste the data into Excel.
-
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.