SECTION 2
Lesson 2.4 Moving your Data

   

 

 

In this exercise you will copy and paste single and multiple cells.

 

1.

Start Excel 2003 by double clicking the Excel icon or by using the start menu

Start->Programs->Microsoft Office->Microsoft Office 2003

 

 

2.

Click the File menu and choose Open, File->Open, or use the Open button on the standard toolbar.

 

When the Open dialogue box is displayed, browse to your Excel 2003 Practice folder, and select the SimpleSales file.

 

 

Click the Open button to open the worksheet.

 

 

 

 

 

3.

When the SimpleSales worksheet opens, right click on the Expenses label (cell C2) and choose Copy from the drop down menu by clicking on it. You can also make cell C2 the active cell and click the Copy button on the standard toolbar.

 

 

The Expenses cell (C2) should be surrounded by a light and dark flashing border.

When this happens, point and right click on a different cell, like H2, and click Paste on the drop down menu (or use the Paste button on the standard toolbar).

 

 

You should now see the word Expenses in cell H2.

 

 

 

 

4.

Next, display the office clipboard by choosing Edit->Office Clipboard.

Now, select the range C3:C6 by dragging the thick cross pointer down the Expenses column.

 

Right click on any cell in the selected range and click Copy on the drop down menu, or use the Copy button on the standard toolbar. The selected range should now have a light and dark flashing border and it will be copied to the office clipboard.

 

 

 

5.

Next, select another range E3 to E6, and copy it. This range will also be added to the office clipboard. Right click on a destination cell, H3 for example, and then click the show the drop list options by the clipboard item you want to paste. Select paste from the list and the item will be pasted beginning at the cell you specified.

 

 

Or use the Paste button on the standard toolbar.

 

 

 

6.

Next, select another cell (I 3), and follow the same procedure with the other clipboard item.

 

You will now have both selections pasted where you want them.

 

Remember, the office clipboard can hold up to 24 items and can be used to paste to other programs as well.

 

Close Excel by clicking the X (close button) in the upper right corner of the Excel screen. When you see the Save Changes alert, click No, and do not save changes to the file.