Setting the Report Viewer Output

Selecting the Print Area

You can select only a portion of the current data to be printed by setting the Print Area. This can be very useful if you only need to print part of one column, or just the totals, etc. To do this, highlight the cell(s) you want to print, and click Sheet » Set Print Area, and then File » Print. MPM uses the titles, header, footer, and other settings to print a report which only contains the data in the selected print area.

Changing the Header or Footer

To change the header or footer, click File » Page Setup. MPM displays the Page Setup dialog box. Use the Header text box to enter your page header. Use the Footer text box to enter your page footer.

To insert variables such as Page Number or Today's Date, use the Format Codes described below. Codes and text are, by default, centered unless &L or &R is specified.

Format Code	Description
&L	Left-aligns the characters that follow.
&C	Centers the characters that follow.
&R	Right-aligns the characters that follow.
&D	Prints the current date.
&T	Prints the current time.
&F	Prints the workbook name.
&A	Prints the worksheet name.
&P	Prints the page number.
&P+#	Prints the page number plus a number you enter; for example, &P+1.
&P-#	Prints the page number minus a number you enter; for example, &P-1.
&&	Prints an ampersand.
&N	Prints the total number of pages in the document.

Font Codes

The following font codes must display before other codes and text or they are ignored. The alignment codes (for example, &L, &C, and &R) restart each section; new font codes can be specified after an alignment code.

Format Code	Description
&B	Makes text bold.
&I	Makes text italicized.
&U	Underlines the header.
&S	Strikeout the header.
&fontname	Use the specified font.
&nn	Use the specified font size - must be a two digit number.

Changing the Margins, Page Range, Scale, and Column Headers

To change any of these options, access the Page Setup dialog box as described above.

Setting and Removing Page Breaks

To set a page break, click the cell or row and click Sheet » Set Page Break. To remove a page break, click the cell and click Sheet » Remove Page Break.

Fixing and Releasing Rows/Columns

To fix a row at the top of the screen that you will continue to see when scrolling down, click the row number(s) and click Sheet » Fix Rows.
To fix a column at the left edge of the screen that you will continue to see when scrolling to the right, click the column number(s) and click Sheet » Fix Columns.
To release the fixed row/column(s), select it and click Sheet » Unfix Rows/Columns.

Inserting a Formula

To insert a formula, click the desired cell and begin the entry with an equal sign (=). You can perform the following types of calculations:

+ (addition)
- (subtraction)
/ (division)
* (multiplication)
Use % to indicate percentage
^ (exponentiation)
& (concatenation)

To perform comparisons, use:

= (equal to)
> (greater than)
< (less than)
>= (greater than or equal to)
<= (less then or equal to)
<> (not equal to)

To identify the cells in a formula, refer to the row and column headings of the cell. A1 refers to the cell in row 1, column A.

To reference a range of cells, use a colon (:). For example, A1:C3 refers to all cells in columns A, B, and C of rows 1, 2, and 3.

You can also enter functions into a formula, such as SUM, AVERAGE, COUNT. For example, to sum the first 10 cells of column A, enter the formula =SUM(A1:A10).