手动修复excel注册表_如何在Excel中手动仅计算活动工作表

手动修复excel注册表

If you have large workbooks with a lot of formulas on the worksheets, recalculating the workbooks can take a long time. By default, Excel automatically recalculates all open workbooks as you change values in the worksheets. However, you can choose to recalculate only the current worksheet manually.

如果您的工作簿上有很多工作表，其中有很多公式，则重新计算工作簿可能需要很长时间。 默认情况下，当您更改工作表中的值时，Excel会自动重新计算所有打开的工作簿。 但是，您可以选择仅手动重新计算当前工作表。

Notice I said worksheet, not workbook. There is no direct way in Excel to manually recalculate only the current workbook, but you can manually recalculate the current worksheet within a workbook.

注意，我说的是工作表，而不是工作簿。 有在Excel中没有直接的方法来手动重新计算仅在当前工作簿，但您可以手动将工作簿中重新计算当前工作表。

To begin, click the “File” tab.

首先，单击“文件”选项卡。

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

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

The Excel Options dialog box displays. Click “Formulas” in the list of items on the left.

将显示“ Excel选项”对话框。 在左侧的项目列表中，单击“公式”。

In the Calculation options section, click the “Manual” radio button to turn on the ability to manually calculate each worksheet. When you select “Manual”, the “Recalculate workbook before saving” check box is automatically checked. If you save your worksheet often and would rather not wait for it to recalculate every time you do, select the “Recalculate workbook before saving” check box so there is NO check mark in the box to disable the option.

在“计算选项”部分中，单击“手动”单选按钮以启用手动计算每个工作表的功能。 选择“手动”时，将自动选中“保存前重新计算工作簿”复选框。 如果您经常保存工作表，而又不想每次都等待它重新计算，请选中“保存前重新计算工作簿”复选框，以使该框中没有复选标记以禁用该选项。

You’ll also notice the “Automatic except for data tables” option. Data tables are defined by Microsoft as:

您还会注意到“自动(数据表除外)”选项。 数据表由Microsoft定义为：

“.  . . a range of cells that shows how changing one or two variables in your formulas will affect the results of those formulas. Data tables provide a shortcut for calculating multiple results in one operation and a way to view and compare the results of all the different variations together on your worksheet.”

”。 。 。 一系列单元格，它们显示更改公式中的一个或两个变量将如何影响这些公式的结果。 数据表为在一个操作中计算多个结果提供了一种捷径，并提供了一种在工作表上一起查看和比较所有不同变体的结果的方式。”

Data tables are recalculated every time a worksheet is recalculated, even if they have not changed. If you’re using a lot of data tables, and you still want to automatically recalculate your workbooks, you can select the “Automatic except for data tables” option, and everything except for your data tables will be recalculated, saving you some time during recalculation.

每次重新计算工作表时，数据表都会重新计算，即使它们没有更改。 如果您使用大量数据表，但仍要自动重新计算工作簿，则可以选择“除数据表之外的自动”选项，并且将重新计算除数据表之外的所有内容，从而节省了一些时间重新计算。

If you don’t mind the “Recalculate workbook before saving” option being enabled when you turn on Manual calculation, there is a quicker way of choosing to manually recalculate your worksheets. First, click the “Formulas” tab.

如果您不介意在启用“手动计算”时启用了“保存前重新计算工作簿”选项，则可以选择一种更快的方式来手动重新计算工作表。 首先，点击“公式”标签。

Then, in the Calculation section of the Formulas tab, click the “Calculation Options” button and select “Manual” from the drop-down menu.

然后，在“公式”选项卡的“计算”部分中，单击“计算选项”按钮，然后从下拉菜单中选择“手动”。

Once you’ve turned on manual calculation, you can click “Calculate Sheet” in the Calculation section of the Formulas tab, or press Shift+F9, to manually recalculate the active worksheet. If you want to recalculate everything on all worksheets in all open workbooks that has changed since the last calculation, press F9 (only if you have turned off Automatic calculation). To recalculate all formulas in all open workbooks, regardless of whether they have changed since the last recalculation, press Ctrl+Alt+F9. To check formulas that depend on other cells first and then recalculate all formulas in all open workbooks, regardless of whether they have changed since the last recalculation, press Ctrl+Shift+Alt+F9.

启用手动计算后，可以在“公式”选项卡的“计算”部分中单击“计算表”，或按Shift + F9键手动重新计算活动工作表。 如果要重新计算自上次计算以来已更改的所有打开的工作簿中所有工作表上的所有内容，请按F9键(仅当您已关闭“自动计算”时)。 若要重新计算所有打开的工作簿中的所有公式，无论自上次重新计算以来是否已更改，请按Ctrl + Alt + F9。 若要先检查依赖于其他单元格的公式，然后重新计算所有打开的工作簿中的所有公式，而不管自上次重新计算以来它们是否已更改，请按Ctrl + Shift + Alt + F9。

翻译自: https://www.howtogeek.com/252463/how-to-manually-calculate-only-the-active-worksheet-in-excel/

手动修复excel注册表