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

Problem:

Microsoft Excel: How do I print column titles on every page?

Solution:

  1. Select File from the menu.
  2. Select Page Setup.
  3. Select the Sheet tab.
  4. 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.
  5. Press Enter.
  6. Click Print.

Did this document solve or help you with your problem?

Yes   No  

Category: Software : Excel     Platform: All Windows
Document #: 407     Author: Elizabeth Golden    
Last Modified by: Cynthia Senicka on 03/05/2008