How to add and use custom views in Excel

How to add and use custom views in Excel

We sometimes need to do in Excel repeatedly in accordance with different conditions for screening, hiding ranks and other operations, when more table data, automatic screening conditions are more complex, repeated operation becomes a very troublesome thing.

Take the following cost table as an example, you need to filter by different criteria:

The criteria for the first filter are:

Date is May

Account code is 550211

The amount is more than 500 yuan

Filter out and then hide the Account encoding column.

The completed results are as follows:

This result can be saved with a custom view if you also need to filter for other conditions.

Click View, turn to Custom view, and click the Add button in the View manager. In the Add View dialog box, let's leave the default option, an easy to remember name: May depreciation fee of more than 500 yuan.

This custom view is saved and continues to be filtered for other conditions. The criteria for filtering are:

Date is March

Account code is 550203

The amount is more than 100 yuan

The completed results are as follows:

Next, click "View", "Customize View," and start a name: March more than 100 yuan transportation

OK, so we have two custom views saved separately.

In the future when we operate, if you want to see May more than 500 yuan depreciation fee, as long as the custom view click on the display on it.