Creating and Printing Reports with Report Manager in Excel 2002

You can combine worksheets, views (sets of display and print settings), and scenarios (named sets of data used in worksheet models) into reports that can be printed by using the Report Manager add-in program. Once you add a report, it is saved with the workbook so that you can print the report later.

For example, if you have a Best Case scenario, a Worst Case scenario, and two different custom views Summary and Details you can create a report that would print the Best Case scenario with the Details view and another report that prints the Best Case Scenario with the Summary view.

If the Report Manager command is not available on the View menu, you need to load the Report Manager add-in program. The Report Manager add-in program is available from the Microsoft Excel Download Web site.

Create a report for printing

On the View menu, click Report Manager.
Click Add.
In the Report Name box, type a name for the report.
In the Sheet box, click the sheet you want to use for the first section of the report.
Do one of the following:
- If you want to select a view to use for the first section of the report, in the View box, select the View check box, and then click the view.
- If you want to use a scenario for the first section of the report, in the Scenario check box, select the Scenario check box, and then click the scenario.
If you want to add a section to the list in the Sections in this Report box, click Add.
Repeat until you've created all of the sections you want in the report.

Note Microsoft Excel prints sections of a report in the order in which they're listed.

Edit a report for printing

On the View menu, click Report Manager.
In the Reports box, click the report you want to edit, and then click Edit.
Do one or more of the following:
- To add a new section, click the sheet, view, and scenario you want under Section to Add, and then click Add.
- To delete a section, click the section in the Sections in this report box, and then click Delete.
- To change the order of the sections, click the section you want to move, and then click either Move Up or Move Down.
- To number the pages of the report consecutively, select the Use Continuous Page Numbers check box.

Note Microsoft Excel prints sections of a report in the order in which they're listed in the Sections in this report box.

Print a report

On the View menu, click Report Manager.
In the Reports box, click the report you want to print.
Click Print.
In the Copies box, type the number of copies you want to print.

Back To : On-Line Training Center