Skip to main content

Microsoft Excel Scenarios

A scenarios is a set of values that Microsoft Excel saves and can substitute automatically in your worksheet. You can use scenarios to forecast the outcome of a worksheet model. You can create and save different groups of values on a worksheet and then switch to any of these new scenarios to view different results.

Steps to perform scenarios in MS Excel 2003 are ::

Select only data (not heading & item name) > Go to Tools menu > Scenario > Add > Type scenario name > OK > Cell address for changing data > OK > Scenario Values dialog box open, enter the new value > OK > Scenario Manager dialog box opens, click on Summary > Result Cells > OK



Steps to Edit Scenarios in MS Excel 2003

Go to Tools menu  >  Scenarios  >  Click on the  name of the scenarios which you want to edit, and then click Edit  >  Make the changes you want  >  In the Scenarios Values dialog box, type the values you want for the changing cells  >  To save the changes click OK. 

To return to the Scenarios Manager dialog box without changing the current scenarios, click Cancel.