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.

For that purpose, the following buttons are available in the dialog box for this command:

▪Add

Adds a new scenario.

For more information, see Creating scenarios.

▪Delete

Deletes the scenario selected in the list.

▪Edit

Opens a dialog box where you can edit the selected scenario. When you click on Next, another dialog box appears where you can edit the values for the changing cells.

▪Merge

Merges scenarios that have been defined on other worksheets (or workbooks) into the current worksheet.

For more information, see Merging scenarios.

▪Summary

Creates a scenario summary for all scenarios, where you can directly compare the values in the changing cells as well as any "result cells" you define.

For more information, see Creating a scenario summary.