Spread Designer

To allow users to sort by columns

In the Spread Designer,

1. If you want to prevent the user from sorting on a specific column,
   1. Select the column you want to prevent from user sorting.
   2. From the Sheet menu, choose Columns and Rows or press the Columns and Rows button ( ) on the Sheet toolbar.
   3. Choose Disabled from the Sort Indicator drop-down list box.
   4. Choose the OK or Apply button.
2. Select the action to perform when the user clicks any column header.
   1. From the Sheet menu, choose Columns and Rows or press the Columns and Rows button ( ) on the Sheet toolbar.
   2. From the Header Action drop-down list box:
      • If you want the column to be sorted when the user clicks a column header and to display the sort indicator, choose Sort.
      • If you want the column to be sorted when the user clicks a column header and to not display the sort indicator, choose Sort/NoIndicator.
   3. Choose the OK or Apply button.
3. If your sheet displays multiple headers and you want the sort indicator to display in a row other than the bottom-most header row, specify which column header row will display the indicator by doing the following:
   1. From the Sheet menu, choose Headers, then choose General, or press the Headers (General) button ( ) on the Sheet toolbar.
   2. In the Header Settings dialog box, on the Columns tab, specify the row to display the sort indicator by selecting a value from the Sort Indicator Index box.
   3. Choose the OK or Apply button.