20120819

Print Column Headers On Each Page


  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

No comments:

Post a Comment