|
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.
|
|