Microsoft Office Tutorials and References
In Depth Information
Relocating the Data: Copying and Moving
shown in Figure 2–28, not to be confused with the black double-arrow variety you generate when you
widen columns:
Figure 2–28. The fill handle
When that cross appears, click and hold the mouse button down. Drag as far as you wish, either
across a row or down a column, depending on the direction in which you want to copy. Release the
mouse when you’ve dragged the desired distance; you’ll see the original number has been copied down
or across the range you’ve dragged. You’ll also doubtless take note of the caption that escorts you
down/across the range as you drag; it tells you what value will appear in each cell in the copied-to,
destination range as you drag. But because, in this case, you’re simply copying the same number to each
cell again and again, you may think that the caption tells you something you already know—and you’re
right—this time.
We’ve just demonstrated an application of what’s called Auto-fill, a device that can serve you most
productively once you learn its capabilities. And that square dimple we dragged is called the fill handle ,
and you’ll want to handle it with care.
And you’ll notice something else. When you’ve completed dragging, Excel caps the process by
appending to the lower-right corner of the new, copied range what’s called an Auto Fill Options button.
Click it and four selections place themselves at your service. We’ll discuss the first two here, because the
latter two carry out formatting options, which aren’t our concern here. Take a look at Figure 2–29:
Search JabSto ::

Custom Search