Objective 2. Copy Text Using the Fill Handle

1.

In cell C4, type Bill and then on the Formula Bar, click the Enter button . Notice that cell C4 is still the active cell.

The entry is confirmed and cell B4 remains selected. Clicking the Enter button on the Formula Bar confirms your entry in the same manner as pressing or . The difference is that the active cell does not change, which is convenient when you want to continue using the original cell.

2.

Point to the fill handle in cell C4 and then drag downward through cell C7.

The value Bill is duplicated in all the cells and the Auto Fill Options button displays.

3.

Click the Auto Fill Options button arrow to display the menu, and then compare your screen with Figure 2.7.

Figure 2.7.

The default option Copy Cells is selected. Because Excel did not interpret the name to be part of a series, it copiedduplicatedthe value in the selected cells.

4.

In cell C8, type Grace and then on the Formula Bar click the Enter button . Drag the fill handle to the right to F8.

5.

With the range C8:F8 still selected and filled with Grace's name, drag the fill handle in cell F8 down to F9.

You can fill a range of cells by filling a row or column, and then by dragging the fill handle a second time to fill the range.

6.

Using the techniques you have just practiced, fill in the remaining names for the first seven daysMonday through Sunday. Refer to the following table, and then compare your screen with Figure 2.8.

Figure 2.8.

7.

Select the range C4:I9 to select the names for the first week, and then on the Standard toolbar, click the Copy button .

The selection is surrounded by a moving border. The schedule for next week is almost the same as this week, so you can save time by copying and pasting the first week's schedule and then making a few changes.

8.

Scroll to bring columns J through P into view on your screen. Then, click cell J4, and on the Standard toolbar, click the Paste button .

When you paste a range of copied cells, you need not select the entire target rangethe range to which you want to copy the information. Clicking only the upper left cell of the target range before you click Paste will position the pasted cells properly. The moving border surrounding the original range remains until you perform some other action or press .

9.

Click cell M8. Type Sally and then on the Formula Bar, click the Enter button . Drag the fill handle down to M9, and then compare your screen with Figure 2.9.

Figure 2.9.

By typing only a few original cell entries, you were able to fill the worksheet with 84 names. You can see that the AutoFill command assists with your typing. The schedule for This Week and Next Week is complete.

10.

Save your workbook.

[Page 704 (continued)]

Objective 3 Use AutoFormat