Chapter 6. Table Views

Users often apply different filters to the loaded data, hide and unhide columns, sort in various ways, etc.

The SaveToDB add-in may help to save such user views and even share them with colleagues.

Let's remove all WHERE filters and click the Save Table View button in the Table Views group:

Type All Payments and click Save.

We see the name of the current view, All Payments, in the Table View field.

Type >0 in cell E2.

The add-in applies the filter to the Sum column.

This is a reason why it is better to insert tables at cell B3.

Users may use row 2 (as a row over the table) as auto-filters. Also, they may place formulas in row 1.

Let's continue and save the view as Incomes (click the Save Table View button again):

Type <0 in cell E2.

The add-in applies the new filter to the Sum column.

Save the view as Expenses.

Remove the filter in cell E2 and apply the Incomes view in the Table View list:

As we may expect, the add-in applies the saved filter to the Sum column.

You may use the auto-filter row and table views for any Excel table.

Moreover, you may save views for pivot tables also.

I am sure you will like these features.