Microsoft KB Archive/214258

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

Article ID: 214258

Article Last Modified on 10/8/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214258



For a Microsoft Excel 2002 version of this article, see 291072.

For a Microsoft Excel 97 and earlier version of this article, see 142529.

IN THIS TASK
SUMMARY
 * Create the Views
 * Create a Simple Report
 * Print the Report

REFERENCES



SUMMARY
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.

back to the top

Create the Views
  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  Select the range A1:A5, and then set the print area to this range of cells. On the View menu, click Custom Views. Click Add, type View1, and then click OK. Select range C1:C5, and then set the print area to this range of cells. On the View menu, click Custom Views.</li> Click Add, type View2, and then click OK.</li></ol>

back to the top

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.

back to the top

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

back to the top

<div class="references_section">