Tip Printed from ExcelTip.com

---

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.
OR
Click Select All at the corner of the sheet's headings.
2. From the Insert menu, select Reset All Page Breaks.