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 as you like and switch among them at will with the Scenario Manager. To change from one scenario to another in the Scenario Manager, click the name of the scenario to which you want to change and then click the Show button. The values you defined as part of that scenario 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 will ...
Get Microsoft® Office Excel® 2003 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
