To save the filter criteria

  • On the Options toolbar, click  and then select Save Filter Criteria.

When exporting the table, only the filtered out columns and rows will be included in the result.