Excel Scenario Manager: How to Compare What-If Cases

Formulas & functions · Updated November 21, 2026

Excel Scenario Manager is a What-If Analysis tool that saves different sets of input values and shows how each set affects formula results. In Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Scenario Manager, add scenarios using the cells whose values should change, then create a Scenario Summary report to compare the results.

What Scenario Manager is for

A spreadsheet model often depends on assumptions: sales volume, price, costs, staffing, delivery time, or another set of inputs. Scenario Manager lets you save several named combinations of those assumptions in one workbook. You can switch between them without manually retyping each value, and you can generate a report that puts the cases side by side.

For example, a small business forecast might have a cautious case, a planned case, and a higher-demand case. Each case could use different assumptions for units sold, selling price, unit cost, and fixed expenses. If a profit cell contains a formula based on those inputs, Excel recalculates it when you show a scenario. The feature is useful for comparing defined cases; it does not decide which assumptions are most likely or choose an optimal answer.

Scenario Manager is part of Excel’s What-If Analysis tools, alongside Goal Seek and Data Tables. It is best suited to comparing several complete sets of inputs, especially when multiple assumptions change together.

How scenarios and changing cells work

A scenario consists of a name, a group of changing cells, and a saved value for each changing cell. A changing cell should normally be an input in your model, rather than a formula cell. Result cells are different: they contain formulas that calculate what the inputs mean, such as total revenue or profit.

When you show a scenario, Excel places its saved values in the changing cells and recalculates dependent formulas. You can then show a different scenario to replace those inputs with another saved set. The workbook’s formulas remain in place; it is the assumptions that change.

Excel allows up to 32 changing cells in a single scenario. They do not have to form one continuous range, but selecting a compact group of clearly labelled input cells makes a model easier to maintain. If a model needs more than 32 independent inputs in each case, consider whether the inputs can be grouped or whether another analysis method fits better.

Build a simple example model

Suppose a forecast uses four inputs: units sold, price per unit, cost per unit, and fixed costs. Put labels in column A and the corresponding input values in column B. For example, use A2:A5 for the labels and B2:B5 for the values: Units sold, Price per unit, Cost per unit, and Fixed costs. Put a Profit label in A7 and the profit formula in B7.

With units sold in B2, price in B3, unit cost in B4, and fixed costs in B5, enter this formula in B7:

=B2*(B3-B4)-B5

For an illustrative planned case, enter 1,000 units, a price of $25, a unit cost of $14, and fixed costs of $6,000. The formula returns $5,000: 1,000 multiplied by the $11 difference between price and unit cost, less $6,000 in fixed costs. These are example figures, not a forecast or financial recommendation.

Now the four input cells B2:B5 are the changing cells, and B7 is a result cell. Keeping assumptions separate from calculations is important: if a formula cell is accidentally included as a changing cell, the scenario may overwrite a calculation instead of testing an assumption.

Create and show scenarios in Excel

  1. Set up the model and check that its result formulas recalculate when you edit an input.
  2. On the Data tab, select What-If Analysis > Scenario Manager.
  3. Select Add. Give the scenario a clear name, such as Planned, and identify the changing cells. In the example, select B2:B5.
  4. Select OK. In the Scenario Values dialog, enter the values for that case in the same order as the changing cells, then confirm.
  5. Repeat the Add process for each additional case, using distinctive names such as Lower demand or Higher costs.
  6. In Scenario Manager, select a scenario and choose Show to apply its values to the model. Check the resulting formula cells.

Use names that communicate the assumptions, not just labels such as Case 1 and Case 2. You can add a short explanation in the worksheet beside the inputs—for example, what makes the lower-demand case different—so readers do not have to infer the story from the numbers. Keep a baseline or current-plan case if you need a reference point.

On Excel for Mac, Scenario Manager is available in the desktop application; the exact ribbon layout can differ between builds, so look on the Data tab for the What-If Analysis command. Excel for the web does not provide the full desktop Scenario Manager workflow. If you cannot find the command in a browser, open the workbook in desktop Excel.

Create a Scenario Summary report

A Scenario Summary report is usually the clearest way to compare cases without repeatedly switching between them. In Scenario Manager, choose Summary, select Scenario summary, and specify the result cells you want included. For the example, choose B7 as a result cell. Excel creates a report on a new worksheet with the scenarios and their input and result values.

Select result cells that answer the question the model is meant to address. A sales forecast might report revenue, gross profit, and cash requirement; a staffing model might report headcount and total hours. A report with too many unrelated outputs can hide the comparison that matters. Give the result cells descriptive labels in the original model, because those labels help readers interpret the report.

The report is a snapshot created from the scenarios at that time, not a substitute for a live dashboard. If you change the model, revise the scenarios, or want a report reflecting updated assumptions, create a fresh summary. Keep the original model and report clearly labelled so readers can tell which assumptions the comparison represents.

When to use it instead of other What-If tools

  • Use Scenario Manager when you have a few named cases, each with a set of related inputs, and want to compare their results.
  • Use Goal Seek when you know the result you want and need Excel to find one input value that reaches it. For instance, it can find a sales quantity that produces a target profit, changing one input cell at a time.
  • Use a one-variable or two-variable Data Table when you want to see how one or two inputs affect a formula across a range of values. A table is often more useful for a sensitivity grid, such as profit at several prices and sales volumes.
  • Consider Solver when the task is to optimize an objective subject to constraints, such as maximizing a result while keeping inputs within limits. Solver is a separate Excel add-in and is not the same as Scenario Manager.

These tools answer different questions. A named “high cost” scenario is a defined story; it is not a probability estimate. A Data Table can show many combinations, while Scenario Manager is easier to read when a small number of cases have meaningful names and assumptions.

Common problems and practical safeguards

If a scenario appears to have no effect, first check that the changing cells are the actual inputs used by the result formulas. Then confirm that the values were entered in the same order as the selected cells. A formula may also depend on a different input, a hard-coded number, or a cell outside the selected model area; in that case, changing the scenario will not update the result as expected.

Other useful checks include:

  • Confirm that the result cells contain formulas and are included when you request the summary.
  • Use cell labels and consistent units. Mixing dollars with thousands of dollars, or monthly values with annual values, can make a report misleading.
  • Save a copy before applying a scenario if you need to preserve the workbook’s current displayed inputs. Showing a scenario changes the values shown in its changing cells.
  • After changing assumptions, verify that formulas, number formats, and any charts still communicate the result correctly.
  • Use reasonable values and document the source of important assumptions. Scenario Manager stores cases; it does not validate whether their assumptions are realistic.

The Scenario Manager dialog also offers options to prevent changes to a scenario and to hide it. Those controls are not a security boundary for sensitive data. Do not rely on a hidden scenario or worksheet setting to protect confidential information in a workbook.

Frequently Asked Questions

Where is Scenario Manager in Excel?

In desktop Excel for Microsoft 365 on Windows, go to Data > What-If Analysis > Scenario Manager. Excel for Mac also has the feature in its desktop application, though ribbon placement can vary. The full Scenario Manager interface is not available in Excel for the web.

How many changing cells can a scenario have?

A single scenario can contain up to 32 changing cells. Choose input cells that directly drive your formulas, and avoid including formula cells that calculate results.

Can Scenario Manager compare formulas?

It compares the results produced by formulas when the saved input values are applied. Select formula cells as result cells for the summary, but use the cells supplying assumptions as the scenario’s changing cells.

Does a Scenario Summary update automatically?

Treat the summary as a report generated from the scenarios at the time you create it. If you change assumptions or the model and need an updated comparison, generate a new summary report.

What is the difference between Scenario Manager and Goal Seek?

Scenario Manager stores and compares several sets of input values. Goal Seek works backward from a target result to find a value for one input cell. Use the one that matches whether you are comparing cases or solving for a target.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.