This article was previously published under Q142529
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
For a Microsoft Excel 2002 version of this article, see 291072. For a Microsoft Excel 2000 version of this article, see 214258.
A view is a picture of the worksheet that has specific characteristicsassociated with it, such as print settings and whether to includehidden rows and columns. In View Manager, under View Includes, you canselect 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 tocreate a report from those views, and how to print the report.
Note To use Report Manager or View Manager, you must have therespective add-in installed. If the add-ins are not listed in the Add-Ins dialog box, run Setup in maintenance mode to install them.
Creating the Views
Click New on the File menu to open a new workbook.