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

Editing a Scenario

If you need to make changes to a scenario—whether to change the scenario's name, select different changing cells, or enter new values—follow these steps:

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

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

3.
Click Edit. Excel displays the Edit Scenario dialog box (which is identical to the Add Scenario dialog box, shown in Figure 14.23).

4.
Make your changes, if necessary, and click OK. The Scenario Values dialog box appears (see Figure 14.24).

5.
Enter the new values, if necessary, and then click OK to return to the Scenario Manager dialog box.

6.
Repeat steps 2 through 5 to edit other scenarios.

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