eclipse中自定义视图_如何在Excel中使用自定义视图保存工作簿设置

eclipse中自定义视图

When working on an Excel worksheet, you may find yourself setting up different display settings at different times, such as zoom level or window position and size. The Custom Views feature allows you to set up and save different views to quickly switch among them.

在Excel工作表上工作时，您可能会发现自己在不同的时间设置了不同的显示设置，例如缩放级别或窗口位置和大小。 使用“自定义视图”功能可以设置和保存不同的视图，以便在它们之间快速切换。

For example, you may want to zoom in on the worksheet temporarily to see more details, or hide parts of the Excel interface to maximize your workspace (in addition to hiding the ribbon). You can set up a different view for each worksheet and save each view. The following settings are included in custom views: the zoom level, the current cell selection, column widths and row heights, display settings on the Advanced tab of the Excel Options dialog box, the current size and position of the document window, the window pane arrangement (including frozen rows and columns), and optionally print settings (including page setup) and hidden columns and rows.

例如，您可能希望临时放大工作表以查看更多详细信息，或者隐藏Excel界面的一部分以最大程度地利用工作空间(除了隐藏功能区 )。 您可以为每个工作表设置一个不同的视图并保存每个视图。 自定义视图中包含以下设置：缩放级别，当前单元格选择，列宽和行高，“ Excel选项”对话框的“高级”选项卡上的显示设置，文档窗口的当前大小和位置，窗口窗格排列(包括冻结的行和列 )，以及可选的打印设置(包括页面设置)和隐藏的列和行 。

RELATED: How to Hide Cells, Rows, and Columns in Excel

相关： 如何在Excel中隐藏单元格，行和列

Before setting up any custom views, it’s a good idea to save the current normal view as a custom view so you can easily revert back to it. To set the current view as the normal view, click the “View” tab.

在设置任何自定义视图之前，最好将当前的普通视图另存为一个自定义视图，以便您可以轻松地还原到该视图。 要将当前视图设置为普通视图，请单击“视图”选项卡。

In the Workbook Views section, click “Custom Views” or hold Alt and press W, then C on your keyboard.

在“工作簿视图”部分中，单击“自定义视图”或按住Alt并按W，然后按键盘上的C。

On the Custom Views dialog box, click “Add”

在“自定义视图”对话框中，单击“添加”

Type a unique name for the view in the “Name” box. Since this is our normal view, we named it “Normal 100%”. Either check or uncheck the “Print settings” and “Hidden rows, columns and filter settings” boxes depending on what you want to include in the view. Click “OK”.

在“名称”框中为视图键入一个唯一的名称。 由于这是我们的正常视图，因此我们将其命名为“正常100％”。 根据要包括在视图中的内容，选中或取消选中“打印设置”和“隐藏的行，列和过滤器设置”框。 点击“确定”。

Now, we’ll create a custom view. As an example, we’re going to create a view with a 150% zoom and the Formula Bar and Headings hidden, so we can read our spreadsheet easily and have a bit more room on the worksheet. Set up the view the way you want it and then click “Custom Views” in the Workbook Views section on the View tab.

现在，我们将创建一个自定义视图。 例如，我们将创建一个缩放比例为150％的视图，并且隐藏了公式栏和标题，因此我们可以轻松阅读电子表格，并在工作表上留出更多空间。 以所需的方式设置视图，然后在“视图”选项卡上的“工作簿视图”部分中单击“自定义视图”。

Click “Add” on the Custom Views dialog box.

在“自定义视图”对话框上单击“添加”。

Enter a unique name for your custom view and check or uncheck the boxes under Include in view as desired.

输入自定义视图的唯一名称，然后根据需要选中或取消选中“包括在视图中”下的框。

To switch views, click “Custom Views” in the Workbook Views section on the View tab, or hold Alt and press W, then C on your keyboard. Click on the view you want and click “Show”. You can also double-click the name of the view you want to show.

要切换视图，请在“视图”选项卡上的“工作簿视图”部分中单击“自定义视图”，或按住Alt并按W，然后按键盘上的C。 单击所需的视图，然后单击“显示”。 您也可以双击要显示的视图的名称。

Custom views are only available in the workbook in which you create them, and they are saved as part of the workbook. They are also worksheet-specific, meaning that a custom view only applies to the worksheet that was active when you created the custom view. When you choose a custom view to show for a worksheet that is not currently active, Excel activates that worksheet and applies the view. So, you must create custom views for each worksheet in each workbook separately and be sure to save your workbook with your custom views.

自定义视图仅在创建它们的工作簿中可用，并且将它们保存为工作簿的一部分。 它们也是特定于工作表的，这意味着自定义视图仅适用于创建自定义视图时处于活动状态的工作表。 当您选择一个自定义视图以显示当前不活动的工作表时，Excel会**该工作表并应用该视图。 因此，您必须为每个工作簿中的每个工作表分别创建自定义视图，并确保将工作簿与自定义视图一起保存。

翻译自: https://www.howtogeek.com/257207/how-to-use-custom-views-in-excel-to-save-your-workbook-settings/

eclipse中自定义视图