Create a scenario summary report

Microsoft Office Excel 2003

previous page next page

Show All Show All

Create a scenario summary report

  1. On the Tools menu, click Scenarios.
  2. Click Summary.
  3. Click Scenario summary or Scenario PivotTable.
  4. In the Result cells box, enter the references for the cells that refer to cells whose values are changed by the scenarios. Separate multiple references with commas.

Note  You don't need result cells to generate a scenario summary report, but you do need them for a scenario PivotTable report.

previous page start next page