How to Save Your Time by Using Custom Views in Excel

Most of us will ignore the feature of custom views in Excel. So in this article, we will talk about this feature in detail.

The custom views have effects on printing settings, hidden rows, columns and filter settings. And in this article, we will take the filter settings as an example. In a worksheet, you will use the filter feature to analyze data. But after the task, you need to disable this feature. If the next time you need to use the same criteria to filter data, you need to set the condition again. Why don’t you save the criteria so that you can use it directly the next time? And the following sentences will demonstrate the steps.

Create Custom Views

In this image below, we have already filter data that meet certain conditions. To use the criteria next time, you need to save it.An Example for Custom View

  1. Click the tab “View” in the ribbon.
  2. Next click “Custom Views”.Custom Views
  3. In the “Custom Views” window, click the button “Add”.Add
  4. And then in the “Add View” window, input the name into the text box. Because here we use the filter setting as an example, make sure that you check the option “Hidden rows, columns and filter settings”. On the other hand, if you need to save the print setting, you need to check the corresponding option.Add View
  5. After that, click “OK”. Therefore, you have saved the settings.

Use Custom Views

This is the same worksheet without filter.An Ordinary Worksheet

Now if you need to use the filter setting, you can apply the custom views that you have previously saved.

  1. Click “View” in the ribbon.
  2. Next click “Custom Views”.
  3. Then in the “Custom View” window, choose the view that you need to use.
  4. After that, click the button “Show”.Show the View

Thus, the filter will take effect. And you can see that this is exactly the same criteria that you have earlier set.An Example for Custom View

Except for the filter setting, you can also save the printing setting and hidden rows and columns. You also need to pay attention that the custom view can only take effect in the worksheet where you created it. That’s to say, you cannot use it in other worksheet or workbook. Besides, if there is a table in the current workbook, the custom view will be invalid.

Excel Corruption will Affect Custom Views

Excel Corruption has long been a big problem for Excel users. Even if Excel has brought great convenience to us, once it corrupt, the result can be unimaginable. Most of or even all the settings in Excel will be damaged including the custom views. Therefore, you can use a third party tool to fix Excel. With this tool, you can retrieve all the settings in Excel.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit

Comments are closed.