|
Split Range dialog box |
|
Use this dialog box to specify the extent and context of the Split Range command:
Input
Specifies the worksheet location of the input data for this operation.
Provides a reference to the extent of the data available in the currently active worksheet. Use this range as a guide for typing valid extents in the Input Range box.
Type in this box the range of cells containing the data you want to use as input for this command.
Check this box to indicate that the data specified by the Input Range box is organized in rows as opposed to columns (the default).
Refer to Specifying Input Arguments for additional information on this subject.
Output
Specifies the worksheet location for placing the results of this operation.
Select this option to place the results of this operation in a new document workbook.
Select this option to place the results of this operation in a new worksheet.
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.
Options
Specifies the number of parts by which to divide each row or column included in the input range.
 | When possible, resulting parts contain an equal number of elements; otherwise, trailing parts will be slightly shorter. As an example, dividing a column of four elements into three parts results in three columns containing 2, 1, and 1 elements, respectively. |
Closes the dialog box and carries out this operation.
Closes the dialog box without carrying out this operation.
| The context of this operation is guided by the context of the input range. As an example, if the input range consists of series organized in columns, this operation breaks each of the indicated columns into the number of columns specified in the Number of Parts box. |
Sponsored
Try Predictive Systems Lab
Need Help?
Contact support