In Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Scenario Manager to save and compare different sets of input values in the same worksheet model. Add a scenario, choose its changing cells, enter a set of values, and use Show or Summary to see how the model’s results change.
What Excel Scenario Manager does
Scenario Manager is Excel’s built-in tool for what-if analysis. It stores named sets of values for selected worksheet cells, then places those values into the worksheet so you can see the resulting outputs. Each saved set is a scenario. For example, a sales plan might have a “Lower demand,” “Expected,” and “Higher demand” scenario, with each one assigning different values to forecast inputs.
The tool is useful when a model has a small number of meaningful cases that you want to revisit or compare. Instead of typing a new set of assumptions over the old ones each time, you can save the sets under recognizable names. Scenario Manager changes the selected input cells; formulas elsewhere in the workbook recalculate as usual.
It does not forecast which case is likely, calculate probabilities, or explain why an outcome occurred. The results depend on the formulas and assumptions already in the workbook. A scenario is a saved “what if these inputs were different?” case, not a prediction or a recommendation.
How the feature works
A scenario has a name, a list of changing cells, and a value for each changing cell. The changing cells are typically assumptions such as price, hours, quantity, or costs. Result cells are not scenario inputs: they are cells containing formulas whose outputs you want to inspect. When you show a saved scenario, Excel puts its stored values into the changing cells and recalculates dependent formulas.
Scenario Manager allows up to 32 changing cells in a scenario. The cells do not need to be adjacent, but selecting a compact group of input cells makes a model easier to maintain. The tool is best suited to a manageable set of cases, rather than a large grid of every possible combination.
For example, imagine a simple project-cost model with hours, hourly rate, and fixed costs as inputs. With hours in B2, hourly rate in B3, fixed costs in B4, and total cost in B6, the result formula is =B2*B3+B4. If B2 is 120, B3 is 45, and B4 is 3000, the total is 8,400: 120 × 45 + 3,000. A lower-cost case could use 100 hours, a rate of 42, and fixed costs of 2,500, producing 6,700. A larger-project case of 150 hours, 48 per hour, and 4,000 in fixed costs produces 11,200.
Create and save a scenario
Before opening Scenario Manager, identify the worksheet cells that contain assumptions and the formula cells that report the results. In the example above, B2:B4 are inputs and B6 is the output. Use clear labels beside the cells, so it is easy to understand what the values represent when reviewing scenarios later.
- On the worksheet, select the changing cells. You can select a range or nonadjacent cells; on Windows, hold Ctrl while selecting additional cells.
- Choose Data > What-If Analysis > Scenario Manager.
- Select Add, enter a descriptive scenario name, and check that the Changing cells reference is correct. Add a comment if the reason for the assumptions is not obvious.
- Select OK. In the Scenario Values dialog, enter one value for each changing cell, in the order shown, then select OK.
- Repeat the Add process for each case you want to retain. Use names that explain the assumptions, such as “Lower demand” or “Supplier increase,” rather than generic labels like “Scenario 2.”
Excel normally starts the new scenario with the current values in the changing cells. Check every value in the Scenario Values dialog rather than assuming it has been replaced. If the case represents a dated plan or a particular business decision, include that context in the name or comment.
Show a case or make a comparison report
To apply one saved set of assumptions, open Scenario Manager, select the scenario, and choose Show. Excel writes that scenario’s values into the changing cells on the worksheet. The formulas that depend on those cells recalculate, so you can inspect the outputs in place. Showing a different scenario replaces the values currently in those cells; it does not create a separate model copy.
For a side-by-side view, select Summary in Scenario Manager. Choose Scenario summary for a worksheet report, or Scenario PivotTable report where that option is available. In the dialog, specify the result cells: these should be the outputs you want to compare, such as total cost, margin, or forecast revenue. You can select more than one result cell.
Excel creates the report on a new worksheet, showing the scenarios’ changing values alongside the selected results. Give the changing and result cells clear worksheet labels before generating the report; readable labels make the report far more useful than a list of cell references. Treat a summary as a report generated from the model’s current setup. If you change formulas or assumptions and need an updated comparison, generate a fresh summary rather than assuming an existing report reflects later edits.
Choose useful inputs and outputs
Good scenarios vary assumptions that are both important to the result and plausible for the question being explored. If every case changes many unrelated inputs, it becomes difficult to tell which assumptions drive the difference. Conversely, changing only one value may not represent a realistic situation if other inputs would naturally move with it.
- Keep inputs separate from calculations. Use dedicated cells for assumptions and formula cells for calculated results. This makes it clear what Scenario Manager should change.
- Choose a small number of understandable cases. A baseline, a cautious case, and an optimistic case may answer a planning question better than dozens of slightly different sets.
- Use meaningful result cells. Select outputs that help answer the decision at hand. A report with dozens of unrelated results can obscure the important comparison.
- Document assumptions. Record where a price, rate, or volume estimate came from, and distinguish a deliberately hypothetical case from an approved plan.
In the project-cost example, changing hours, hourly rate, and fixed costs together could represent different project sizes or contract conditions. But if the question is only “What if the hourly rate rises?”, hold the other inputs constant and vary the rate. That makes the comparison easier to interpret. Scenario Manager will calculate the result from the values supplied; it will not check whether those values are realistic or internally consistent.
Scenario Manager compared with other what-if tools
Excel has several what-if tools, and they answer different questions. Scenario Manager is a practical choice when you want to save and name a few bundles of assumptions. Other tools can be more efficient when the analysis has a different shape.
- Goal Seek works backward from a desired formula result by changing one input cell. For example, it can find the price needed to reach a target total, if the model’s formulas support that relationship. It is for a target value, not for storing several named input sets.
- Data Tables calculate a formula across many values for one or two inputs. They are useful for sensitivity grids, such as seeing how a result changes across a range of prices and quantities. They are less suited to named cases in which several assumptions move together.
- Solver searches for an optimum while respecting constraints, when the Solver add-in is available and configured. It addresses optimization questions, such as maximizing an output subject to limits, rather than simply comparing a few manually chosen cases.
- Separate worksheet copies can work for highly different models, but they can become difficult to keep synchronized. If formulas are changed on one copy and not the others, comparisons may no longer be fair.
These tools are not interchangeable. A common misconception is that Scenario Manager automatically identifies the best or most likely scenario. It does neither: it displays the results for the values you enter. If you need an objective function, constraints, or a systematic search, consider whether Solver or another analysis method fits the problem better.
Editing, deleting, and protecting scenarios
To revise a saved set, open Scenario Manager, select its name, and choose Edit. You can change the scenario name, the changing-cell references, and the stored values. Use Delete to remove a scenario you no longer need. Deleting a saved scenario does not delete the worksheet’s formulas or inputs, but it does remove that stored set from the manager.
The Add and Edit dialogs include options related to preventing changes and hiding a scenario. These are worksheet-protection controls, not a replacement for securing sensitive information. Workbook users may still be able to inspect data through other routes, depending on protection settings and access to the file. Avoid treating a hidden scenario as confidential.
Because showing a scenario changes worksheet inputs, consider saving a copy before experimenting in an important workbook. You can also note the original input values or save the workbook with a clearly identified baseline. Scenario Manager stores scenarios in the workbook; it does not create an independent file or preserve a complete separate copy of every formula and worksheet state.
Availability and common issues
In Excel for Microsoft 365 on Windows, use the Data tab’s What-If Analysis menu to open Scenario Manager. In Excel for Mac, the feature is also accessed from the Data tab’s What-If Analysis area in supported desktop versions, although the ribbon layout can differ. Excel for the web does not provide the desktop Scenario Manager commands for creating and managing scenarios, so open the workbook in the desktop app to work with them.
If the output does not change as expected, check that the selected changing cells are the actual inputs used by the formulas. A scenario can appear to do nothing if the result formula refers to different cells, if calculation is not updating as expected, or if the displayed result is on another sheet and is not included among the selected result cells. Also verify that the values were entered in the correct order in the Scenario Values dialog.
Another frequent point of confusion is the difference between showing a scenario and generating a summary. Show applies the values to the worksheet’s changing cells. A Summary creates a report for comparison. If you show a scenario and then continue editing the worksheet, the visible model reflects those current values; it is not automatically returned to the original starting state. Select the desired scenario again, or restore your baseline values deliberately.
Frequently Asked Questions
Where is Scenario Manager in Excel?
In Excel for Microsoft 365 on Windows, choose Data > What-If Analysis > Scenario Manager. Excel for Mac places the command in the Data tab’s What-If Analysis area in supported desktop versions. Excel for the web does not offer the desktop tool for managing scenarios.
How many cells can a scenario change?
A Scenario Manager scenario can use up to 32 changing cells. Choose input cells that genuinely drive the model, and use formulas in separate result cells to calculate the outcomes.
Does Scenario Manager change the original worksheet?
Showing a scenario writes its stored values into the changing cells on the worksheet. It does not make a separate worksheet copy of the model. Save a copy or record the baseline inputs if you need to preserve the original working state.
Can Scenario Manager compare results automatically?
It can create a Scenario Summary or, where available, a Scenario PivotTable report for selected result cells. The tool compares the cases you have defined; it does not select the best case or assign probabilities to them.
Why can’t I find Scenario Manager in Excel for the web?
The web version does not include the desktop Scenario Manager commands for creating and managing scenarios. Open the workbook in desktop Excel for Windows or a supported Mac version to use the feature.
Related
- Load Excel Power Query Into an Existing Table
- Linear Programming Excel Solver Template: Build and Use One
- Link Excel Data to a PowerPoint Table and Keep It Updated
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Power Query JSON: Import, Expand, and RefreshIn Excel for Microsoft 365 on Windows, import a JSON file with Data > Get Data > From…
- Insert Image in Excel Cell Without Resizing Rows or ColumnsIn Excel for Microsoft 365 on Windows, use Insert > Pictures > Place in Cell to put an…
- Excel Text Running Over Cells: Fixes and FormattingIf Excel text is running over neighboring cells, choose Home > Wrap Text to display it on multiple…
- How to Delete a Page in Word Online: Step-by-Step GuideTo delete a page in Word Online, remove the text, objects, or formatting marks that are making it…
- Excel Data Validation List from a Table: How to Set It UpYes. In Excel for Microsoft 365 on Windows, create a workbook-level name that refers to the table column,…
- How to Change Double Spacing to Single Spacing in WordTo change double spacing to single spacing in Word, select the text (press Ctrl+A on Windows or Command+A…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.