Oct 7 2008

Print Column Headers On Each Page

Have you ever wanted to print the column headers at the top of each page to make reading the document easier.  Well Excel provides an easy way to accomplish this task in only a few steps. 

To have Excel show column headers at the beginning of each page during a print job:

[ad#in-post-ad]

  1. Select “View” from the drop-down menus at the top of Excel
  2. Click on “Header and Footer…”
  3. In the “Page Setup” window you should see 4 tabs, click on the “Sheet” tab.
  4. Under the “Print titles” section (in blue), the first option is “Rows to repeat at top:” – click on the button to the end of the text box.
  5. Select the row where your column headers are located (typically row 1).
  6. Click “Ok” to save your changes

That’s it.  Go ahead and print a test page to make sure the changes you made have taken affect.  You may have also noticed a 2nd option under the “Print titles” section for “Columns to repeat at left:”.  If the layout of your document is more horizontal than vertical, you may want to give this option a try.

** Excel Hints provides Excel Tips and Excel Help for All Levels of Experience.

More Excel Tips

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 

          
TAGS:

11 Comments on this post

Trackbacks

  1. Chris said:

    Great tip! I was actually just searching for the at work the other day.

    October 8th, 2008 at 12:24 pm
  2. john said:

    Thanks Chris. I’m glad this helped you out. When I first discovered this feature, it definitely made printed spreadsheets easier to follow.

    I like to use this in combination with freezing windows. I’ll probably put a post up about that soon too.

    John

    October 8th, 2008 at 12:51 pm
  3. Lorraine said:

    Why oh why can’t the programs provide simple instructions like this? Thanks for the easy-to-follow tip!

    January 15th, 2009 at 9:47 am
  4. john said:

    No problem Lorraine… I’m glad you found it useful.

    January 15th, 2009 at 10:19 am
  5. jen said:

    thanks so much for posting this – i’ve been wondering for so long if this were possible and now i know it is. i’m going to go back and apply this to all my excel documents! i’m so excited!

    January 22nd, 2009 at 6:09 pm
  6. Alex said:

    And to print VARIABLE column headres? I have several tables on the same sheet, one following the other. I can’t choose where Excel breaks the table(s) when it’s printing the whole sheet. If I could make somehow that the data from each table would keep its headers on the page breaks…

    June 4th, 2009 at 7:07 am
  7. Jim said:

    I Know this post is old, but it sure answered my questions and concerns and saved me a lot of trouble. I did find some mods to the instructions were needed for Excel 2010. I would be happy o share, but am not quite sure of the protocol here. Let me know

    September 14th, 2011 at 11:15 pm
  8. marilena said:

    OMG THANK YOU SOOOOO MUCH!!! I have an excel project due and you just saved me!!!!THANK YOU THANK YOU THANK YOU!!!!!

    November 23rd, 2011 at 7:31 pm
  9. steve said:
    December 26th, 2011 at 1:23 pm
  10. mitchell said:

    You are a life saver! It work immaculately!

    January 11th, 2012 at 8:46 pm
  11. sarah said:

    works perfect! thank you!!

    April 17th, 2013 at 12:52 pm

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories