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

After applying What-If Analysis, Excel will often prevent the deletion of data from the source data or the output. In this article, we will explain how to delete What-If Analysis data in Excel using 2 simple and quick methods.

Suppose we have the dataset below of a company’s monthly Sales and Profit Margin and have applied What-If Analysis from the Scenario Manager to this data. Now we want to delete some of the data.


Method 1 – Deleting What If Analysis by Selecting the Whole Table

Sometimes after obtaining forecast data from What-If Analysis in Excel, we cannot delete data from the cells. Here’s how to do it:

Step 1:

In the image below, we have applied What-if Analysis to our dataset in columns E:F to obtain the increase in product quantity.

Delete What If Analysis by Selecting Whole Table

  • Select a cell (for example F7) and press Delete.

A window will pop up saying “Can’t change part of a data table”.

  • Click OK.

Delete What If Analysis by Selecting Whole Table

  • Now select cells F6:F11 and press Delete.

The blank cells confirm that the What-If Analysis has been deleted.

Delete What If Analysis by Selecting Whole Table

Step 2:

To delete just some data, not the whole dataset:

  • Select the range F6:F11 and press Ctrl+C to copy.

Delete What If Analysis by Selecting Whole Table

  • Press Alt+E+S+V to paste as values.

  • Now select any cell (for example F10) and click Delete.

Delete What If Analysis by Selecting Whole Table

The cell is deleted.

Delete What If Analysis by Selecting Whole Table

Read More: What If Analysis Data Table Not Working


Method 2 – Using the Scenario Manager to Delete What If Analysis

The Scenario manager feature is mostly used for financial calculations and forecasts in Excel, delivering analysis in Scenarios. Here, we will explain how to remove these Scenarios from our worksheet.

Steps:

Suppose that in our dataset we have already applied 3 Scenarios from the What-if Analysis feature in Excel.

  • Go to Data > Forecast > What-if Analysis > Scenario Manager.

Remove Scenario Manager to Delete What If Analysis

  • In the Scenario Manager dialog box that opens, the 3 Scenarios for our data table are listed.

  • To delete a Scenario, select it and click Delete.

Remove Scenario Manager to Delete What If Analysis

  • Press Close.

The corresponding What-if Analysis is deleted from our sheet.

Remove Scenario Manager to Delete What If Analysis


Things to Remember

  • Directly open the Scenario Manager by holding down the Alt key and pressing T+E .

Download Practice Workbook


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo