title: Headers in SSRS Reports in Excel
body: <p>I'm using VS 2005 to create database reports. In some cases, these reports are viewed in Excel, and quite often, the reports contain many many columns, necessitating multiple pages for a single row when printing.</p>
  <p>The way they're behaving in Excel, by default, is as follows:</p>
  <p>The header appears at the top of the report, occupying ~5 rows which are locked and do not scroll with the document. Footers do not appear when viewed in Excel.</p>
  <p>When printed, the footer appears on each page, but the header appears only once, centred on the 'middle' page (remember that each page is a part of a single row, so that if the pages are placed side by side horizontally, it would reconstruct the table):</p>
  <p><a href="https://i.stack.imgur.com/zUlxv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zUlxv.png" alt="sample" /></a></p>
  <p>The footers are behaving as desired.</p>
  <blockquote>
  <p>My question is: How can I make the header behave in the same way, so
  that it appears on each page, instead of only on the 'middle' page?</p>
  </blockquote>
  <p>I need a solution that can be implemented in VS. Doing this manually in Excel is not an option.</p>