How to Repeat Excel Spreadsheet Column Headings at Top of Page

  1. Top 10 Help Pages
  2. Recent Additions
  3. Instructions
  4. Show All Help Pages
  5. Contact Information
  6. Atomic Learning
  7. CedarInfo
  8. CedarNet
  9. Google Apps
  10. Google Calendar
  11. Google Drive
  12. Google Groups
  13. Google Mail
  14. Google Sites
  15. Microsoft Excel
  16. Microsoft Outlook
  17. Microsoft PowerPoint
  18. Microsoft Word
  19. Miscellaneous
  20. Moodle
  21. Other Software
  22. Personal Computers and Devices
  23. TechStop
  24. University Hardware
  25. Windows

How to Repeat Excel Spreadsheet Column Headings at Top of Page

 how to repeat excel spreadsheet column headings at top of page

Use this feature if you would like a title row (or rows) to print at the top of every page of your data in Excel.

Note:
If you want column headings to remain at the top of your sheet when scrolling within a spreadsheet, you will need to freeze the top row.

  1. Click the [Page Layout] tab > In the "Page Setup" group, click [Print Titles].
  2. Under the [Sheet] tab, in the "Rows to repeat at top" field, click the spreadsheet icon.
  3. Click and select the row you wish to appear at the top of every page.
  4. Press the [Enter] key, then click [OK].
  5. Select File > Print > "Show Print Preview" to see what the printed spreadsheet will look like.

Note:
If the [Print Titles] button is locked (greyed out), it may be because you are currently editing a cell or you have chart selected. If the "Rows to repeat at top" spreadsheet icon is locked, it may be because you have more than one worksheet selected within your workbook. To unclock either button, you can also try clicking [File] > "Print" > "Page Setup."

Keywords: header, formatting, excel

Posted in Computer Help