Skip to main content

How do I sort a table?

Click the arrow in the column header and select Sort smallest to largest or Sort largest to smallest.

You sort a table by opening the menu in the column header and selecting Sort smallest to largest or Sort largest to smallest. Text is sorted alphabetically, and numbers and dates by size.

How to do it

  1. Click the arrow in the header of the column you want to sort by.

  2. Select Sort smallest to largest or Sort largest to smallest.

  3. An arrow in the header shows which column the table is sorted by, and in which direction.

Sorting from the column menu.

Good to know

  • The table is sorted by one column at a time. If you sort by a new column, it replaces the previous sort.

  • The sorting is saved in your table profile if Save continuously is turned on. The table then looks the same the next time you open it.

  • If the table is grouped, the rows are sorted within each group.

Related questions

Did this answer your question?