Microsoft Office Tutorials and References
In Depth Information
EX 172
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
Table 3–2 Options Available on the Auto Fill Options Menu
The Mighty Fill Handle
If you drag the fi ll handle
to the left or up, Excel
will decrement the series
rather than increment
the series. To copy a
word, such as January
or Monday, which Excel
might interpret as the
start of a series, hold
down the CTRL key while
you drag the fi ll handle
to a destination area. If
you drag the fi ll handle
back into the middle of
a cell, Excel erases the
contents.
Auto Fill Option
Description
Copy Cells
Fill destination area with contents using format of source
area. Do not create a series.
Fill Series
Fill destination area with series using format of source
area. This option is the default.
Fill Formatting Only
Fill destination area using format of source area. No content
is copied unless fi ll is series.
Fill Without Formatting
Fill destination area with contents, without the formatting
of source area.
Fill Months
Fill destination area with series of months using format of
source area. Same as Fill Series and shows as an option
only if source area contains a month.
You can use the fi ll handle to create a series longer than the one shown in Figure 3–8.
If you drag the fi ll handle past cell G3 in Step 4, Excel continues to increment the months
and logically will repeat January, February, and so on, if you extend the range far enough
to the right.
You can create several different types of series using the fi ll handle. Table 3–3 illustrates
several examples. Notice in examples 4 through 7, 9, and 11 that, if you use the fi ll handle
to create a series of numbers or nonsequential months, you must enter the fi rst item in the
series in one cell and the second item in the series in an adjacent cell. Next, select both
cells and drag the fi ll handle through the destination area.
Table 3–3 Examples of Series Using the Fill Handle
Example
Contents of Cell(s) Copied Using
the Fill Handle
Next Three Values of
Extended Series
1
2:00
3:00, 4:00, 5:00
2
Qtr3
Qtr4, Qtr1, Qtr2
3
Quarter 1
Quarter 2, Quarter 3, Quarter 4
4
5-Jan, 5-Mar
5-May, 5-Jul, 5-Sep
5
2007, 2008
2009, 2010, 2011
6
1, 2
3, 4, 5
7
430, 410
390, 370, 350
8
Sun
Mon, Tue, Wed
9
Sunday, Tuesday
Thursday, Saturday, Monday
10
4th Section
5th Section, 6th Section, 7th Section
11
211,
214,
217
205,
208
Search JabSto ::




Custom Search