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

Comments

Popular posts from this blog

50 Excel VBA Oral Interview Questions