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 Page Layout Ribbon Menu , In Page Setup group > Break > Reset All Page Break

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

Arlette Aloysius

Arlette Aloysius has more than 10 years of experience working with excel. She started teaching excel and other microsoft office programs to government employees when she was in college as part of extra-curricular activities. In her 9 years of work experience, she has worked extensively on excel and automated several reports using vba. In her current role as administrator of Excelforum.com, she provides simple as well as complicated vba solutions to users who need their reports to be automated. She is a Commerce graduate who specialized in Computer Applications where she was able to pick up the basics of the VB programming language. She then pursued to do her Post Graduate Diploma in International Business. Excel sheets are part of her daily life. She uses it even for small personal uses like keeping track of household expenses, investments, etc. By using excel as a tracker cum dashboard helps her to be up-to-date with all financial aspects in her day to day operations.



Leave a Reply

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


+ two = 4

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>