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 can 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:

Table Views group of the SaveToDB add-in

Type All Payments and click Save.

Save an initial view with all rows and columns

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

Type >0 in cell E2.

Filter income payments using a cell filter

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 can use row 2 (as a row over the table) as auto-filters. Also, they can place formulas in row 1.

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

Save the Incomes table view

Type <0 in cell E2.

Filter expenses using a cell filter

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

Save the view as Expenses.

Save the Expenses table view

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

You can apply saved views in one click

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

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

Moreover, you can save views for pivot tables also.

I am sure you will like these features.