Scenario Manager in Excel: How It Works and When to Use It

How-to basics · Updated November 21, 2026

Scenario Manager in Excel is a What-If Analysis tool for saving different sets of input values and comparing how they affect formula results. In Microsoft Excel for Microsoft 365 on Windows, open Data > What-If Analysis > Scenario Manager to create, show, and summarize those alternatives without manually retyping inputs each time.

What Scenario Manager is for

Many spreadsheets produce results from assumptions that may change: sales volume, unit price, expenses, staffing levels, or delivery dates. Scenario Manager lets you save named combinations of assumptions, such as “Conservative,” “Expected,” and “Growth,” then switch the worksheet between them. The formulas in the model recalculate using whichever scenario is currently shown.

It is useful when you want to compare a small number of coherent cases. For example, a business forecast might pair lower sales with a lower price in one case and higher sales with a higher price in another. Changing one assumption at a time can miss the effect of those combinations; a scenario preserves the whole set together.

The feature does not predict which outcome will happen, assign probabilities, or optimize a decision. It only applies the values you provide to the cells you identify and displays the resulting calculations. The quality of the comparison depends on the model and assumptions behind it.

How Scenario Manager works

A scenario has three main parts: a name, a set of changing cells, and a value for each changing cell. Changing cells are usually input cells such as quantities, rates, or costs. Result cells contain formulas that depend on those inputs. When you show a saved scenario, Excel places its stored values into the changing cells and recalculates dependent formulas.

For example, suppose a simple product model uses B2 for units sold, B3 for selling price, B4 for variable cost per unit, and B5 for fixed costs. B6 calculates revenue, B7 calculates total cost, and B8 calculates profit. With units in B2 and price in B3, revenue in B6 can be calculated with =B2*B3. With variable cost in B4 and fixed costs in B5, total cost in B7 can be calculated with =B2*B4+B5. With revenue in B6 and total cost in B7, profit in B8 can be calculated with =B6-B7.

Using 100 units, a $25 selling price, a $15 variable cost per unit, and $800 in fixed costs gives revenue of $2,500, total cost of $2,300, and profit of $200. If you save 80, $24, and $16 as the first three changing values, with fixed costs unchanged at $800, the resulting profit is -$160: revenue is $1,920 and total cost is $2,080. A growth case of 130 units, $27 per unit, and $14 variable cost produces $890 profit: revenue is $3,510 and total cost is $2,620. The model formulas stay the same; Scenario Manager swaps the assumptions.

Create and compare scenarios on Windows

Before creating scenarios, build and check the worksheet model. Keep assumptions in clearly labeled input cells and calculations in separate formula cells. In the example, select B2:B4 as the changing cells if fixed costs are meant to remain the same for every case. You could include B5 as well if each case should have its own fixed-cost assumption.

  1. On the ribbon, choose Data > What-If Analysis > Scenario Manager.
  2. Select Add. Enter a descriptive scenario name, such as Conservative, and confirm or select the changing cells. You can select nonadjacent cells by holding Ctrl while selecting them.
  3. In the Scenario Values dialog, enter the values for the changing cells in the order shown. Check that each value corresponds to the intended input.
  4. Choose Add to enter another scenario, or select OK to finish adding scenarios.
  5. In Scenario Manager, select a scenario and choose Show to apply it to the worksheet. Check the result cells and repeat with the other scenarios.

Excel allows up to 32 changing cells in a scenario, so the tool is intended for compact sets of assumptions rather than models with hundreds of independent inputs. Give scenarios names that explain the case, not just labels such as “Scenario 1.” If a value is easy to confuse with another input, verify the changing-cell order in the dialog before saving.

Make a scenario summary report

For a side-by-side comparison, select Summary in Scenario Manager. Excel asks for a report type and result cells. Choose Scenario summary to create a worksheet report, then select the formula cells whose outcomes matter—for example, B6:B8 for revenue, total cost, and profit. The report lays out the scenarios and their changing and result values so readers can compare them without repeatedly showing each case in the model.

You can also choose a Scenario PivotTable report where that option is available. A PivotTable-style layout can be useful when you want to rearrange or further analyze the reported values. A regular scenario summary is usually the more straightforward choice for a compact comparison.

A summary report is a report of values at the time it is created, not a live dashboard that automatically changes whenever assumptions or formulas change. If you revise the model or scenario inputs, create a fresh report when you need an up-to-date comparison. Keep the scenario names and result-cell labels clear, since the report is much less useful if readers cannot tell what each number represents.

Choosing changing cells and result cells

Changing cells should represent genuine assumptions that you want to vary. They should generally be input cells, not formula cells. If you include a formula cell as a changing cell, showing a scenario can replace its formula with a stored value. That can break the model or make later results misleading. A safer design is to keep formulas outside the changing-cell range and use dedicated input cells for assumptions.

Result cells are usually formulas that summarize the effect of the inputs: profit, total cost, required staffing, or a project completion measure. Select only results that help answer the decision question. In the product example, profit may be the key result, while revenue and cost help explain why it changes. If a result cell is blank or does not depend on the changing cells, it will not provide a meaningful comparison.

For a large model, use descriptive labels next to the input and result cells. Before sharing a report, check each scenario by showing it and confirming that the worksheet displays the intended values. Scenario Manager stores scenarios in the workbook, so keep the workbook itself with the report if another person needs to edit or inspect those scenarios.

Scenario Manager compared with other what-if tools

Excel includes several What-If Analysis features, and they answer different questions. Scenario Manager compares named sets of multiple input values. A one-variable or two-variable Data Table shows how formula results change across a grid of one or two input values. Goal Seek works in the opposite direction: it finds an input value that makes one formula reach a target. Solver, a separate add-in, can search for a solution subject to constraints.

  • Use Scenario Manager when you want to save and switch among a few named cases, each with several assumptions.
  • Use a Data Table when you want a systematic grid of possible values for one or two inputs.
  • Use Goal Seek when you know the desired result and want Excel to find one input that achieves it.
  • Consider Solver when a problem involves an objective and constraints across multiple variables.

These tools are not interchangeable. For instance, a manager comparing three planned staffing-and-demand combinations may find scenarios convenient. Someone who wants to see profit at every combination of five prices and ten sales volumes needs a broader table or another analysis method; manually creating dozens of named scenarios is cumbersome.

Common problems and limitations

A frequent source of confusion is that showing a scenario changes the worksheet’s current input values. It is not merely a preview window. If you want to preserve the original inputs, record them as a scenario too, or save a copy of the workbook before exploring alternatives. You can also show the scenario you want to leave active when finished.

Another common issue is choosing the wrong cells or entering values in the wrong order. If a scenario produces an implausible result, reopen Scenario Manager, inspect the changing-cell selection, and show the scenario again. Also confirm that the formulas reference the intended input cells and that the result cells recalculate as expected.

Scenario Manager is designed for a limited number of changing cells and discrete cases. It does not automatically calculate probabilities, produce a risk distribution, or prove that a scenario is realistic. It may also be a poor fit when assumptions change frequently or when many possible values need to be explored. A carefully labeled model, a Data Table, or a more specialized analysis may be easier to maintain in those situations.

Availability on Mac and Excel for the web

On Excel for Microsoft 365 for Windows, the ribbon path is Data > What-If Analysis > Scenario Manager. Excel for Mac has a Scenario Manager feature in desktop Excel, though ribbon organization and the exact placement can differ by release. Look on the Data tab for What-If Analysis and Scenario Manager, and consult the commands available in the installed version if the path differs.

Excel for the web does not provide the full desktop Scenario Manager workflow for creating and managing scenarios. A workbook containing scenarios may still be opened in the browser, but use the desktop Excel app when you need to create, edit, show, or generate reports from scenarios. If collaborating with someone using the web version, agree on which desktop user will maintain the scenario setup.

Frequently Asked Questions

What is Scenario Manager used for in Excel?

It saves named sets of input values and applies them to a worksheet so you can compare their effects on formulas. It is commonly used for forecasts, budgets, and other models with a few alternative cases.

How many changing cells can a scenario have?

Excel supports up to 32 changing cells in one scenario. If your analysis needs more independent inputs, consider reorganizing the model or using another method rather than trying to force a large model into a single scenario.

Does showing a scenario overwrite my formulas?

It replaces the values in the cells designated as changing cells. If a formula cell is included in that selection, its formula can be replaced by a scenario value, so use input cells for changing assumptions and keep calculation cells separate.

Does a Scenario Summary update automatically?

No. The summary is generated as a report of the scenario results at that time. If you change assumptions, formulas, or scenarios, generate a new summary to reflect the updated model.

Can I use Scenario Manager in Excel for the web?

The web version does not include the full Scenario Manager creation and editing tools. Open the workbook in desktop Excel for the scenario-management workflow.

When Scenario Manager is the right choice

Scenario Manager is a practical choice when you have a working formula model and want to compare a handful of named, internally consistent alternatives. It makes those assumptions repeatable and can produce a useful summary, while leaving the underlying formulas intact when changing cells are chosen correctly. For a larger grid of possible values, a target-seeking question, or a probability-based risk analysis, use a tool suited to that specific job instead.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.