Datasheet

40
Chapter 1

Navigating in Excel and Understanding the Interface
8. Select cell A1 again and, without holding the mouse button down, move your pointer
over cell Al’s edge until you see the black four-headed arrow. Click with this pointer and
drag the cell over to cell F7. As you drag, the pointer changes to a white diagonal arrow
and a tooltip shows the cell name you are over. When the tooltip shows F7 (see the fol-
lowing graphic), release your mouse button. The number 200 has been moved from A1
to F7.
9. Using the black four-headed arrow again, drag cell F7 until it is over cell F2, but this time
hold the Ctrl key down while you drag. Notice the small plus sign attached to the white
arrow. The plus sign tells you that you are copying the cell instead of moving it.
10. Select the range A2:B4, use the black four-headed arrow to drag it to the range D6:E8, and
drop it. Note that the tooltip shows the range that will be filled instead of just one cell
name.
11. Select the range D6:E8 and Ctrl+drag it to the range A2:B4 and drop a copy of it there.
12. Edit cell A2 so the value is 300 and press Enter. Select A2 again and hover your mouse
pointer over the fill handle of that cell, in the lower-right corner, until you see the black
plus sign.
13. Click with the black plus sign and drag the number 300 down to cell A10. Notice that it
copies 300 to every cell you pass over on your way to A10.
14. You’ll notice the Options button that appears to the lower right of cell A10. Click it to see the
Auto Fill options, such as Copy Cells, Fill Without Formatting, and so forth, as shown here:
15. The default option, when you drag using the fill handle, is to simply copy the cells.
Choose Fill Series, and the numbers will progress in a series from 300 to 308.
EXERCISE 1.20 (continued)
4002book.fm Page 40 Friday, March 24, 2006 11:36 PM