Microsoft Office Tutorials and References
In Depth Information
Using Auto Fill to Speed Up Data Entry
Using Auto Fill to Speed Up Data Entry
By now you may have taken notice of the small rectangle holding down the lower right
corner of the cell pointer. It’s called the fill handle:
Figure 2–25. There it is.
Why is the fill handle so named? It’s because, among other things, you can fill a range
with a collection of sequenced data—but what does that mean?
Copying a Value with Auto Fill
First, if you enter just one value or text item in a cell and drag on that cell’s fill handle,
you’ll copy that item to as many cells as you drag. Thus if I enter 2 in a cell, click back
into that cell and drag on the fill handle down its column, I’ll copy the 2 into as many
cells as I want:
Figure 2–26. One way to use the fill handle: to copy a value
Auto Filling a Numeric Sequence
To see what I mean:
1.
Type the values 1 and 2 anywhere in a column in adjacent rows.
2.
Then select those two cells and release your mouse—an important step
in an auto fill, which is what we’re about to do:
 
 
Search JabSto ::




Custom Search