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:


  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: 


Comments are closed.

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks