View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How do I keep heading so it prints on multiple pages

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.