Microsoft Office Tutorials and References
In Depth Information
Defining an alternative data set
Clicking the Add button displays the Add Scenario dialog box.
From within this dialog box, you can name the scenario and identify the cells for which you
want to define alternative values. After you click OK, the Scenario Values dialog box opens
with fields for you to enter the new values.
Clicking OK returns you to the Scenario Manager dialog box. From there, clicking the Show
button replaces the values in the original worksheet with the alternative values you just
defined in the scenario. Any formulas referencing cells that have changed values will
recalculate their results. You can then remove the scenario by clicking the Undo button on the
Quick Access Toolbar.
Search JabSto ::




Custom Search