O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Defining Multiple Alternative Data Sets

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required