View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JR Hester JR Hester is offline
external usenet poster
 
Posts: 170
Default print header row on all pages except last page

The first part is easy enough. Filepage setup Sheet tab. Enter the rows you
want to repeat on EVERY page.

This will reprint yoru specified rows on each page of teh print out. It
will, however, also print on the last page. Maybe one of the MVP's has a
solution to eliminate them on the last page!

HTH

"Woofaloo" wrote:

I would like to print a worksheet that is 12 pages and repeat rows on 11
pages except the last one since the the last page is the total page. HELP!!!