Along with Scenarios and the ability to create several for one range of cells, you can combine your scenarios into one, nicely-wrapped summary report. This report actually lists your scenarios side-by-side.
Creating a Scenario Summary Report
Choose Tools: Scenarios… from the Menu bar
Figure 29. Scenario Summary Dialog Box
3. Choose Scenario Summary
4. Delete the text in the Result cells box (This should be left blank when creating a Scenario Summary although it is a required field when creating a PivotTable report)
5. Click OK
Figure 30. Sample Scenario Summary Report