Today we discuss a feature that helps save a lot of time.

In the previous step, we have connected to a database.

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

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

When you load data for the first time, you have the default view.

Click the Save Table View button as shown:

Type Default and click the Save button.

You may see the actual view in the view list.

Apply the Revenue filter in the Item Name column:

Click the Save Table View button, type Revenue and click Save:

Now you have two views in the view list and may easily switch the active view:

You may create a lot of views for every table to get the required data at the moment.

The views include applied auto-filters, sort orders, column visibilities, and other elements.

Moreover, you may create table views for pivot tables too.

In the next letters, we will discuss how to share such views with colleagues.

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.