如何在新的Excel工作簿中更改默认的工作表数-CSDN博客

00_lead_image_change_default_number_of_sheets

By default, new workbooks created in Excel contain one worksheet. If you typically use more than one worksheet, you can change the number of worksheets available by default in new workbooks with a simple setting.

默认情况下，在Excel中创建的新工作簿包含一个工作表。如果您通常使用多个工作表，则可以通过简单的设置更改新工作簿中默认情况下可用的工作表数。

You can add worksheets easily using the plus icon to the right of the worksheet tabs as you work. However, if you know you’re going to want more than one worksheet in each new workbook you create, we’ll show you a setting that allows you to specify how many worksheets will be automatically created in new workbooks.

您可以在工作时使用工作表选项卡右侧的加号图标轻松添加工作表。但是，如果您知道要在创建的每个新工作簿中使用多个工作表，我们将为您显示一个设置，该设置可让您指定在新工作簿中将自动创建多少个工作表。

To begin, open any existing Excel workbook or create a new workbook. Then, click the “File” tab.

首先，打开任何现有的Excel工作簿或创建一个新的工作簿。然后，单击“文件”选项卡。

On the backstage screen, click “Options” in the list of items on the left.

在后台屏幕上，单击左侧项目列表中的“选项”。

Make sure the “General” screen is active on the Excel Options dialog box. In the When Creating New Workbooks section, enter the number of worksheets you want in new workbooks in the “Include this many sheets” edit box. You can also click the up and down arrows on the box to change the number.

确保“常规”屏幕在“ Excel选项”对话框中处于活动状态。在“创建新工作簿时”部分的“包括很多工作表”编辑框中，输入新工作簿中所需的工作表数量。您也可以单击框上的向上和向下箭头更改数字。

Click “OK” to save the change and close the Excel Options dialog box.

单击“确定”保存更改并关闭“ Excel选项”对话框。

Now, when you create a new workbook, it will automatically have the number of worksheets you specified.

现在，当您创建一个新工作簿时，它将自动具有您指定的工作表数。

This setting does not affect any existing Excel workbooks you open. It only affects the number of worksheets in new workbooks created after this setting is changed.

此设置不会影响您打开的任何现有Excel工作簿。它仅影响更改此设置后创建的新工作簿中的工作表数量。

You can also copy and move worksheets, hide worksheets, and hide the worksheet tabs bar itself.

您还可以复制和移动工作表，隐藏工作表以及隐藏工作表选项卡栏本身。