To create scenarios, first create a worksheet with the calculations that you want to analyze.
Then proceed as follows:
| 1. | Choose the ribbon command Data | group Analyze | Scenario manager  . |
| 2. | Click Add in the opened dialog box. |
| 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 altered 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 allowed as well. |
| 5. | Click 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 multiple changing cells are defined in the scenario, the dialog box displays a list of these cells. Click on each list entry and enter the desired value for it. |
| 7. | Click the Finish button to finalize this scenario. |
| 8. | Repeat the steps 2. through 7. for all further scenarios that you want to add. |
| 9. | When done, close the dialog box with the Close button. |
The scenarios have now been created. To learn how to display them, see the next section.
Options of the dialog box
In the dialog box for adding scenarios, the following additional options are available:
▪Comment
| Allows you to enter a comment for the scenario. |
▪Prevent changes
| When this option is enabled, the scenario can no longer be modified or deleted when you activate worksheet protection. |
▪Hide
| When this option is enabled, the scenario is no longer displayed in the list of scenarios when you activate worksheet protection. |
Tip: For general information on working with worksheet protection, see Sheet protection.