Printing Headers

G

George Wilson

I am currently using Excel 2002 on a Windows XP system. I
have some long spreadsheets with more than one table. The
lower half of the sheet has different headings for the
columns. I can set for the upper portion to repeat the
headers on each page when printing, but how do I get the
repeating headers to change midstream in the lower portion
of the sheet? is this possible?
TIA
George
 
F

Frank Kabel

Hi
one workaround:
- try starting recroding a macro
- set the pagesetup for the upper half of your sheet and
print this part
- change the pagesetup (different repeating rows) and
print the lower part

Now use this recorded macro.
 
Top