Managing scenarios
Quattro Pro lets you keep track of all the scenarios you create. You can save edits to a scenario or you can rename the scenario group if the focus of the scenarios changes. You can highlight the changing cells of a scenario to make it easier to keep track of the data that you modify.
When you no longer need a scenario, you can delete it from the scenario group, or you can remove the scenario group altogether.
To save scenario edits |
1.
|
|
Click Tools Scenario Edit.
|
2.
|
|
Choose a scenario group from the Scenario groups list box.
|
3.
|
|
Choose a scenario from the Scenarios list.
|
4.
|
|
Edit the scenario on the spreadsheet.
|
5.
|
|
Click Capture.
|
6.
|
|
In the Capture scenario as dialog box, type the name of the scenario in the Scenario name box.
|
•
|
|
You can save the scenario you edited as a new scenario by typing a new name in the Scenario name box.
|
To rename a scenario group |
1.
|
|
Click Tools Scenario Edit.
|
2.
|
|
Click Settings.
|
3.
|
|
In the Scenario group settings dialog box, click Rename.
|
4.
|
|
In the Rename group dialog box, type the new name in the New group name box.
|
To highlight cells |
1.
|
|
Click Tools Scenario Edit.
|
2.
|
|
Click Highlight.
|
3.
|
|
In the Scenario manager highlight dialog box, open the Changed cells color picker, and click a color.
|
4.
|
|
Open the Result cells color picker, and click a color.
|
•
|
|
By default, changed cells are yellow; result cells are green.
|
To delete scenarios | o/en/source/images/btnbacktotopproc.gif" alt="Back to Top" border="0" height="10" width="10"> |
1.
|
|
Click Tools Scenario Edit.
|
If the scenario is in another scenario group, choose the group name from the Scenario groups list.
|
2.
|
|
Choose a name from the Scenarios list.
|
3.
|
|
Click Delete.
|
To delete a scenario group |
1.
|
|
Click Tools Scenario Edit.
|
2.
|
|
Click Settings.
|
3.
|
|
In the Scenario group settings dialog box, choose a group from the Scenario groups list box.
|
4.
|
|
Click Delete.
|