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


Excel 2007 spreadsheets let you record, organize, compute and visualize all kinds of information. Since they can grow to include thousands of rows, when you print the information, Excel has to split the cells up over several pages. If your columns have headers in the top row, those headers are not automatically printed on each page, making it difficult to keep track of the columns on all subsequent pages. Excel 2007 includes a setting that will print the column headers at the top of every page to help make the data easier to understand.

  • 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.

  • 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.

  • 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.

  • 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.

  • 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.

Related Searches


Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!