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:
- Select the cells you want to sort by holding Alt on your keyboard and dragging the selection area over the applicable cells.
- On the ribbon, click Tools | Sort | Selection....
- 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.