Page Break Preview 

Page Break Preview displays the location of page breaks. This view is helpful as it is a quick method to check if certain columns do not fit on a page width. Blue lines separate each page. Clicking and left-dragging these blue lines can adjust location of Page breaks.

Method One: Select from the View menu, Page Break Preview.

To close Page Break Preview, select from the View menu, Normal.

Refer to article on Print Preview for more information on Print Preview.

Click to open Print Version of Print Preview

Refer to article on Printing for information on how to print a selection vs an entire workbook.

Click to open Print Version of Printing