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

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.
 
D

Dave Peterson

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.
 

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

How do I remove the top half of a block interval? 1
Excel --> Word 4
Space at end of multi page list to accommodate new entries 1
"Repeat Rows" - selected printed pages only 3
Unwanted line across top of pages; how to delete? 0
VBA word change keys 0
How to open multiple instances of Word 365? 5
Repeat Row at Top of Worksheet 2

Top