Microsoft Office Tutorials and References
In Depth Information
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 see 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.
From within the dialog box, you can choose the type of summary worksheet you want to
create and the cells you want to display in the summary worksheet. To choose the cells
to display in the summary, click the Collapse Dialog button in the box, select the cells you
want to display, and then expand the dialog box. After you verify that the range in the
box represents the cells you want to have included on the summary sheet, click OK to
create the new worksheet.