To limit output cell size based on size of input cells
1.
Click the Cell Size Limit tab in the process.
You see the Cell Size Limit window.
2.
*
Largest Checked Cell - specifies that the output cell size should not exceed the size of the largest selected input cell. For example, if cells A, B, and C are checked, with sizes of 250, 500, and 100 respectively, the size of the output cell for this process would be limited to 500, the largest of the input cell sizes.
*
Maximum Size (Above) Minus Sum of All Checked Cells - use this option in conjunction with the Limit output cell size to value specified above. This option specifies that the output cell size should not exceed , where is the difference between the number specified in the Limit output cell size to field above, and the sum of all selected input cells. For example, if you entered 1000 as the Limit output cell size to value, and checked input cells A and B with sizes 100 and 200 respectively, the size of the output cell for this process would be limited to 1000 - (100+200) = 700.
*
Size of Any Checked Cells - specifies that the output cell size should not exceed the size of any of the selected input cells. For example, if cells A, B, and C are checked, with sizes of 250, 500, and 100 respectively, the size of the output cell for this process would be limited to 100, the smallest of the input cell sizes.
*
Sum of All Checked Cells - specifies that the output cell size should not exceed the total size (sum) of all the selected input cells. For example, if cells A, B, and C are checked, with sizes of 250, 500, and 100 respectively, the size of the output cell for this process would be limited to 850, the sum of all three of the input cell sizes.
3.