• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Displaying a Scenario

After you define a scenario, you can enter its values into the changing cells by displaying the scenario from the Scenario Manager dialog box. The following steps give you the details:

1.
Choose Tools, Scenarios to display the Scenario Manager.

2.
In the Scenarios list, click the scenario you want to display.

3.
Click Show. Excel enters the scenario values into the changing cells. Figure 14.25 shows an example.

Figure 14.25. When you click Show, Excel enters the values for the highlighted scenario into the changing cells.


4.
Repeat steps 2 and 3 to display other scenarios.

5.
Click Close to return to the worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint