Datasheet

Moving and Copying Data
31
Cut and Paste
Excel also offers different ways to cut and paste both single cells and ranges of cells. When you
select multiple cells, the first cell in the selection does not appear to be highlighted. However,
if you look at the Name box to the left of the Formula bar, you will see the name of that cell
in that box. This assures you that that cell is indeed included in the selection.
It is important to note that if you use the right-click method to copy or cut cells and you
right-click outside the cell or cells you want to copy or cut, you will copy or cut the wrong
data, or no data at all. Be sure you right-click in the correct place.
Exercise 1.16 teaches you how to cut and paste, and also shows you how to apply the com-
mands to a range of cells instead of just a single cell.
11. Move to the March Sales sheet and select cell A4 and paste. Note when you paste data
into a cell that already contains data, the new data overwrites the old.
12. Follow the instructions in Exercise 1.14 to save the file (using the Save As command) into
your Chapter One folder, but this time, name the file Exercise 1-16.xls. Leave the file open
for the next exercise.
EXERCISE 1.16
Methods of Cutting and Pasting
1. Still inside the file you worked on in Exercise 1.15, go to the February Sales sheet.
2. Click cell A8, and holding your mouse button down, drag to select cells A8, B8, C8, D8,
and E8. Be sure you are using the white plus sign. You will know you did it correctly if all
five cells are highlighted.
3. With all five cells selected, cut the cells using one of these methods:

Click the Cut button on the Standard toolbar.

Choose Cut from the Edit menu.

Use the keyboard shortcut Ctrl+X to cut it.

Right-click within the selected cell’s area and choose Cut.
4. Right-click cell A7 and choose Paste. The pasted information overwrites what was origi-
nally in row 7. In this case, that is not what we want, so click the Undo button.
5. Click any cell in row 7 and select Insert  Row. This adds a blank row above the Madison
information.
6. Now highlight all the data again (note that it is now in row 9 because you inserted a
new row).
EXERCISE 1.15 (continued)
4002book.fm Page 31 Friday, March 24, 2006 11:36 PM