Sort

Options
mark.lee
mark.lee Member, ALL USERS Posts: 5 Master Anaplanner of the Year

You can sort the data in a grid in a published worksheet by a column or row in ascending or descending order:

  1. Click the heading of the row or column on which you want to sort the grid.
    A purple line highlights your selection.
    income-statement.png
  2. Click the sort button sort-icon50pc.png in the worksheet toolbar. 
  3. In the dropdown that displays, select Sort Ascending or Sort Descending.

The sort is applied to the column or row. An icon displays in the row or column heading, indicating the sort order. The blue arrow pointing up or down indicates whether an ascending or descending sort is applied respectively. The blue arrow also appears in the sort button sort-button-sort-indicated50pc.png in the worksheet toolbar.

sort-icons.png

To clear the sort, click the heading of any row or column and select Unsorted.