Sorting button on the Table ribbon tab.Use sorting and filtering if required.
Table data can be sorted by columns and/or by rows.
Sorting options for the selected column or row are selected using sorting icons in row and column headers. Icons are displayed when sorting is enabled. To enable sorting, click the Sorting button on the Table ribbon tab.
When any of the icons is consequently pressed, its view is changed, therefore the sorting type is changed:
. Descending (if there are text values from Z to A).
. Ascending (if there are text values from A to Z).
Data filtering enables the user to display only the data that satisfies the specified conditions.
Table data in columns is filtered using the 
buttons in column headers. To display the buttons, click the 
Filtering button on the Table ribbon tab.
As a result of filtering application, all elements selected in the list formed from all values of filtered strings will be displayed in the table. For columns, for which the filtering is set up, the button will look like: 
.
The button menu contains the following items:
Clear Filter. The operation is used to display all rows. It is available if filtering was set up for the column.
Top N. The operation is used to display the specified number of list elements in the Condition by List dialog box:
The following options can be determined in this dialog box:
Number of Rows. The edit box that is used to specify the number of displayed rows.
Attribute. It determines whether least or greatest elements are displayed.
Selection Condition. It determines how the number of elements is specified - directly or in percentage of the number of elements.
NOTE. This filter will not be available if there are no numeric values in filtered strings.
Set Up Filter. The operation that is used to determine filtering conditions in the Custom Autofilter dialog box:
The following options can be determined in this dialog box:
Selection Condition. The drop-down list that determines the condition for displaying elements:
Equal.
Not equal.
Greater.
Greater or equal.
Less.
Less or equal.
Begins with.
Does not begin with.
Ends with.
Does not end with.
Contains.
Does not contain.
Value. The drop-down list that determines the condition value for displaying elements. This list of elements includes all column values sorted as case-insensitive. The case is taken into account only when the values match.
Filtering Conditions. The radio button that determines the order of using two conditions:
AND. It displays rows that satisfy both conditions.
OR. It displays rows that satisfy at least one of two conditions.
To disable filtering for all columns at the same time, release the Filtering button on the Table ribbon tab.
When sorting and filtering are finished, follow the step if required:
See also:
Getting Started with the Interactive Data Entry Forms Tool | Building Data Entry Form | Setting Up Form Formatting and Display Type