| | You can combine Microsoft Excel 2002 worksheets, views, and scenarios 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. | |
| | This add-in is useful if you want to print multiple worksheets in one batch. | |
| | It lets you create a report which consists of a series of worksheets in a specified sequence. | |
| | You can’t choose a print range within a sheet, but the report respects any page breaks and headers and footers already present. | |
| | The add-in also supports views and scenarios. The report can only be printed to paper - there is no preview feature. | |
| | Select the Report Manager option from the View menu. Excel displays the Report Manager dialog box. | |
| | From the list of available reports, select the one you want to edit. | |
| | Click on the Edit button. Excel displays the Edit Report dialog box. | |
| | The only difference between this dialog box and the Add Report dialog box discussed in the last tip is that all of the fields are already filled in. | |
| | Make any changes you desire to the information in the dialog box. | |
| | You access the Report Manager from the View menu. The report parameters are saved with the workbook, and can be recalled and edited at any time. | |
| | You will probably find the reporting features of the Access Links add-in more flexible, but the Report Manager is faster and more convenient. | |
| | The add-in is supplied with Excel 97 and 2000, but if you use Excel 2002 you must download it from Microsoft’sWeb site. | |
