Show All

Hide All

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 (scenario: A named set of input values that you can substitute in a worksheet model.). 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 (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.).