Microsoft Excel 'Quick Tip'

Creating Page Breaks

I 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.

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".

Subscribe at the

You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright All Rights Reserved by

Close this window