Editing a Scenario

Once a scenario is saved, you can later edit it without the necessity of editing the worksheet and resaving the scenario. Instead, you use the Scenario Manager to do the editing. Follow these steps:

1. Choose Scenarios from the Tools menu. Excel displays the Scenario Manager. (Click here to see a related figure.)
2. Highlight the name of the scenario whose values you want to change.
3. Click on the Edit button. Excel displays the Edit Scenario dialog box. (Click here to see a related figure.)
4. Change the name of the scenario, cell range it refers to, or any comments, as desired.
5. Click on the OK button. Excel displays the Scenario Values dialog box. (Click here to see a related figure.)
6. Change the values stored in the scenario, as desired.
7. Click on the OK button. Your changes are saved and the Scenario Manager is again displayed.
8. Repeat steps 2 through 7 for any other scenarios you want to change.
9. Click on Close to dismiss the Scenario Manager.