You can use the Data Fill dialog box to continue a series of data you typed in the selected cells. For example, you can extend a series of numbers such as 1, 2, 3 to include 4, 5, 6 or a date such as 03/01/96 to include 03/02/96, 03/03/96, 03/04/96, and so on.
Blocks
Specifies the coordinates of the cell block that you want to fill.
Rows
Enable to extend the values across rows.
Columns
Enable to extend the data fill across columns.
Linear
Enable to create a linear series or a linear best-fit trend. If the Trend button is enabled, a linear trend is calculated based on the values in the selected cells. This replaces the original values with values that fit the trend. If the Step button is enabled, each cell value increases or decreases by the amount specified in the Value box.
Growth
Enable to create a growth series or a geometric growth trend. If the Trend button is enabled, a geometric growth trend is calculated based on the values in the selected cells. This replaces the original values with values that fit that trend. If the Step button is enabled, each cell value is multiplied in turn by the value in the Value box.
Automatic
Enable to create a series that is based on the values in the selected cells. For example, using the Automatic option on a selected cell block containing the text "Document 1" and "Document 2," the resulting series would be "Document 1, Document 2, Document 3, Document 4, Document 5," etc. If the selection contained the cell values 1 and 4, the resulting series would be 1, 4, 7, 10, 13, etc.
Date
Enable to create a date series.
Date list box
Displays a list of date units.
Step
Enable to specify the amount by which to increase or decrease the series. Each cell value is multiplied in turn by the value in the Value box
Trend
Enable to calculate a linear or exponential growth series based on the values in the selected cells.
Value
Specifies the amount by which to increase or decrease the series. A positive number increases a series; a negative number decreases a series. You need to type only one value.
Stop At
Specifies the value at which you want the fill series to end.