Sort a Table

In most straight tables, you can change the order in which the table rows are sorted. That option is not available in pivot tables, however.

To change the sort order for a straight table, complete the following step:

Do one of the following:
  • To sort a table based on the values in one of the columns, double-click the column heading for that column.
  • To change the sort order from ascending to descending or from descending to ascending, double-click the column heading of the current sort column.