Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Microsoft Excel does not automatically shift manual page breaks when you delete or insert rows in the Microsoft Excel Workbook 5.0/95 format file


View products that this article applies to.

This article was previously published under Q289255
For a Microsoft Excel 2000 version of this article, see 212062 (http://support.microsoft.com/kb/212062/EN-US/ ) .
For a Microsoft Excel 97 version of this article, see 183999 (http://support.microsoft.com/kb/183999/EN-US/ ) .

↑ Back to the top


Symptoms

In Microsoft Excel, manual page breaks in a worksheet automatically shift position when you insert or delete rows or columns. However, when you open a file that was saved in the "Microsoft Excel 5.0/95 Workbook " file format in Microsoft Excel, Microsoft Excel does not automatically shift manual horizontal page breaks when you delete or insert rows.

NOTE: This behavior persists if the workbook is saved later.

↑ Back to the top


Cause

This problem occurs if the following conditions are true:
  • You select a cell that is not in the first row and click Page Break on the Insert menu to insert a manual horizontal page break in a workbook.

    Note In Excel 2007, you select a cell that is not in the first row. Then, you click Break in the Page Setup group on the Page Layout tab, and then click Insert Page Break.

    -and-
  • You save the workbook from Microsoft Excel version 5.0 or 7.0 or you save the file from Microsoft Excel in the Microsoft Excel 5.0/95 Workbook file format.

    -and-
  • You reopen the workbook in Microsoft Excel.

    -and-
  • You insert or delete one or more rows earlier the manual horizontal page break in the workbook.

↑ Back to the top


Resolution

To correct this problem, remove and reinsert manual page breaks in the affected document. To do this, follow these steps:
  1. Select the cell location of the manual page break.

    NOTE: If you do not see the manual page breaks, click Page Setup on the File menu, and then click OK.
  2. On the Insert menu, click Remove Page Break.
  3. With the same cell location of the manual page break selected, click Page Break on the Insert menu.
  4. Repeat steps 1 through 3 for every manual page break on the workbook.

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top


More information

A manual page break in an Excel 5.0/95 workbook remains on the same row when rows are inserted or deleted in Microsoft Excel. Columns shift as in earlier versions of Excel when you insert or delete columns.

↑ Back to the top


Keywords: KB289255, kbprint, kbpending, kbbug, kbexpertisebeginner

↑ Back to the top

Article Info
Article ID : 289255
Revision : 2
Created on : 1/16/2007
Published on : 1/16/2007
Exists online : False
Views : 280