Microsoft Office Tutorials and References
In Depth Information
Using the Auto Fill Options Button
Figure 3-23
AutoFill applied to values, dates and times, and patterned text
Type
Initial Pattern
Extended Series
Values
1, 2, 3
4, 5, 6, ...
2, 4, 6
8, 10, 12, ...
Dates and Times
Jan
Feb, Mar, Apr, ...
January
February, March, April, ...
15-Jan, 15-Feb
15-Mar, 15-Apr, 15-May, ...
12/30/2013
12/31/2013, 1/1/2014, 1/2/2014, ...
12/31/2013, 1/31/2014
2/28/2014, 3/31/2014, 4/30/2014, ...
Mon
Tue, Wed, Thu, ...
Monday
Tuesday, Wednesday, Thursday, ...
11:00AM
12:00PM, 1:00PM, 2:00PM, ...
Patterned Text
1st period
2nd period, 3rd period, 4th period, ...
Region 1
Region 2, Region 3, Region 4, ...
Quarter 3
Quarter 4, Quarter 1, Quarter 2, ...
Qtr3
Qtr4, Qtr1, Qtr2, ...
For more complex patterns, you can use the Series dialog box. To do so, enter the fi rst
value of the series in a worksheet cell, select the entire range that will contain the series,
click the Fill button in the Editing group on the Home tab, and then click Series. The
Series dialog box opens. From the Series dialog box you can specify a linear or growth
series for numeric values; a Date series for dates that increase by day, weekday, month,
or year; or an AutoFill series for patterned text. With numeric values, you can also specify
the step value (indicating how much each numeric value increases over the previous
entry) and a stop value (to specify the endpoint for the entire series).
Creating a Series with AutoFill
• Enter the first few values of the series into a range.
• Select the range, and then drag the fill handle of the selected range over the cells you
want to fill.
or
• Enter the first few values of the series into a range.
• Select the entire range into which you want to extend the series.
• In the Editing group on the Home tab, click the Fill button, and then click Down, Right,
Up, Left, Series, or Justify to set the direction in which you want to extend the series.
Diane wants to see how the monthly balances in the main savings account are
affected by the couple’s changing income and expenses. She wants to make sure that
the balance doesn’t drop too low after months with particularly high expenses—such as
January and August. You’ll add data to the worksheet to display the monthly savings
balance, starting with the month labels.
Search JabSto ::




Custom Search