Sort cells

The simplest method for sorting cells is to perform a selection sort. Using this method, you can sort specific cells in the document.

To sort a selection of cells:

  1. Select the cells you want to sort by holding Alt on your keyboard and dragging the selection area over the applicable cells.
  2. On the ribbon, click Tools | Sort | Selection....
  3. In the Sort Criteria dialog, select a sort order, and if available, define the sort hierarchy using the Keys drop-down menus. Click OK.

The cells are sorted alphabetically or numerically in the order specified.

Notes:

  • Sorting cells in descending order will display positive amounts first, followed by amounts equal to NIL, followed by negative amounts.
  • You cannot sort cells in a table using this method.