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.

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

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.

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.