"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Page Break Preview

Often you have to go through trial and error to get multiple page reports to print the way you would like. It can sometimes be tricky getting the pages to break at the right place. Print Preview will show you how your pages will print, but changing page breaks (Insert, Page Break) and switching back to Print Preview can sometimes be awkward.

A much more user-friendly solution for getting your pages to break at just the right places is to set and adjust your page breaks in Page Break Preview mode. In Page Break Preview you are given a view of your worksheet with page breaks shown as blue lines. Blue dashed lines show automatic page breaks and solid blue lines indicate manual page breaks (i.e those set by the user).

The best part of Page Break Preview is that you can easily adjust page breaks and instantly see how the changes affect the printing of your report.

To set or adjust page breaks in Page Break Preview:

  1. Select View, Page Break Preview
  2. Move the cursor to one of the blue lines separating a page until your cursor changes to a double-headed arrow.
  3. Drag to move the page break.

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 www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.