Microsoft Office Tutorials and References
In Depth Information
Plug Multiple Input Values into a Formula
Chapter 5: Analyzing Excel Data
1 Click the Data tab.
2 Click What-If Analysis.
3 Click Scenario Manager.
The Scenario Manager
dialog box appears.
4 Click the scenario you
want to display.
5 Click Show.
Excel enters the scenario
values into the changing
cells and displays the
6 Repeat steps 4 and 5 to
display other scenarios.
7 Click Close.
If you need to make changes to a
scenario, you can edit the name, the
changing cells, the description, and
the scenario’s input values. Click the
Data tab, click the What-If Analysis
drop-down arrow, and then click
Scenario Manager. In the Scenario
Manager dialog box, click the scenario
you want to modify, and then click Edit.
If you have a scenario that you no longer need,
you should delete it to reduce clutter in the
Scenario Manager. Click the Data tab, click the
What-If Analysis drop-down arrow, and then
click Scenario Manager. Click the scenario you
want to delete. Note that Excel does not ask
you to confirm the deletion, so double-check
that you have selected the correct scenario.
Click Delete and then click Close.