|
Excel Tip - Completing a series using
the fill handle
You can
quickly fill in several types of data series by selecting
cells and dragging the fill handle (the black dot that
appears in the lower right hand corner of a selected cell ) or by using the Series command (point
to Fill on the Edit menu, and then click
Series).
Fill
in a series of numbers, dates, or other items
Microsoft Excel can automatically continue a series of
numbers, number/text combinations, dates, or time periods
based on a pattern you establish. For example, the initial
selections in the following table are extended as shown.
Items separated by commas are in adjacent cells.
|
Initial selection |
Extended series |
|
1, 2, 3 |
4, 5, 6 |
|
9:00 |
10:00, 11:00, 12:00 |
|
Mon |
Tue, Wed, Thu |
|
Monday |
Tuesday, Wednesday, Thursday |
|
Jan |
Feb, Mar, Apr |
|
Jan, Apr |
Jul, Oct, Jan |
|
Jan-99, Apr-99 |
Jul-99, Oct-99, Jan-00 |
|
15-Jan, 15-Apr |
15-Jul, 15-Oct |
|
1999, 2000 |
2001, 2002, 2003 |
|
1-Jan, 1-Mar |
1-May, 1-Jul, 1-Sep,... |
|
Qtr3 (or Q3 or Quarter3) |
Qtr4, Qtr1, Qtr2,... |
|
text1, textA |
text2, textA, text3, textA,... |
|
1st Period |
2nd Period, 3rd Period,... |
|
Product 1 |
Product 2, Product 3,... |
|
