Scenarios

Tips, Tricks, and Answers

The following articles are available for the 'Scenarios' topic. Click the article's title (shown in bold) to see the associated article.

Creating Scenario Summaries
One handy feature of the Scenario Manager is the ability to contrast the different scenarios you have defined. This information is presented in a handy summary worksheet that shows the contents of the scenarios. Follow a few quick steps, and you can have this valuable report on-screen.

Creating Scenarios
The Scenario Manager is a tool you can use to store and easily recall different settings within a worksheet. This tip introduces the Scenario Manager and explains how to save your own scenarios.

Editing a Scenario
Scenarios that you define are not static; you can easily change them to reflect different assumptions or to contain updated values. This tip explains how to edit an existing scenario without affecting anything shown in the workbook.

Showing a Scenario
Save a scenario in the Scenario Manager, and it is a sure bet that you'll want to recall that scenario at some time. This tip explains how to access a scenario you've saved, and what happens when you choose to show the scenario.