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 *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.