Chapter 6. Table Views

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:

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

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 may apply saved views in one click

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.

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.OK