Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Creating Scenario Summaries One handy feature of the Scenario Manager is the ability to contrast the different scenarios you have defined. This information is presented in a handy summary worksheet that shows the contents of the scenarios. Follow a few quick steps, and you can have this valuable report on-screen. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Creating Scenarios The Scenario Manager is a tool you can use to store and easily recall different settings within a worksheet. This tip introduces the Scenario Manager and explains how to save your own scenarios. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Editing a Scenario Scenarios that you define are not static; you can easily change them to reflect different assumptions or to contain updated values. This tip explains how to edit an existing scenario without affecting anything shown in the workbook. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Showing a Scenario Save a scenario in the Scenario Manager, and it is a sure bet that you’ll want to recall that scenario at some time. This tip explains how to access a scenario you’ve saved, and what happens when you choose to show the scenario. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)