Removing All Page Breaks from the Sheet

To remove all page breaks from a sheet (when the number of printing pages exceed 1):

1. Select all cells in the sheet by pressing Ctrl+A. In Excel 2003, press Ctrl+A+A from a cell in the Current Region/List.
Click Select All at the corner of the sheet’s headings.
2. From the Page Layout Ribbon Menu , In Page Setup group > Break > Reset All Page Break

Screenshot // Removing All Page Breaks from the Sheet
Page Break

Leave a Reply

Your email address will not be published. Required fields are marked *

7 − one =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>