Microsoft Knowledge Base

MXL: Footer Not Displayed in Print Preview or on Printout
Last reviewed: September 12, 1996
Article ID: Q124577
The information in this article applies to:
  • Microsoft Excel for the Macintosh, version 4.0

SYMPTOMS

In Microsoft Excel version 4.0 for the Macintosh, if you delete the default footer code (Page &P) from the center section of the footer, the page number will not be displayed in print preview.

If you return the &P to the center section of the footer by choosing the Page Number button, &P will be displayed in bold. However, you be unable to view the page number on the printout or in print preview.

CAUSE

When you delete the default center section footer code (Page &P), the font for the center section is set to Chicago with a size of zero (0). So, when the page code is put back into the center section, the page number will not be displayed, even though it appears in the footer in Page Setup.

The verify the font, select page code in the footer, and then select the font button to bring up the Font dialog box.

WORKAROUNDS

To reset the page number in the center section, do either of the following:

Method 1: If the page number code is in the center section box: 

          a. From the File menu, choose Page setup.

          b. In the Page Setup dialog box, click the Footer Button.

          c. Select the center section of the footer.

          d. Select the &P, and choose the font button.

             This will take you to the font dialog box.

          e. In the font dialog box, select the Normal Font check box.

             This will reset the font to Geneva (or whatever font you have
             set for your Normal font).

          f. Choose OK twice.

          g. From the File menu, choose Print Preview.

          The page number should now be displayed as expected.
Method 2: If the page number code is not in the center section box: 

          a. From the File menu, choose Page setup.

          b. In the Page Setup dialog box, click the Footer Button.

          c. Select the center section of the footer.

          d. Type "&P" (without the quotation marks) in the center
             section.

          e. Choose OK twice.

          f. From the File menu, choose Print Preview.

          The page number should now be displayed.

REFERENCES

"User's Guide 1," version 4.0, page 535

KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.00 footer page setup



THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: September 12, 1996
©1997 Microsoft Corporation. All rights reserved. Legal Notices.