Do you want your column headings to appear at the top of each page when you print your Excel 2007 worksheets? To do so click on the Page Layout Tab, to the Page Setup group and click the Print Titles button and click the Rows to repeat at top's collapse dialogue box button and click on the row in your worksheet that you'd like to repeat at the top of each printed page. Now this option is not available from the Print Preview page. I mean that even though you can go to through the Print Preview to access the Page Setup screen, you'll notice that the "Rows to repeat at top" is not active for you to used this option here. You can see all this in action in my training video!

Purchase the training video and you can see this in action for yourself!