Right-click the required column and select Visible Columns on the menu. The Visible Columns dialog box opens.
Clear the checkbox next to the column you want to hide in the grid.
Click OK to close the dialog box and apply the filter condition.
When the data is filtered, the column Filter button will be changed to indicate the applied filter. The filter condition appears at the bottom of the grid providing you with a one-click quick access to the filter condition parameters. You can manage them in the following ways:
To remove all filter conditions, click the cross button at the bottom of the grid. To remove the filter condition of one column, right-click this column and select the Clear Filter item on the menu.
To switch from the filtered data to the full data display, clear the checkbox at the bottom of the grid.
To edit the filter condition, click the Edit Filer button. The Filter Editor dialog box opens.
Right-click the required column and select the Condition item on the Quick Filter sub-menu. The Filter Editor dialog box opens.
Build a filter expression by choosing a relation kind and typing values.
Filter conditions in the Filter Editor dialog box are displayed as a tree with condition and group nodes. A group consists of several conditions or subgroups, united with a logical operator. To change a group logical operator, click it and select another one on the menu. To navigate between conditions and groups, use the UP ARROW and DOWN ARROW keys. To navigate between a condition column, a criteria operator and an operand value, use the LEFT ARROW and RIGHT ARROW keys.
To remove a condition, click the condition button or navigate to the condition and press the DELETE or MINUS SIGN key. To remove a group, click its logical operator and select Remove Group on the menu that appears. You can copy, cut, and paste conditions and groups with CTRL+C, CTRL+X, and CTRL+V keys.
Click the condition column and select the column you need on the menu that appears.
Click the condition criteria operator and select the criteria operator you want to apply.
If the condition operator requires operand values, specify them.