Print Preview

Printing in Excel can sometimes be complicated. Learn about Excel printing, including setting the right print area, in this lesson.

Defining page breaks using Print Preview

The gray space between two pages is called a page break. You typically won't have to worry about page breaks because Excel automatically inserts soft page breaks when necessary. However, hard page breaks allow you to fine tune the appearance of your document. They are particularly useful when you want to begin a new section of your document.

When you turn on Page Break Preview (available on the Print Preview toolbar), the Office Assistant appears, telling you that you can adjust page breaks by clicking and dragging the edge of the page break with your mouse. Page Break Preview shows you what and in what order pages are printed.

Page Break Preview

Important PointAreas that are printed are white; areas that won't be printed are gray.