How to Remove Scenario Manager in Excel (2 Easy Ways)

What Is Scenario Manager?

The Scenario Manager can compare datasets with different values. You can change the set of values and perform an analysis to see which scenario suits you better. For example, you have two scenarios. In the first one, you work at a company near your home for $2,000. As it is near your residence, the fuel cost is low and that is $50. In the second scenario, you get an offer from another company with a salary of $2,700. But, the company is far from your home, so you need to pay a higher fuel cost of $150. You can compare these two scenarios and get the best output using the Scenario Manager in Excel.

You can find the Scenario Manager in the Data tab, under the WhatIfAnalysis option.

Read More: Scenario Analysis in Excel


How to Remove the Scenario Manager in Excel: 2 Easy Ways

We will use a dataset that contains the income and expenses of an employee of a company.

We can move to Scenario 2 with the help of the Scenario Manager.

In the second scenario, the employee gets a job offer from another company with a salary of $2700. But the office is far from his residence. So, it takes more fuel from the previous scenario. In this case, the Fuel cost is $150. So, at the end of the month, he lefts with $2100. We can get this information using the Scenario Manager.


Method 1 – Remove the Scenario Manager Using the Data Tab in Excel

STEPS:

  • Go to the Data tab and click on the What-If-Analysis option. A drop-down menu will appear.
  • Select Scenario Manager from there.

Remove Scenario Manager Using Data Tab in Excel

  • In the Scenario Manager, you will see two scenarios.
  • Select the scenario you want to delete and click on the Delete option.

Remove Scenario Manager Using Data Tab in Excel

  • Select the remaining Scenario and click on the Delete option.

Remove Scenario Manager Using Data Tab in Excel

  • Click on Close to remove the scenario manager.

Remove Scenario Manager Using Data Tab in Excel


Method 2 – Apply a Keyboard Shortcut to Delete Excel Scenario Manager

STEPS:

  • Hold the Alt key and press T + E on the keyboard.
  • This will open the Scenario Manager.
  • Select Scenario 1 and click on the Delete option. The first scenario will be deleted.

Apply Keyboard Shortcut to Delete Excel Scenario Manager

  • Select Scenario 2 and click on the Delete option again.
  • Repeat for other scenarios if needed.

Apply Keyboard Shortcut to Delete Excel Scenario Manager

  • Click on the Close option to remove the Scenario Manager.

Apply Keyboard Shortcut to Delete Excel Scenario Manager


Download the Practice Workbook


Related Articles


<< Go Back to What-If Analysis in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo