How do I repeat rows at the top of SOME of the pages in Excel

  • Thread starter Thread starter IM333
  • Start date Start date
I

IM333

How do I repeat rows at the top of SOME of the pages in Excel?

I know it will print on ALL , but cannot figure out how to make them print
only on certain ones.
 
Record a macro when you change that setting one way.
print the sheets you want that way.
continue recording that macro when you turn it off
and print the sheet you want that way.

Then when you have to do this again, you can just run your macro.
 
Back
Top