USU  ››  Programs for business automation  ››   ››   ›› 

Sorting

Sort Ascending

To sort the data, just click once on the heading of the desired column. For example, in the guide "Employees" let's click on the field "Name" . Employees are now sorted by name. A sign that sorting is carried out exactly by the ' Name ' field is a gray triangle that appears in the column heading area.

Descending sort

If you click on the same heading again, the triangle will change direction, and with it, the sort order will also change. Employees are now sorted by name in reverse order from 'Z' to 'A'.

Cancel sort

To make the gray triangle disappear, and with it the sorting of records is canceled, just click on the column heading while holding down the ' Ctrl ' key.

Sort by field

If you click on the heading of another column "Department" , then the employees will be sorted by the department in which they work.

Sorting by multiple fields

Moreover, even multiple sorting is supported. When there are many employees, you can first arrange them by "department" , and then - by "name" .

Let's first swap the columns so that the squad is on the left. By it we already have sorting. It remains to add the second field to the sort. To do this, click on the column heading "Name" with the ' Shift ' key pressed.

Find out more how you can swap columns .

See below for other helpful topics:

• Moving columns
• Find in the table
• To the begining

• Download the program with interactive training