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

Repeat Row at Top of Worksheet 2
Printing non-contiguous rows at the top 1
rows to repeat at the top 4
excel - rows repeat on top 4
Rows to Repeat at Top - Formatting Multiples 2
Rows to repeat at top of each page 4
Excel Spreadsheet "Rows to repeat at top" 4
Excel MSO 2010 - Excel 3

Top