Microsoft KB Archive/64008

Multiplan: Headers Not Aligned with Left Margin PSS ID Number: Q64008 Article last modified on 09-24-1990 PSS database name: D_MPlan

3.00 3.01 3.02 3.04 4.00 4.01 4.20

MS-DOS

Summary:

Microsoft Multiplan headers and footers are automatically centered when they are printed. To print the headers as left justified, type “&L” (without the quotation marks) immediately before the text of the header. “&R” is used to right justify the header or footer. “&C” is used to center text. Make sure this header is entered in one cell.

To edit an existing header or footer cell in Multiplan, do the following:


 * 1) Make sure the cell pointer is on the cell containing the header or footer.
 * 2) Choose Edit. Press the function key F9 to move to the left. The F10 key moves the cursor one character to the right.
 * 3) Position the cursor on the first letter of the header within the quotation marks, enter an ampersand “&” and the letter “L”. Press the ENTER key. The cell will now contain the header text preceded by the two formatting characters.

When the worksheet is printed, the header will now be left justified and the header will align with the left edge of the first column.

More Information:

To create a left-justified header, do the following:


 * 1) Find an area of the worksheet that is not within the print area. Make a notation of the row and column.
 * 2) Choose Alpha, type “&L”, and then immediately follow this with the text of the header within the cell. Format cells to the right of the header for continuous formatting by using the Format Cells menu. Enter a range of cells extending to the right in the “cells:” field. Tab twice to the “format:” field and type “@[cont]” (without the quotation marks) in this field.
 * 3) From the Print menu, choose Header and enter the cell location noted in Step 1 that contains the header.
 * 4) From the Print menu, choose Options and enter the range of cells to be printed in the “area:” field.
 * 5) From the Print menu, choose Printer to see that the header now left aligns with the first column.

Copyright Microsoft Corporation 1990.