Microsoft Office Tutorials and References
In Depth Information
Entering Excel Data
The Same Date Is Entered in Every Row
The makers of Excel knew that there are certain
types of data that invariably end up inside a
spreadsheet: months of the year, days of the
week, a series of numbers, and yearly quarters,
such as Q1. They found a way to make it easier,
and frankly more fun, to enter this type of data—
the AutoFill feature.
Follow these steps to use the AutoFill feature in
1. Type the first data item, such as Sunday or
January, into the first cell of your series, and
press Enter to accept the entry and move to
the next cell.
Type Series in Any Order
Preset date formats in Excel 2010.
You do not need to begin your series with the
ﬁrst month of the year, or the ﬁrst day of
the week. Excel will correctly ﬁll the selected
cells regardless of your starting point.
2. Left-click on the fill handle, the small black
box at the lower-right corner of the active
cell, and drag the fill handle across all of the
cells you want to fill. You can drag the mouse
in any direction.
Excel sees dates everywhere. If you are
entering invoice number 01-21, Excel
assumes you meant January 21 and
reformats your number as a date. Refer
to Chapter 5, “Making the Worksheet
Look Good,” to learn how to protect
your data from this reformatting.
3. When you release the mouse button, Excel
fills in the selected cells with a continuation
of your data. Figure 1-14 shows how Excel
fills in the cells with a continuation of the