Today we discuss a useful feature for working with auto-filters.

We have connected to a database in the previous step.

You may use your file or download and open the following workbook

https://www.savetodb.com/downloads/example_of_payments.xlsx (23 KB)

We have inserted the table into cell B3, and it looks like this:

Now we may use row 2 (the first one over the table) to manage auto-filters.

Try to type >100000 in cell E2. The add-in will apply the auto-filter:

Clear the value, and the add-in will clear the auto-filter.

You may use the asterisk to filter text values.

For example, try to type *inc* in cell G2:

I like this feature. Hope you will like it too. You may use it with any Excel table.

You may enable or disable it using the Advanced tab in the SaveToDB options.

Best regards,

Sergey Vaselenko
CEO | Gartle Technology Corporation

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.