How to Delete What If Analysis in Excel (2 Simple Methods)

While working in Microsoft Excel sometimes we need to delete data that we got applying what-if analysis. But it seems difficult as we can not delete a single piece of data from a cell. But no worries I have a proper solution for this. Today in this article, I am going to share with you how to delete what-if analysis in excel. Stay tuned.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


2 Easy Methods to Delete What IF Analysis in Excel

In the following, I have shared 2 simple and quick methods to delete what-if analysis in excel. You can check this link to learn about how to apply what if analysis in excel.

Suppose we have a dataset of a company’s monthly Sales and Profit Margin in our hands. Now we will apply the data table and scenario manager what-if analysis on the basis of the range and delete them.


1. Delete What If Analysis by Selecting Whole Table

Sometimes after getting forecasted data using the what-if analysis in excel, we cannot delete data from the cells. But if you use this method’s proper step-by-step procedure, you can complete the task efficiently. Follow the steps below-

Step 1:

  • Above all, as you can see we have applied data table analysis from the “What-if Analysis” option in excel in a new column (E: F) according to the increase in product quantity.

Delete What If Analysis by Selecting Whole Table

  • Now, choose a cell (F7) and press “delete”.

  • Simply, it won’t delete and a new window will pop-up saying “Can’t change part of a data table”.
  • Although you don’t have to worry at all. Press OK from the popped-up dialog box.

Delete What If Analysis by Selecting Whole Table

  • This time, choose cells (F6:F11) from the list and press Delete from the keyboard.

  • In summary, you will see blank cells that confirm deleting what-if analysis in excel.

Delete What If Analysis by Selecting Whole Table

While working with the what-if analysis sometimes it becomes important to delete some data, not the whole dataset. In the previous steps, I have shown how to delete what-if analysis by removing the whole dataset. But in order to delete some data just follow the steps below-

Step 2:

  • Starting with, choose cell (F6:F11) and press Ctrl+C to copy.

Delete What If Analysis by Selecting Whole Table

  • Now, press Alt+E+S+V to paste as values.

  • Hence, select any cell. Here I have selected cell (F10) and clicked “delete”.

Delete What If Analysis by Selecting Whole Table

  • Finally, you can delete only one cell even after applying what-if analysis in excel. Enjoy!

Delete What If Analysis by Selecting Whole Table

Read More: How to Perform the What If Analysis with Data Table in Excel


Similar Readings


2. Remove Scenario Manager to Delete What If Analysis

Scenario manager is mostly used for financial calculation in excel. Business professionals often want to see the forecasted analysis of their business according to the changes in multiple variables. In this method, I am explaining to you how to remove the scenario manager in excel.

Steps:

  • Starting with, our dataset, we have already applied 3 types of scenarios from the “What-if Analysis” feature in excel.
  • Simply, go to Data > Forecast > What-if Analysis > Scenario Manager.

Remove Scenario Manager to Delete What If Analysis

  • After that, in the new dialog box of “Scenario Manager”, you will see we have 3 types of scenarios for our data table.

  • In order to delete a scenario select a scenario of your choice from the list and press “Delete”.

Remove Scenario Manager to Delete What If Analysis

  • Hence, Press “Close”.
  • In conclusion, we have successfully deleted the what-if Analysis in excel without any hesitation.

Remove Scenario Manager to Delete What If Analysis

Read More: How to Do What-If Analysis Using Scenario Manager in Excel


Things to Remember

  • If you want you can directly open the “Scenario Manager” by holding the Alt key and then pressing T+E on your keyboard.

Conclusion

In this article, I have tried to cover all the methods to delete the What If analysis in excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo