自定义textview视图_显示Excel自定义视图名称

自定义textview视图

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.

为了节省打印报告的时间，您可以在“自定义视图”中保存过滤器和打印设置。 当然，除非您的工作簿包含一个命名Excel表–您不能在这些文件中使用“自定义视图”。

Here's the dimmed out Custom Views command on the Ribbon, when the workbook contains a Named Excel Table.

当工作簿包含命名Excel表时，这是功能区上变暗的“自定义视图”命令。

设置自定义视图 (Set Up Custom Views)

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

几年前，我概述了在Excel中创建自定义视图以及在视图之间切换的步骤。

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.

在下面的屏幕快照中，显示了名为“ ALL”的视图，其名称位于单元格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.

观看此视频，以查看设置自定义视图，在它们之间切换以及创建用于显示名称的公式的步骤。

演示地址

下载样本文件 (Download the Sample File)

To see how the filters and formulas work, you can download the sample file from my Contextures website.

若要查看过滤器和公式的工作原理，可以从Contextures网站下载示例文件。

On the Sample Files page, go to the Filters section, and look for FL0026 - Save Filter Settings in Custom Views. _____________________________

在“样本文件”页面上，转到“过滤器”部分，然后查找“ FL0026-在自定义视图中保存过滤器设置” 。 _____________________________

翻译自: https://contexturesblog.com/archives/2014/05/06/show-excel-custom-view-name/

自定义textview视图