Define Print & View Areas

"Using the Report Manager add-in program, you can combine worksheets , views (a set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.), and scenarios (a named set of input values that you can substitute in a worksheet model.) into printable reports. For example, if you have a Best Case and a Worst case scenario, a Summary view, and a Details view, you can create a report that presents the Best Case scenario in the Details view and another report that presents the Best Case Scenario in the Summary view. Reports that you create are automatically saved with your workbook so that you can print them at any time."

Create a report for printing

1. On the View menu, click Report Manager.
   
2. Click Add.
   
3. In the Report Name box, type a name for the report.
   
4. In the Sheet box, click the sheet you want to use for the first section of the report.
   
5. Do one of the following:
   
   • To use a view for the first section of the report, select the View check box, and then click the view in the View box.
     
   • To use a scenario for the first section of the report, select the Scenario check box, and then click the scenario in the Scenario box.
     
6. Click Add to enter the view or scenario as a section in the Sections in this Report box.
   
7. Repeat step 5 and 6 until you've created all of the sections you want in the report.
   
8. To change the order of the sections, in the Sections in this report box, click the section you want to move, and then click either Move Up or Move Down.
   
9. To number the pages of the report consecutively, select the Use Continuous Page Numbers check box.
   

Edit a report for printing

1. On the View menu, click Report Manager.
   
2. In the Reports box, click the report you want to edit, and then click Edit.
   
3. 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, in the Sections in this report box, 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

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

Labels: Addins, Tips