Before you print an Excel 2007 worksheet, use Print Preview to control the way your spreadsheet looks.
Watch this 3-minute video demo to find out how you can ...
- Print column headers on every page
- Show gridlines
- Print in landscape mode (sideways), and
- Save paper
Source: Support / Excel / Excel 2007 Help and How-to / Excel Demos
Source of video: http://office.microsoft.com/video.aspx?assetid=ES010289766&vwidth=1024&vheight=768&CTT=11&Origin=