Populate Range dialog box

 

Use this dialog box to automatically fill worksheets with data.

 

Output

Specifies the worksheet location for placing the results of this operation.

 

Rows

Specifies the number of rows to be filled with the data indicated in Value. Type in this box the number of rows you want filled with data.

 

Columns

Specifies the number of columns to be filled with the data indicated in Value. Type in this box the number of columns you want filled with data.

 

New Workbook

Select this option to place the results of this operation in a new document workbook.

 

New Sheet

Select this option to place the results of this operation in a new worksheet.

 

Range Position

Select this option to place the results of this operation starting at the worksheet location specified in the box to the right of this option.

 

Refer to Specifying Output Locations for additional information on this subject.

 

Generation Order

 

Column-Wise

Select this option to generate data along the rows of the indicated Columns.

 

Row-Wise

Select this option to generate data along the columns of the indicated Rows.

 

 

Options

 

Type

Specifies the type of the data you want to use for the operation:

 

Alphanumeric

Use this type to populate text and formula values.

 

Datetime

Use this type to populate date, time or datetime values.

 

Numeric

Use this type to populate numeric values.

 

Value | Start Value

Specifies the value to use for the operation. Type in this box the value you want to populate.

 

 

Context

Specifies the context by which to carry the operation:

 

Constant Value

Select this option to populate all cells with identical copies of the information indicated in the Value box.

 

Value Range

Select this option to populate all cells with progressively incremented or decremented instances of the information indicated in the Value box.

 

Increment

Specifies the amount by which values will be incremented or decremented when Context is set to Value Range. Type in this box the amount by which you want to progressively increment or decrement the Start Value.

 

Direction

Specifies the direction of increment:

 

Forward

Specifies a progressive increment of the Start Value by the increment amount for every fill.

 

Backward

Specifies a progressive decrement of the Start Value by the increment amount for every fill.

 

Increment Unit

Specifies the unit of the increment amount for datetime values. Select one of Months, Days, Hours, Minutes, or Seconds.

 

OK

Closes the dialog box and carries out this operation.

 

Cancel

Closes the dialog box without carrying out this operation.