|
Click the Data tab.
Click the What-If Analysis button,
and then click Scenario Manager.
|
|
 |
|
|
 |
|
Type a name that identifies the scenario.
|
|
 |
|
Type the cells you want to modify in the scenario.
|
|
 |
|
Select the Prevent changes check box to protect the cell.
|
|
 |
|
|
 |
|
Type values for each of the displayed changing cells.
|
|
 |
|
Then Click OK. Click Close.
|
|
 |
No comments:
Post a Comment