Show Excel Custom View Name

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.

customviewnames04

Set Up Custom Views

A couple of years ago, I outlined the steps for creating Custom Views in Excel, and switching between views.

customviewnames02

Also, I shared a few Custom View tricks, such as creating different headers and footers for each view.

customviewnames03

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.

customviewnames01

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.

_____________________________

You may also like...

3 Responses

  1. jeffreyweir says:

    Custom Views are the best feature that MS ever (effectively) deprecated. At some stage I intend to write an add-in to bring this functionality back to table-using users.

  2. MF says:

    Hi Debra,
    Very nice trick! Thanks for sharing.
    Just a little comment on the Index and Match. I think we don’t need to use MATCH in your example as they are actually in sequential ascending order, right?
    Cheers,
    MF

  3. Hi Deb,

    Thanks for this tip.
    Great combination of custom view, filter and formula without vba.
    Easy to implement with your clear steps.
    Cheers,
    Kevin

Leave a Reply

Your email address will not be published. Required fields are marked *