Editing worksheets > Scenarios > Managing scenarios

The command Data | group Analyze | Scenario manager can also be used to manage the scenarios defined in the current worksheet.

To do so, use the following buttons in the dialog box for this command:

▪Add

This adds a new scenario.

For more information, see Creating scenarios.

▪Delete

This deletes the scenario currently selected in the list.

▪Edit

This opens a dialog box in which you can edit the selected scenario. If you click on Next, the program will display another dialog box in which you can change the values for the changeable cells.

▪Merge

This merges scenarios that have been defined in other worksheets (or workbooks) into the current worksheet.

For more information, see Merging scenarios.

▪Summary

This creates a scenario summary that directly compares the values in the changeable cells and the values in any "result cells" for all scenarios.

For more information, see Creating a scenario summary.