Removing Manual Page Breaks in ExcelLast reviewed: November 2, 1994 |
The information in this article applies to:
SUMMARYTo 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.0From 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 INFORMATIONRemoving All Manual Page Breaks in Excel 5.0
Removing All Manual Page Breaks in Excel 3.0 or 4.0
Removing All Manual Page Breaks in Excel 2.xAll 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:
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 Last reviewed: November 2, 1994 |