Skip To Content

Sort records in a table

Sorting is an efficient means of organizing your data in alphabetical or sequential order, helping you to better understand the data you're working with. You can discover the largest and smallest values or perhaps the most and least significant features in a layer. When sorting a column's values in ascending order, the values are ordered from A to Z or from 1 to 10. In descending order, a column's values are arranged from Z to A or from 10 to 1.

You can interactively sort in the table window or by using a table sorting dialog box, which makes it easier to sort more than one column. If you want a table that is permanently sorted, use the Sort geoprocessing tool.

Basic sorting

Sort your table based on a field by double-clicking the field name. The first sort will be in ascending order. Each subsequent double-click will switch the sort order.

Right-click the field name you want to sort and choose Sort Ascending Sort Ascending or Sort Descending Sort Descending to immediately sort the table.

Use the Shift keyboard shortcut, and double-click columns to sort by multiple fields.

Custom sorting

Use the Custom Sort dialog box to sort based on multiple fields, clear the current sort order on the table, or make a case-sensitive sort. Right-click any field name and choose Custom Sort. Optionally, use the keyboard shortcut Ctrl+Shift+S.

Remove or undo the sort order by pressing Ctrl+Shift+U in the active table.

Related topics