Page Breaks Not Viewable in Shaded Cells in Excel

Last reviewed: February 13, 1995
Article ID: Q45064

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0

SYMPTOMS

Your worksheet is printing as if there were page breaks in it, but there are not any visible page breaks on the sheet.

WORKAROUND

Check to see if the worksheet contains any shaded cells. If the cells on the worksheet are shaded, the page break lines are not viewable. To view the current page breaks, either temporarily remove the shading in the cells in the problem area or go to a portion of the spreadsheet where the cells are not shaded.

This same behavior may be evident if the cells have been formatted using a pattern in Excel versions 3.0 and later.

KBCategory: kbusage
KBSubcategory:
Additional words: 2.0 2.00 2.1 2.10 3.0 3.00 4.00 4.0

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: February 13, 1995
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.