Data for Excel 2007 Pivot Table Tutorial

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