To create scenarios, first complete a worksheet with the desired values and calculations.
Then proceed as follows:
| 1. | Choose the ribbon command Data | group Analyze | Scenario manager  . |
| 2. | Click on Add in the dialog box that opens. |
| 3. | Under Scenario name, enter a name that describes the purpose of the scenario. |
| 4. | Under Changing cells, enter the address of the cell whose content is to be changed in the scenario. |
| You can also specify multiple cells. Separate the cell addresses with a comma – for example: A2,A4,A10. Cell ranges (like B5:B10) are also allowed. |
| 5. | Click on the Next button to continue. |
| 6. | Another dialog box appears. There, enter the value that is to be inserted into the "changing cell" in this scenario. |
| If you have defined multiple changing cells in the scenario, this dialog box displays a list of all these cells. Click on each list entry and enter the desired value next to it. |
| 7. | Click on Finish to complete the creation of this scenario. |
| 8. | Repeat steps 2. to 7. for all other scenarios that you want to create. |
| 9. | When you have finished, exit the dialog box with the Close button. |
The desired scenarios have now been created. For information on how to display them, see the next section.
Options of the dialog box
The dialog box for adding scenarios offers the following additional options:
▪Comment
| Here, you can enter a descriptive comment for the scenario. |
▪Prevent changes
| If this option is enabled, the scenario cannot be edited or deleted if you enable sheet protection. |
▪Hide
| If this option is enabled, the scenario is no longer displayed in the list of scenarios when you enable sheet protection. |
For more information on using sheet protection, see Sheet protection.