Different ways to organize column data in a worksheet

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.

Related Articles

No related articles were found.


No attachments were found.

Visitor Comments

Would you like to...

Print this page  Print this page

Email this page  Email this page

Post a comment  Post a comment

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF

Bookmark and Share

User Opinions

How would you rate this answer?

Thank you for rating this answer.