Removing Manual Page Breaks in Excel

 Last reviewed: November 2, 1994
Article ID: Q37740
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
  • Microsoft Excel for OS/2, versions 2.2, 2.21, and 3.0

SUMMARY

To delete a single manual page break, select any cell directly below or to the right of the manual page break, and choose Remove Page Break from the Options menu.

Microsoft Excel 5.0

From the Insert menu, choose Remove Page Break.

To remove all manual page breaks from a file, follow the steps outlined in the section below for the installed version of Excel.

MORE INFORMATION

Removing All Manual Page Breaks in Excel 5.0

  1. Press SHIFT+CTRL+SPACEBAR to select the entire worksheet.

  2. From the Insert menu, choose Remove Page Break

Removing All Manual Page Breaks in Excel 3.0 or 4.0

  1. Press SHIFT+CTRL+SPACEBAR to select the entire worksheet.

  2. From the Options menu, choose Remove Page Break.

Removing All Manual Page Breaks in Excel 2.x

All manual page breaks can be removed from a file by saving it in SYLK file format. SYLK will retain most file formatting (such as borders or column widths) but not page breaks. To save the file as SYLK, do the following:

  1. Open the worksheet.

  2. From the File menu, choose Save As.

  3. Choose the Options button.

  4. Select SYLK from the File Formats list box.

  5. Choose the Save button.

  6. From the File menu, choose Close.

  7. From the File menu, choose Open.

  8. Type the name of the worksheet with an .SLK extension in the File Name box.

  9. Choose the Open button.

The resulting worksheet will not have any manual page breaks.

The file must now be returned to normal file format. To do this, follow steps 1-5 above, but substitute Normal for SYLK in step 4.

KBCategory: kbusage
KBSubcategory:

Additional words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
3.00 4.0 4.00

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: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.