Sorting Unlinked Correlations

By default, correlated assumptions are displayed according to the selected sort option: by name, by cell row, or by cell column.

  To set the sort order of correlations that are not part of linked matrixes:

  1. Open an existing correlation matrix or select Define Correlations to create a new one.

  2. In the Define Correlations dialog, select View, and then Sort.

  3. Select a sort order: By Name, By Cell Row (to sort assumptions in their order across the spreadsheet), or By Cell Column (to sort assumptions in their order within spreadsheet columns.

  4. Click OK.

Note:

This sorting procedure works only for unlinked matrixes. Linked matrixes must be sorted as described in step 11.