Microsoft Office Tutorials and References
In Depth Information
Filling cells and creating data series
Figure 8-22 Create a simple series by dragging the ill handle and then clicking Fill Series on the
Auto Fill Options menu.
INSIDE OUT Create decreasing series
Generally, when you create a series, you drag the ill handle down or to the right, and
the values increase accordingly. You can also create a series of decreasing values by
dragging the ill handle up or to the left. Select the starting values in cells at the
bottom or to the right of the range you want to ill, and then drag the ill handle back
toward the beginning of the range.
If you click Fill Series on the Auto Fill Options menu, Excel creates the simple series 21, 22,
and 23 instead of copying the contents of cell C2. If, instead of selecting a single cell, you
select the range C1:C2 in Figure 8-22 and drag the ill handle down to cell C5, you create a
series that is based on the interval between the two selected values, resulting in the series
30, 40, and 50 in cells C3:C5. If you click Copy Cells on the Auto Fill Options menu, Excel
copies the cells instead of extending the series, repeating the pattern of selected cells as
necessary to ill the range. Instead of filling C3:C5 with the values 30, 40, and 50, choosing
Copy Cells will enter the values 10, 20, and 10 in C3:C5.
If you select a text value and drag the ill handle, Excel copies the text to the cells where
you drag. If, however, the selection contains both text and numeric values, the Auto Fill
feature takes over and extends the numeric component while copying the text component.
You can also extend dates in this way, using a number of date formats, including Qtr 1,
Qtr 2, and so on. If you type text that describes dates, even without numbers (such as
months or days of the week), Excel treats the text as a series.