The command Data | group Analyze | Scenario manager can also be used to create a scenario summary for all scenarios defined in the current worksheet.
A scenario summary lists all scenarios clearly next to each other. For each scenario, both the changing cells and any "result cells" (containing the calculations to be observed) are displayed.
Scenario summaries are useful for comparing the changing values and the results of scenarios at a glance.
To create a scenario summary, proceed as follows:
| 1. | Create the desired scenarios (as described in Creating scenarios). |
| 2. | Choose the ribbon command Data | group Analyze | Scenario manager  . |
| 3. | Click on Summary. |
| 4. | Enter the address of the desired result cell. This is the cell which contains the calculation that you want to observe in your scenarios. |
| You can also specify multiple cells. Separate the cell addresses with a comma – for example: A2,A4,A10. Cell ranges (like B5:B10) are also allowed. |
| 5. | Confirm with OK. |
PlanMaker will now create a new worksheet and generate the scenario summary in it.
Note: Scenario summaries are not automatically updated when you change cell contents or scenario settings. To manually update a scenario summary, delete the worksheet containing the summary and then generate the summary again.