Creating Scenario Summaries

If you have a number of different scenarios devised for a worksheet, you can quickly create scenario summaries. These list the values in each of your scenarios, along with any result cells you want to show. They are very helpful for providing an overview of the different scenarios.

To create a summary, all you need to do is follow these steps:

1. Choose Scenarios from the Tools menu. Excel displays the Scenario Manager. (Click here to see a related figure.)
2. Click on the Summary button. Excel displays the Scenario Summary dialog box. (Click here to see a related figure.)
3. Using the two radio buttons in the Report Type area of the dialog box, select the type of summary report you want. Most of the time you will select the default (Scenario Summary), although you can create a PivotTable, if desired.
4. Specify in the Result Cells field the result cells you want included in the report.
5. Click on the OK button. Excel inserts a worksheet before the current one and constructs a fully formatted summary report in it.

Even though the report is fully formatted, you can make formatting changes as you deem appropriate. You will probably want to do this anyway, since Excel uses cell addresses for cells that aren't named. Make your changes and then save your workbook as you normally would.