HOW TO: Create Multiple Views, Create and Print a Report in Excel 2000

This step-by-step article shows you how to create multiple views of a worksheet as well create and print a report.

A view is a picture of the worksheet that has specific characteristics associated with it, such as print settings and whether to include hidden rows and columns. Typically, a report is made of multiple views. This article describes how to create multiple views, how to create a report from those views, and how to print the report.

NOTE: To use Report Manager, you must have the add-in installed. If the Report Manager add-in is not listed in the Add-Ins dialog box, run Microsoft Excel 2000 Setup in maintenance mode to install it.

Create the Views

1. Open a new workbook, and then type the following data in Sheet1:

      A1: View1   B1:   C1: View2
      A2: 1       B2:   C2: 1
      A3: 2       B3:   C3: 2
      A4: 3       B4:   C4: 3
      A5: 4       B5:   C5: 4
   					

2. Select the range A1:A5, and then set the print area to this range of cells.
3. On the View menu, click Custom Views.
4. Click Add, type View1, and then click OK.
5. Select range C1:C5, and then set the print area to this range of cells.
6. On the View menu, click Custom Views.
7. Click Add, type View2, and then click OK.

Create a Simple Report

1. On the View menu, click Report Manager, and then click Add.
2. In the Report Name box, type MyReport.
3. Under Section To Add, verify that the View check box is selected, select View1, and then click Add. Repeat this step to select View2.
4. Click OK.

Print the Report

To print the report, click Print in the Print Report dialog box, and then click OK.

For more information about views and reports, click Microsoft Excel Help on the Help menu, type print a view in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.