HELP!! Header thats not a header

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
 
P

Peo Sjoblom

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..
 
J

J.E. McGimpsey

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top