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
▪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. |
▪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. |