Datasheet

Moving and Copying Data

other formatting attached to the cells. Column widths must be pasted separately. After you

have pasted the data, you will have to leave the range selected and choose Edit  Paste Special,

then select Column Widths in the Paste Special dialog box that opens.

FIGURE 1.8 This is an example of a noncontiguous selection of cells and ranges.

Exercise 1.17 will show you how to select contiguous ranges and move, copy, paste, and

delete them.

EXERCISE 1.17

Selecting Contiguous Ranges

1. Open the file Exercise 1-16.xls that you saved at the end of the last exercise. (If you did

not save this file, extract it from the zipped file for this chapter.)

2. Move to the March Sales sheet.

3. Click cell A3. Be sure your mouse pointer is the white cross, and hold your mouse button

down and drag to select the range A3:A12.

4. Using one of the copy methods described in Exercise 1.15, copy the range.

5. Move to the 1st Qtr Sales sheet. Click cell A3 and use one of the paste methods described

in Exercise 1.15 to paste the data.

6. Move back to the March Sales sheet. You’ll notice the marquee moving around the range

you copied. Do not bother to press Esc to remove the marquee. Simply highlight the

range B3:E3 and copy that.

7. Move to the 1st Qtr Sales sheet; click cell B3 and paste.

8. With the pasted range still selected, choose Edit  Paste Special and select Column

Widths. Then click OK. Now your columns adjust to the same widths as the columns that

held the data you copied.

9. Move back to the March Sales sheet, highlight the range A12:E12, and cut it.

10. Move to the April Sales sheet, click cell A12, and paste.

4002book.fm Page 33 Friday, March 24, 2006 11:36 PM