TheExcelAddict.com
Microsoft Excel 'Quick Tip'

Creating Page Breaks

I see many beginning Excel users, and often people who have been using it for some time, inserting blank rows in their worksheet to get their reports to print properly. On multiple-page worksheets, some pages may print in the middle of a section. 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. Just click on the row heading (i.e. select the whole row) where you want a new page to start printing and choose Insert, Page Break.

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 TheExcelAddict.com/Newsletter.htm and you could win a really cool prize.
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