Print Column Headers On Each Page
- 11 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.