View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jaleel Jaleel is offline
external usenet poster
 
Posts: 187
Default How do I keep heading so it prints on multiple pages

Hi Pete,

Why the print area should exclude the rows to repeat at top? It will not be
printed twice even if it is included.

Jaleel

"Pete_UK" wrote:

Go to File | Page Setup | Sheet tab and you will see that you can
specify Rows to Repeat at Top. Ensure that your print area excludes
these rows, otherwise they will be printed twice on the first page.

Hope this helps.

Pete

de2137 wrote:
I want to print multiple pages using the same heading that is at the
beginning of a column without having to insert rows with the same heading at
a page break.