Creating Page BreaksI see many Excel beginners and often people who have been using it for some time, inserting blank rows within their worksheets to get their reports to print out properly.
To get these pages to print the way you want, you can insert page breaks that tell Excel where to start printing a new page without the need of blank rows.
Just click on the row heading (i.e. select the whole row) where you want a new page to start printing and from the Page Layout tab, click Breaks, Insert Page Break.
Alternatively, in Page Break Preview (click the 3rd icon, to the left of the Zoom slider on the Status Bar), when you right click a row heading, the Insert Page Break will be available.
There's no need to insert blank lines.
share it with your friends and associates?