Microsoft Office Tutorials and References
In Depth Information
Using Auto Fill to Speed Up Data Entry
Figure 2–27. Having your fill—selecting the cells
Then glide the mouse directly over the fill handle. You’ll see a slender
Figure 2–28. A new kind of cursor
When you see it, click on it, and drag it down the column for as many
rows as you wish. You should see:
Figure 2–29. Value-added: auto fill at work
Pretty cool, no? What we did is start with just two values, which established a fill
interval—in this case an interval of 1 (the 2 minus the 1). That tells Excel that every
subsequent value will receive an increment of…1.
But you can really stipulate any increment you want. Start by entering say, the values 2
and 5 instead, and you’ll auto fill 8, 11, 14, 17, etc. Enter 1 and 2.78 and you’ll wind up
with additional values of 4.56, 6.34, 8.12, etc.—that is, values pumped by 1.78.
Remember that to execute this kind of auto fill you need to enter the two starting values,
select them and then release your mouse, without dragging. Only then do you return to
the selection and start dragging.