Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
sararose27
 
Posts: n/a
Default Header - stop repeating on every page!

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!!
  #2   Report Post  
 
Posts: n/a
Default

hi.
"rows to repeat at top" is applicable.
page setupsheet tab. remove anything in the "rows to
repeat at top" box and your header will stop repeating on
every page.

-----Original Message-----
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!!
.

  #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!!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link page header with cell contents Matthew Excel Worksheet Functions 8 May 1st 07 06:22 PM
How do I keep the header on the first page but hide it on the sec. victoria Excel Discussion (Misc queries) 1 February 3rd 05 12:22 AM
Default header in Excel under page set-up Melanie Excel Discussion (Misc queries) 2 December 15th 04 01:37 AM
Same Cell Header For Every Page localhost Excel Discussion (Misc queries) 1 November 26th 04 02:40 PM
How do I stop automatic page breaks in excel Lesley Hutchinson Excel Worksheet Functions 0 October 31st 04 12:49 PM


All times are GMT +1. The time now is 09:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"