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


--
kestrel
------------------------------------------------------------------------
kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082
View this thread: http://www.excelforum.com/showthread...hreadid=564609

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.

kestrel wrote:

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

--
kestrel
------------------------------------------------------------------------
kestrel's Profile: http://www.excelforum.com/member.php...o&userid=19082
View this thread: http://www.excelforum.com/showthread...hreadid=564609

--

Dave Peterson