Use this dialog box to set values for a range of cells within a column.
|
Column Specifies the column to set values for. |
|
|
Increment Sets options to fill the range by writing a start value to the first cell and then writing increments to subsequent cells. This option is available only if the data type for the column is numeric. |
|
|
Start value Specifies the value to write in the first cell in the range. |
|
|
Step Specifies the increment. |
|
|
Add Sets options to fill the range by adding a fixed value to a cell’s existing value. This option is available only if the data type for the column is numeric. |
|
|
Value Specifies the value to add. |
|
|
Value Specifies the value to set. This box is available only if the data type is text. |
|