To keep multiple scenarios for a worksheet, choose Tools->Scenarios from the menu bar to display the Scenario Manager. Use the Add button in the Scenario Manager to create as many scenarios as you wish. All of the scenarios you create for a given worksheet will be available in the list under the heading Scenarios, in the Scenario Manager dialogue box.

In this example, you can see four scenarios in the scenario list. These scenarios will be saved with this workbook when it is saved. When the workbook is opened, the scenarios will be available for viewing by invoking the scenario manager.

To load a scenario into the worksheet, select it from the list and click the show button.

To remove a scenario, select it and click Delete.

To make changes to a scenario, select it and click the Edit button.