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

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

Back to the top

Creating the Views

1. Click New on the File menu to open a new workbook.
2. 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
   					

3. Select the range A1:A5 and set the print area to this range of cells.
4. On the View menu, click Custom Views (or click View Manager in Microsoft Excel 5.0 or 7.0)
5. Click Add, type View1, and then click OK.
6. Select range C1:C5, and set the print area to this range of cells.
7. On the View menu, click Custom Views (or View Manager).
8. Click Add, type View2, and then click OK.

Back to the top

Creating a Simple Report

1. 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.
2. Click Add.
3. In the Report Name box, type MyReport.
4. Under Section To Add, make sure the View check box is selected, select View1, and then click Add. Repeat this step to select View2.
5. Click OK.

Back to the top

Printing the Report

1. In the Print Report dialog box, click Print.
2. In the Print dialog box, click OK.

Back to the top