Header - stop repeating on every page!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!
 
hi.
"rows to repeat at top" is applicable.
page setup>sheet tab. remove anything in the "rows to
repeat at top" box and your header will stop repeating on
every page.
 
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 View>Header 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 Setup>Sheet,
and delete the content in the "Rows to repeat at top" field.

Hope this is useful |:>)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

repeating subreport header on report 0
Header rows 4
Insert automatic page numbering into a cell, not a header or foote 1
Footer 1
Repeating only a portion of both row and column on multiple pages 1
Change print titles (rows to repeat at top) on subsequent pages 2
Repeat headers only when data existss 1
How do I have Column Headers Repeat Autmoatically on Every Page? 1

Back
Top