Creating Page Breaks without VBA


Many excel users insert blank rows within their files so that the sheets print out properly with the required number of rows on each page.  However, to ensure that the pages print the way you want, instead of blank rows, insert page breaks which guides Excel where to start printing a new page.

Select the whole row where the new page should start printing and click on the Page Layout tab ->  click Breaks -> Insert Page Break.

Or, in Page Break Preview which is the 3rd icon to the left of the Zoom slider on the Status Bar, the Insert Page Break will be available when you right click a row heading.

Leave a Reply

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


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>