How to Use the Report Manager in Excel 2000
When you create scenarios in Excel 2000, you can view and print them using the Report Manager. Scenarios are sets of input values used in your reports. Report Manager makes it easy to share reports with someone who needs to view the information but does not have access to Excel. Using the Report Manager is fairly easy and this guide will show you simple steps in using this tool.
Other People Are Reading
Instructions
-
-
1
Access your Excel 2000 program. Open the document that contains the scenarios that you wish to view in Report Manager. Click on the menu bar and choose "View" then "Report Manager." This opens the dialog box. You can use the dialog box to determine what you want Excel to combine for printing.
-
2
Click the "Add" button to display the "Add Report" dialog box. In the "Report Name" text box enter a name that you wish to use for your report. In the "Section To Add" box, choose the worksheets, custom views and the scenarios that you have created.
-
-
3
Click on the drop down arrow next to the "sheet." Choose the Excel document that you want to include in the first section of the report. Choose the "View" box. Click on the drop down arrow and choose a view that you wish to include in the first section of your report. You can also click the "Scenario" drop down arrow next to the "Scenario" box.
-
4
Click "Add" to add the section to the sections "Section In This Report" list box. Click "OK" to close the dialog box. Click "Print" to print your report.
-
1
