创建方案

Defines a scenario for the selected sheet area.

要访问此命令...

Choose Tools - Scenarios.


方案的应用

方案名称

Defines the name for the scenario. Use a clear and unique name so you can easily identify the scenario. You can also modify a scenario name in the Navigator through the Properties context menu command.

标注

Specifies additional information about the scenario. This information will be displayed in the Navigator when you click the Scenarios icon and select the desired scenario. You can also modify this information in the Navigator through the Properties context menu command.

设置

请您在此对方案的显示作一些设置。

显示边框

Highlights the scenario in your table with a border. The color for the border is specified in the field to the right of this option. The border will have a title bar displaying the name of the last scenario. The button on the right of the scenario border offers you an overview of all the scenarios in this area, if several have been defined. You can choose any of the scenarios from this list without restrictions.

复制回

将修改的单元格值复制到活动方案中。如果不选择此选项，当您改变单元格值时，方案不会随之改变。复制回的动作设置取决于单元格保护、工作表保护和防止更改设置。

复制整个工作表

将整个工作表复制到附加方案工作表中。

防止修改

防止更改活动方案。复制回动作设置的行为取决于单元格保护、工作表保护和防止更改设置。