For this tutorial, let’s use a simple set so you would be able to see the difference between different scenarios.
In this case, we would want to change all the “A” variables into “B”:
- Scenario B
- Primary value B
- Secondary value B
- Total B
To start, select the cells with the values you want to change.
Note that you can only select a maximum of 32 changing cells.
In our example, it’s B2, B4, B5, and B7.
Then, follow these steps:
- Go to the ‘Data’ tab
- Click the ‘What-If Analysis’ button
- Select ‘Scenario Manager…’
On the ‘Scenario Manager’ window, click on the ‘Add…’ button.
On the next window, give your scenario a title or a name. (Let’s name it “Scenario B”.)
If you like, you could also protect your scenarios by preventing any changes or hiding it from others.
Click on the ‘OK’ button once you’re ready to proceed.
After that, a new window will appear where you can enter the values for your new scenario.
Click the ‘OK’ button to proceed.
That’s it! You just created a new scenario in Excel! 👍
As you can see, you can either add, delete, edit, merge, or summarize your scenarios.
Summarizing your scenarios would be creating a data table or a pivot table report of all your scenarios.