How to Make Column Titles in Excel 2007 Appear at the Top of Each New Page

1. Open the Excel 2007 file that contains your worksheet. Select the worksheet that you want to print from the list of worksheets at the bottom of the Excel window.
2. Click the 'Page Layout' tab at the top of the screen. Locate the 'Page Setup' area of the ribbon and click the 'Print Titles' button.
3. Select the 'Sheet' tab in the window that appears. Find the entry that reads 'Rows to repeat at top' and click the small box to the right. The 'Page Setup' window will minimize.
4. Select the row that contains the titles you want to repeat. This is normally the first row, but can be any row you desire. If you choose a row that is not on the first page, the column titles will not appear on any page before the one you selected. Click the small box in the minimized 'Page Setup' window to bring the window back up. You'll see your select row next to the 'Rows to repeat' entry.
5. Select 'OK' to close the window and complete the process, or you can click 'Print Preview' to get an idea of how the pages will look.