How to Open Scenario Manager in Excel: Quick Steps

In Excel for Microsoft 365 on Windows, open the current worksheet’s Scenario Manager by selecting Data > What-If Analysis > Scenario Manager. It lets you save different sets of input values and see how they affect a formula-driven result. For best results, have a worksheet model ready, with input cells and formulas that use those inputs.

What You’ll Need

Excel desktop: Scenario Manager is a desktop Excel feature. It is not available in Excel for the web, so open the workbook in the desktop app if you are using a browser.
A workbook saved in an Excel format: Use a format such as .xlsx or .xlsm if you want to keep workbook features. CSV files do not preserve Scenario Manager data.
A worksheet and, ideally, a simple model: Identify the cells whose values you want to vary and the formula cells that show the effect. You can open Scenario Manager without preparing a model, but you will need changing cells to create a useful scenario.

Step-by-Step

Open the workbook and select the correct worksheet. Scenario Manager works with the active worksheet, so click the tab containing the inputs you want to compare. If you have several tabs with similar models, verify the sheet name before continuing. You can use a blank or unprepared sheet to open the tool, but it is easier to understand the dialog when the changing cells are already identified.
Identify the changing cells and the result you want to compare. Changing cells are the inputs that differ between cases, such as a price, quantity, hours worked, or estimated cost. A result cell usually contains a formula that depends on those inputs. For example, a worksheet might have a units-sold input and a price input, with a revenue formula that uses both. Scenario Manager stores alternate values for the inputs; it does not build the formulas or decide which cells matter for you.
Go to the Data tab. On the Excel ribbon, select Data. If the ribbon is minimized, expand it by selecting a tab or using the ribbon display control. On a narrow window, some commands may be collapsed into a menu, so maximize Excel or look for the What-If Analysis dropdown on the Data tab.
Open the Scenario Manager dialog. Select What-If Analysis, then choose Scenario Manager from its menu. The Scenario Manager dialog opens for the active worksheet. If you have not saved any scenarios on that sheet, the list will be empty; that is normal and does not mean the feature failed to open.
To create your first scenario, select Add. In the Add Scenario dialog, enter a clear name such as Base case, Higher price, or Lower demand. In the Changing cells box, specify the input cells whose values this scenario will store. Use the range selector to choose cells on the sheet, or enter their references. If the inputs are in separate locations, select or specify each changing cell; do not include formula result cells unless you intentionally want to replace their values.
Enter the values for that scenario. After you select OK, Excel displays the Scenario Values dialog with one entry for each changing cell. The entries are shown in the same order as the changing cells. Enter the values for the named case and select OK. Repeat Add for each additional case, using a distinct name and the appropriate inputs. You can store up to 32 changing cells in a scenario, so keep the model focused on the inputs you actually need to vary.
Show a scenario or compare the results. In Scenario Manager, select a scenario name and choose Show to put its saved values into the changing cells on the worksheet. The formulas that depend on those cells recalculate, letting you inspect the result. To create a comparison sheet, select Summary, choose either a Scenario summary or a Scenario PivotTable report, and identify the result cells to report. Select OK. Excel adds a report worksheet; the report is a snapshot, so create a fresh summary after changing scenario inputs if you need an updated comparison.

Common Mistakes

Looking for the command on the wrong tab: In desktop Excel for Windows, the usual path is Data > What-If Analysis > Scenario Manager. It is not under Formulas or Review.
Using output cells as changing cells: A formula cell should normally calculate the outcome, not be overwritten as an input. Select the assumptions that feed the formula instead.
Choosing the wrong worksheet: Scenario Manager is associated with the active sheet. If the dialog is empty or shows unexpected scenarios, close it, select the intended sheet, and open it again.
Assuming a scenario updates every sheet or every chart automatically: A scenario changes its listed input cells on the worksheet. Other sheets or charts respond only if their formulas and references depend on those cells.
Confusing saved values with live links: Each scenario keeps the values entered when it was created. If you later change an assumption on the sheet, that does not necessarily rewrite the values saved inside a scenario. Edit the scenario when you want to replace its stored values.

Tips

Use names that describe the assumptions. Names such as Conservative, Expected, and High demand are more useful than Scenario 1 and Scenario 2, particularly when you return to a workbook later.
Keep inputs together when practical. A clearly labeled assumptions area makes it easier to select changing cells, check the order of values, and understand what each scenario modifies.
Record units and context beside the inputs. Labels such as Units per month or Price per item reduce the risk of entering a value in the wrong scale. Scenario Manager stores values, not explanations of what the numbers mean.
Check the worksheet after selecting Show. Confirm that the changed inputs match the selected case and that the formulas still display sensible results. Showing a scenario changes the current worksheet values, so you may want to show the original case again when finished.
Make a copy before experimenting with an important workbook. The tool is designed for what-if analysis, but changing cells can affect dependent formulas and displays. A copy gives you a straightforward way to return to the original state.

Troubleshooting

Scenario Manager is missing from the menu. First confirm that you are using the Excel desktop app, not Excel for the web. In the desktop app, select the Data tab and check the What-If Analysis menu. If the ribbon is compressed, expand the window or inspect collapsed commands. On Excel for Mac, the Scenario Manager command is available in desktop versions that include the feature; the ribbon layout can differ, so look on the Data tab for What-If Analysis. If it is not present, update or open the workbook in a supported desktop version of Excel.

The command appears unavailable or grayed out. Check whether the workbook or worksheet is protected, or whether the file is open in a restricted mode. If you have permission, use Review > Unprotect Sheet to remove sheet protection, or use the workbook’s protection controls as appropriate. A workbook opened as read-only may also limit changes. Save an editable copy, then try the Data tab command again.

The dialog opens but has no scenarios. Scenario lists are tied to the active worksheet. Click the worksheet where the scenarios were created and reopen Scenario Manager. If the workbook was saved as CSV or another format that does not preserve Excel features, reopen an original Excel-format copy. If you have only a CSV copy, the scenario definitions may need to be recreated.

Show changes values but the result does not change. Check that the selected changing cells are the cells referenced by the result formulas. Confirm that the result cells contain formulas rather than fixed numbers, and that calculation is enabled. In Excel, check Formulas > Calculation Options and select Automatic if appropriate. Also verify that the formulas do not refer to a different sheet or a separate set of inputs.

The scenario values appear in an unexpected order. Reopen the scenario with Edit and inspect its changing-cell references, then review the Scenario Values dialog in that same order. Use clear labels next to the worksheet inputs. If the references are incorrect, edit or recreate the scenario with the intended cells and values.

Frequently Asked Questions

Can I open Scenario Manager before creating any scenarios?
Yes. Open Data > What-If Analysis > Scenario Manager on the intended worksheet. The list can be empty. Select Add when you are ready to define your first scenario.

Can I use Scenario Manager in Excel for the web?
No. Scenario Manager is a desktop Excel feature, not a web feature. Choose Open in Desktop App from the workbook if available, or download and open the file in desktop Excel.

How many changing cells can one scenario use?
A scenario can include up to 32 changing cells. If your model has more inputs, consider whether some can be combined or whether you need a different analysis approach.

Does showing a scenario overwrite my formulas?
It replaces the values in the changing cells listed for that scenario. If you accidentally include a formula cell as a changing cell, its formula can be replaced by a stored value. Keep formula outputs out of the changing-cell list unless that is deliberate.

How do I return to my original values after showing a scenario?
Open Scenario Manager and select the scenario that represents the original assumptions, then choose Show. If you did not save an original case, use Undo immediately where available or restore the values from a backup or saved copy.

Can I open the same scenarios on another worksheet?
Scenarios belong to the worksheet where they were created; they do not automatically appear on another sheet. Create scenarios on the destination sheet using its own changing cells, or copy the model and set up the scenarios there.

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.