Sorting records in a table by multiple fields

Sorting records in a table allows you to better understand the data that you are working with. You can discover the largest and smallest values or perhaps the most and least significant features in the layer. Sorting is also an efficient means for organizing your data in alphabetical or sequential order.

To sort up to four fields at once

Steps:
  1. Right-click a field name and click Advanced Sorting.
  2. Click the Sort by arrow and click the first field by which you want to sort.
  3. Click Ascending or Descending to choose the sort order.
  4. Click the Then sort by arrow, click the next field, then choose a sort order.
  5. Click up to two more fields and their sort orders. Choose (none) if you don't want to sort the fields at that level.
  6. Click OK.
TipTip:
You can press SHIFT and double-click a field name or CTRL+SHIFT+S as a shortcut to opening the Advanced Table Sorting dialog box.
TipTip:
To select all adjacent columns, place the pointer over the heading of the leftmost column, then click and hold while dragging to the right.
TipTip:
To sort more than four records at once, use the CTRL key to select multiple fields, right-click, then choose to sort in ascending or descending order. The fields are sorted in the order you click them in the table.

Related Topics


9/17/2012