Page 673 - Excel 2013 All-in-One For Dummies

Exploring Different Scenarios 655
Figure 1-7:
Spreadsheet after showing the Worst Case scenario.
If, after creating the scenarios for your worksheet, you find that you need to use different input values or you want to add or remove scenarios, you can edit the scenarios in the Scenario Manager dialog box. To modify the sce- nario’s name and/or the input values assigned to the changing cells of that scenario, click the scenario name in the Scenarios list box and then click
the Edit button so that you can make the appropriate changes in the Edit Scenario dialog box. To remove a scenario from a worksheet, select the sce- nario’s name in the Scenarios list box and then click the Delete button. Note, however, that if you delete a scenario in error, you can’t restore it with the Undo command. Instead, you must re-create the scenario by using the Add command button as outlined previously.
You can also merge scenarios from other Excel workbook files that are
open. (Of course, the workbooks must share the same spreadsheet layout and changing cells.) To merge a scenario into the current worksheet from another workbook, click the Merge button in the Scenario Manager dialog box and then select the workbook from the Book drop-down list box and the worksheet from the Sheet drop-down list box before you click OK. Excel then copies all the scenarios defined for that worksheet and merges them with any scenarios that you’ve defined for the current worksheet.
Book VII Chapter 1
Performing What-If Scenarios