HELP!! Header thats not a header

  • Thread starter Thread starter Kevin M.
  • Start date Start date
K

Kevin M.

Hello All,

I have a spreadsheet that when printed is 7 pages. I put
a header that is from cells 1 to 6 and have set it in the
page setup in the section sheets-print title - rows to
repeat at top cells 1-6. This works perfect, every sheet
when printed displays these rows at the top of the page.
The problem is I don`t want this to print on the top of
page 7. How can I make it so pages 1-6 the rows repeat on
top and page 7 it doesn`t. Any help would be greatly
appreciated.

Thanks,

Kevin M
 
You have to print in 2 batches, first the 1-6 pages, then remove this and
print the 7th page.
You could record a macro while doing this..
 
Be aware when you do this that the pagination will change once you
remove the fixed rows. You'll want to print just the range of the
last page.
 
Back
Top