View Single Post
  #3   Report Post  
CyberTaz
 
Posts: n/a
Default

If you are actually dealing with a Header, it is "all or nothing". Excel
provides no feature to suppress Headers/Footers. To turn a true Header/Footer
off all together, go to ViewHeader and Footer & select (none) from the
appropriate lists. You can also get to the Page Setup dialog box form the
File menu or from Print Preview.

On the other hand, if one or more rows from your worksheet are reprinting at
the top of the columns being printed on each page, got ot Page SetupSheet,
and delete the content in the "Rows to repeat at top" field.

Hope this is useful |:)

"sararose27" wrote:

Anyone know how to stop the header from repeating on every page?

I didn't think that "rows to repeat at top" was applicable and there is no
checkbox that I can find under the Header tab.

Thanks!!