Búa til atburðarás

Defines a scenario for the selected sheet area.

Til að nálgast þessa skipun...

Choose Tools - Scenarios.


Using Scenarios

Heiti atburðarásar

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.

Athugasemd

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.

Stillingar

This section is used to define some of the settings used in the scenario display.

Birta jaðar

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.

Afrita aftur

Copies the values of cells that you change into the active scenario. If you do not select this option, the scenario is not changed when you change cell values. The behavior of the Copy back setting depends on the cell protection, the sheet protection, and the Prevent changes settings.

Afrita allt blaðið

Copies the entire sheet into an additional scenario sheet.

Koma í veg fyrir breytingar

Prevents changes to the active scenario. The behavior of the Copy back setting depends on the cell protection, the sheet protection, and the Prevent changes settings.