FAQ - Excel 2007: How do I print column titles on every page?

Problem:

How do I print column titles on every page in Excel 2007?

Solution:

  1. Select the Page Layout tab.

  2. Click on Print Titles.
  3. In the box next to 'Rows to Repeat at Top' enter the row to be repeated in the format $x:$x where x is the row number.
  4. Press Enter.
  5. Click Print.

Did this document solve or help you with your problem?

Yes   No  

Category: Software    
Document #: 1026     Author: Theodore (Ted) Bonman    
Last Modified by: Joshua Moor on 06/10/2008