Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Excel
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Edit a scenario
 

If you keep the original name of a scenario (scenario: A named set of input values that you can substitute in a worksheet model.) after you make changes to it, the new values for changing cells replace the values in the original scenario.

  1. On the Tools menu, click Scenarios.
  2. Click the name of the scenario you want to edit, and then click Edit.
  3. Make the changes you want.
  4. In the Scenario Values dialog box, type the values you want for the changing cells.
  5. Do one of the following:
    • To save the changes, click OK.
    • To return to the Scenario Manager dialog box without changing the current scenario, click Cancel.

advertisement