1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Data for Excel 2007 Pivot Table Tutorial

How to Copy the Pivot Table Data into an Excel Worksheet

By

Excel 2007 Pivot Table Tutorial

Excel 2007 Pivot Table Tutorial

© Ted French

Use Copy and Paste Special to Transfer Tutorial Data to an Excel 2007 Worksheet.

Note: - This article gives instructions for copying the sample data shown below into an Excel worksheet. The data accompanies the Step by Step Excel 2007 Pivot Table Tutorial.

  1. Drag select the data in the table below to highlight it. Be sure to select from the title "Cookie Sales by Region" to the number "$69,496" at the bottom of the table.

  2. Choose Edit > Copy from the menu in your web browser.

  3. Open Excel 2007.

  4. Click on cell A1 in the worksheet to make it the active cell.

  5. Click on the Home tab.

  6. Click on the down arrow below the Paste button on the ribbon to open the drop down menu.

  7. Choose Paste Special from the menu to open the Paste Special dialog box.

  8. Choose Paste as Text from the options in the dialog box.

Each piece of data should be pasted into a separate cell in the worksheet. The data should fill the range A1 to D12.

Data for Step by Step Excel 2007 Pivot Table Tutorial

Cookie Sales by Region
SalesRep Region # Orders Total Sales
Bill West 217 $41,107
Frank West 268 $72,707
Harry North 224 $41,676
Janet North 286 $87,858
Joe South 226 $45,606
Martha East 228 $49,017
Mary West 234 $57,967
Ralph East 267 $70,702
Sam East 279 $77,738
Tom South 261 $69,496

©2014 About.com. All rights reserved.