Adding Filters

You can add filters in two ways:

• Standard - you can edit the macro settings as in old versions of the add-on.
• On-the-fly - you can add filters as you get used to adding them in the page view mode.

All the filters saved in the macro body will be available for data filtration in the page edit mode.

1. Click the first line in the macro body or click the macro body.
   
2. On the appeared panel, click the Add filter  icon.
3. Select the appropriate filter type and the column for filtration. The process of adding filters is quite similar to adding filters in the page view mode.
   
4. To save the filter or filters, click the Save settings  icon.

Filtering Table

1. Select or specify the required values in the added filters. Your table will be filtered and only the matching values will remain.
   
2. To save the selected or specified values as defaults, click the Save settings  icon.
3. To reset the specified filter values, click the Reset all filters  icon.

Optimizing Work with Table Data

Table Filter macro allows you to more efficiently work with table data with the following options:

• sorting table one or multiple columns while holding the Ctrl key or Ctrl + Shift keys correspondingly
• fitting a long table to the available screen area
• enabling automatic row numbering

For the details on how to activate these options, see Managing Look of the Table and Filtration Pane.

All these options are available while working with the table data in the page edit mode.