Select Page Break view on the View menu, adjust the blue line at the top
by dragging down below the your list of headings.

The area in grey will not print.
This view will also show you where the page break are between pages.


--
lostinformulas
------------------------------------------------------------------------
lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
View this thread: http://www.excelforum.com/showthread...hreadid=550110