XL: How to Create Multiple Views and Create and Print a Report

ID: Q142529

The information in this article applies to:

Microsoft Excel 97 for Windows
Microsoft Excel for Windows 95, version 7.0
Microsoft Excel for Windows, version 5.x
Microsoft Excel for the Macintosh, versions 5.0, 5.0a
Microsoft Excel 98 Macintosh Edition

SUMMARY

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. In View Manager, under View Includes, you can select two check boxes:

The Print Settings check box. This option saves the currently selected print options with the view.

The Hidden Rows & Columns check box. This option saves hidden rows and columns with the view.

Typically, a report is made of multiple views. The "More Information" section of this article demonstrates how to create multiple views, how to create a report from those views, and how to print the report.

NOTE: To use Report Manager or View Manager, you must have the respective add-in installed. If the add-ins are not listed in the Add- Ins dialog box, run Setup in maintenance mode to install them.

MORE INFORMATION

Creating the Views

Open a new workbook by clicking New on the File menu.

Enter 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 set the print area to this range of cells.

On the View menu, click Custom Views (or click View Manager in Microsoft Excel 5.0 or 7.0)

Click Add, enter "View1" (without the quotation marks), and click OK.

Select range C1:C5, and set the print area to this range of cells.

On the View menu, click Custom Views (or View Manager).

Click Add, enter "View2" (without the quotation marks), and click OK.

Creating a Simple Report

In Microsoft Excel 7.0, Microsoft Excel 97 or Microsoft Excel 98 Macintosh Edition, click Report Manager on the View menu. In Microsoft Excel 5.x, click Report Manager on the File menu.

Click Add.

In the Report Name box, type "MyReport" (without the quotation marks).

Under Section To Add, make sure the View check box is selected, select View1, and click Add. Repeat this step to select View2.

Click OK.

Printing the Report

In the Print Report dialog box, click Print.

In the Print dialog box, click OK.

REFERENCES

"Microsoft Excel User's Guide," version 5.0, Chapter 14, "Creating and Printing Custom Reports" and Chapter 32, "Changing How to View Your Worksheet"

For more information about Views and Reports, click Answer Wizard on the Help menu and type:


   How Do I Print a Report

Additional query words: 5.0c 5.00a 5.00c 8.00 97 reporting viewing

Keywords : kbualink97
Version : WINDOWS:5.0,7.0,97; MACINTOSH:5.0,5.0a,98
Platform : MACINTOSH WINDOWS
Issue type : kbhowto