To do a simple sort, which is only sorting by one column, right-click on any cell in the column including its header and then choose the sort option that you want from the popup menu. After sorting, icons display at the top of the sort column(s) to provide visual confirmation of the sort. If you save a workspace, the sort order is preserved.
To perform a multi-column sort:
- On the TABLE tab, in the Sort and Filter group, click Sort, and Sort Multi Column.
- Select column and order type from the Sort by lists.
- Refine your sort further by selecting another column and order type to apply to your sort from the Then by lists.
- Click OK to close the dialog and sort the contents of the Browser window.
The sort result displays in a new Browser window, and the sort order is in the order of the columns you select.
This example shows a sort result on the Country column:
Country | City | Landmark |
---|---|---|
Germany |
Berlin |
Fernsehturm |
Germany |
Berlin |
Brandenburg Gate |
India |
New Delhi |
Qutab Minar |
India |
New Delhi |
Jama Masjid |
India |
Jaipur |
Hawa Mahal |
India |
Maharashtra |
Ajanta |
United Kingdom |
London |
Buckingham Palace |
United Kingdom |
Blackpool |
Blackpool Tower |
This example shows a sort result on the columns Country, then City, then Landmark:
Country | City | Landmark |
---|---|---|
Germany |
Berlin |
Brandenburg Gate |
Germany |
Berlin |
Fernsehturm |
India |
Jaipur |
Hawa Mahal |
India |
Maharashtra |
Ajanta |
India |
New Delhi |
Jama Masjid |
India |
New Delhi |
Qutab Minar |
United Kingdom |
Blackpool |
Blackpool Tower |
United Kingdom |
London |
Buckingham Palace |
If you sort a Browser window and then edit that table, the Browser window may turn the sort off. Specifically, any edit operation that adds new rows to the table causes the Browser window to unsort, so that newly-added rows are visible at the bottom of the window. Note that this unsorting can occur even if you add new rows in a different window (for example, if you add new rows by drawing new lines in a Map window). After adding a new row to the table, you can re-apply the sort to the Browser window on the TABLE tab, in the Sort and Filter group, click Sort On/Off.