Printing Headers

  • Thread starter Thread starter George Wilson
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Print Area to include text box 10
Border 5
printing a header in Excel 2
How pull ID#s that meet specific "yes" requirements 3
Printing 3
How to best select from image and print full size? 1
Row 1 HEADERS on EVERY printed page 2
Excel Header Question - Help 1

Back
Top