Print Column Headers On Each Page
- 2 Comment
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:
- Select “View” from the drop-down menus at the top of Excel
- Click on “Header and Footer…”
- In the “Page Setup” window you should see 4 tabs, click on the “Sheet” tab.
- 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.
- Select the row where your column headers are located (typically row 1).
- 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.
Related Hints
2 Comments on this post
Trackbacks
-
Chris said:
Great tip! I was actually just searching for the at work the other day.
October 8th, 2008 at 12:24 pm -
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
Loading ...