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
 
 
 
Product Information
Help and How-to
Choose your version
Training
Templates
Related Products and Technologies
Support and Feedback
Technical Resources
Additional Resources
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
Create a scenario
 
  1. On the Tools menu, click Scenarios.
  2. Click Add.
  3. In the Scenario name box, type a name for the scenario (scenario: A named set of input values that you can substitute in a worksheet model.).
  4. In the Changing cells box, enter the references for the cells that you want to change.

    Note  To preserve the original values for the changing cells, create a scenario that uses the original cell values before you create scenarios that change the values.

  5. Under Protection, select the options you want.
  6. Click OK.
  7. In the Scenario Values dialog box, type the values you want for the changing cells.
  8. To create the scenario, click OK.

  9. If you want to create additional scenarios, click Add again, and then repeat the procedure. When you finish creating scenarios, click OK, and then click Close in the Scenario Manager dialog box.

See Also
advertisement
Printer-Friendly VersionPrinter-Friendly Version