Microsoft Office Tutorials and References
In Depth Information
Defining multiple alternative data sets
11
On the Quick Access Toolbar , click the Undo button to remove the effect of the
scenario and prevent Excel from overwriting the original values with the scenario’s values
if you decide to save the workbook.
CLEAN UP Close the 2DayScenario workbook, saving your changes if you want to.
Defining multiple alternative data sets
One great feature of Excel scenarios is that you’re not limited to creating one
alternative data set—you can create as many scenarios as you like and apply them by using the
Scenario Manager. To apply more than one scenario by using the Scenario Manager, click
the name of the first scenario you want to display, click the Show button, and then do the
same for any subsequent scenarios. The values you defined as part of those scenarios will
appear in your worksheet, and Excel will update any calculations involving the changed
cells.
TIP If you apply a scenario to a worksheet and then apply another scenario to the same
worksheet, both sets of changes appear. If multiple scenarios change the same cell, the cell
will contain the value in the most recently applied scenario.
Applying multiple scenarios alters the values in your worksheets. You can understand how
those changes affect your formulas, but Excel also gives you a way to view the results of all
your scenarios in a single, separate worksheet. To create a worksheet in your current
workbook that summarizes the changes caused by your scenarios, open the Scenario Manager,
and then click the Summary button. When you do, the Scenario Summary dialog box opens.
8
Search JabSto ::




Custom Search