Scenario Manager Update In Excel

Here is an update to the Scenario Manager post we did previously:

We previously did a post on Scenario Manager, but today we are going to add a nice twist to simplify the access of the various scenarios. Here we have a range of 3 products and we want to change the Price by varying the factor under Adjustment:


We will create our various scenarios by changing the value of the Adjustment. I’ll highlight cells M1:M2 where the Adjustment is, then click on the Scenario Manager option from the What-If Analysis button on the Data tab:


When the Senario Manager dialog box pops up, click Add…:


Name the Scenario (I’ve chosen “Original” – no spaces):


Click OK. Excel will enter the data from the highlighted fields. You can have several labels and fields in your scenarios. I’ve just chosen one here for simplicity:


Click OK again and you will see that it’s added to the Scenario Manager:


To add the next scenario, close this dialog box, change the adjustment, highlight cells M1:m2 again, open the Scenario Manager and click Add:


After going through the full process for each, I’ve now added 4 scenarios. To view the results of any one, highlight it and click “Show” and the values for that scenario will appear in my data range:


At this point I have created my 4 scenarios. To view any of them, I will need to click on the What-If Anaylysis from the Data tab, choose Scenario Manager, select any of my options and click Show.

But wait! There’s an easier way to toggle through the scenarios!

Right-click on the Quick Access Toolbar and choose Customize Quick Access Toolbar:


Select “All Commands” at the top, then click on Scenario and Add it to your QAT:


Excel has now put an icon in your Quick Access Toolbar that allows you to select any of your scenarios and toggle through the options to see your results:



Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply