1-866-245-5224 sales@keystonelearning.com

Excel 2007: Editing & Removing Scenarios

Excel 2007: Editing & Removing Scenarios

If you completed the previous section, you can probably figure out the steps for editing and removing scenarios.

Editing Scenarios

     
  1. Click the What-If Analysis command in the Data Tools group on the Data tab
     
  2.  
  3. Choose Scenario Manager…
     

Figure 40. Scenario Manager Dialog Box

    3.       Click the name of the scenario that you want to Edit

    4.       Click Edit…

    5.       Change the Name, Range or Comments

    6.       Click OK

    7.       Change the Values

    8.       Click OK

Deleting Scenarios

     
  1. Click the What-If Analysis command in the Data Tools group on the Data tab
     
  2.  
  3. Choose Scenario Manager…
     
  4.  
  5. Click the name of the scenario that you want to Delete
     
  6.  
  7. Click Delete
     
  8.  
  9. Click Close