• Sorting tables
  • About sorting table rows
  • To create a sort group in a table
  • To sort table rows ascending or descending
  • To sort table rows using sort groups
  • To manually sort table rows

Sorting Table Rows in Ascending or Descending Order

1. Place your cursor in the table.

2. On the Home tab, click Table | Sort.

3. Under Sort Order, select either Ascending or Descending.

4. In the Primary Key list, select the column to sort by.

5. Use the Secondary Key and Tertiary Key lists to add alternate sorting parameters in the event of a tie. For example, if sorting the expense section current year values and a tie occurs, you can then sort by prior year value (column 2) or by account description. The Tertiary Key is only applicable if more than one column is selected for sorting.

6. Click OK and the sort is performed on all the rows in the table.

Related Topics

• About Sorting Table Rows