There are three different functions to manipulate data in a column:
- You can summarize items in a column
- You can sort items in a column by descending order
Notice the three gray icons to the right of the down arrow located right above row 1:
To activate these icons you must select one of the database rows at the far left of the worksheet. Once these icons are available, click and drag the icon to the desired column header. Notice that the descending icon has been dragged to the A column and the ID numbers have been sorted accordingly.
Note: Up to three sort icons and three summarize icons can be placed in the columns of a database row.
Edited by JimW