Data for Excel 2007 SUMIF 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 Excel 2007 SUMIF Function Step by Step Tutorial.

1. Drag select the data in the table below to highlight it. Be sure to select from the title "2010 Regional Cookie Sales" to the number "$57,967" 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 C1 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 C1 to F12.

Note: After pasting the data into the worksheet, if it does not resemble the image in Step 2 of the SUMIF tutorial (if it appears as one line of data in row 1 for example) try the following:

1. Use Excel's UNDO feature to remove the data from the worksheet.


2. Repeat steps 6 to 8 above to paste the data as text into the worksheet.

Data for the Excel 2007 SUMIF Function Step by Step Tutorial