You are here: All Help Topics > Completion and Revision > Sorting > To sort by cells

Sort by Cells

  1. Select the column of cells you want to sort by pressing Alt and dragging over the cells.
  2. On the Tools tab, click Sort | Selections.

  3. Under Sort order, select the sorting order.

  4. Use the Secondary Key and Tertiary Key lists to add alternate sorting parameters in the event of a tie. For example, if sorting the expense section current year values and a tie occurs, you can then sort by prior year value (column 2) or by account description. The Tertiary Key is only applicable if more than one column is selected for sorting.

  5. Click OK.

  • Sorting in descending order presents all positive amounts first, followed by amounts equal to NIL, and negative amounts last.
  • This type of sort cannot be used to sort the cells in a table.

Related Topics