Microsoft Office Tutorials and References
In Depth Information
Entering Excel Data
Extending a Series with AutoFill
Excel includes a great built-in, time-saving feature
called AutoFill. If you provide Excel the beginning
pattern, such as a month, day, or numbers, Excel
can fill in the rest of the pattern for you. For
example, if you type January, Excel fills in February,
March, April, and so on. AutoFill works with days
of the week, months of the year, or yearly quarters
such as 2nd Qtr. You can enter the entire word or
you can enter the abbreviated form such as Wed or
Sep. The following steps show you how to use the
5. Drag the small black box across the cells you
want to fill. You can drag the cells right, left,
up, or down.
6. Release the mouse. Excel fills in the cells
with a continuation of your data. Figure 8-8
shows how Excel fills in the cells with a
continuation of the months.
Fill the first cell with data (for example, a day
or month, such as Monday or August).
2. Press Enter, which accepts the data entry.
3. Select the cell in which you just entered the
4. Position the mouse pointer on the small
black box at the lower-right corner of the
data cell (fill handle). Your mouse pointer
turns into a small black cross.
Using AutoFill for calendar months.
To AutoFill a series of numbers, enter two
values in two adjacent cells, such as 1 and 2 or
5 and 10. Select both cells, and then use the
AutoFill box to highlight cells. Excel continues
the series as 3, 4, 5, or 5, 10, 15 and so forth.
If you use AutoFill on a text word or a single value,
Excel duplicates it. For example, if you use AutoFill
on a cell with the word Michael, all filled cells