Data Fill dialog box

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.