To save time when printing reports, you can save filter and print setting in Custom Views. Unless, of course, your workbook contains a Named Excel table – you can’t use Custom Views in those files.
Set Up Custom Views
A couple of years ago, I outlined the steps for creating Custom Views in Excel, and switching between views.
Also, I shared a few Custom View tricks, such as creating different headers and footers for each view.
Show the View Name
After you select a view, there’s no built-in feature that lets you show its name on the worksheet. You could add programming, so the name is automatically entered in a specific cell.
But, perhaps you’d rather not use macros, or your client doesn’t want macros in the workbook. There’s good news! You can use a bit of filtering, and a couple of formulas, to show the name of the selected view.
In the screen shot below, the view named “ALL” is showing, and its name is in cell H1.
Video: Show Custom View Names
Watch this video to see the steps for setting up the Custom Views, switching between them, and creating the formulas to show the name.
Or watch on YouTube: Save Excel Settings in Custom Views
Download the Sample File
To see how the filters and formulas work, you can download the sample file from my Contextures website. On the Sample Files page, go to the Filters section, and look for FL0026 – Save Filter Settings in Custom Views.