Printing - different rows at top for each page

K

kestrel

I'm printing out a spreadsheet, and I have set a row to appear on the
top of each page by going to 'page setup'/'sheet'/'print titles'.

However, I want this to change for different pages.
Is it possible to choose a different header row for each page that is
printed?

Thanks

Kestrel
 
D

Dave Peterson

You could record a macro that prints exactly what you want.

Just record a macro that sets up the rows to repeat at top, prints the page(s)
you want, then change the rows to repeat at top, prints more page(s), and keep
going....

Double check so you don't skip any rows during the printing and rerun that macro
when you need to have this much control.
 

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