Printing Frozen Rows

B

Brandt

I have a workbook with 2 worksheets in it - Sheet A and Sheet B. Both sheets
are 3 pages long as far as printing goes. On both sheets (A & B) I have
frozen the top 2 rows so I can view the column headings no matter where I
have scrolled down to on the page. Sheet A will print these top two rows on
all sheets that it prints (all 3 pages in this example) but sheet B will only
print them on the first page. Does anyone know why? I would like to have
sheet B print them on all pages too.

Thanks in advance for any help.
 
D

Dave Peterson

Check under File|Page setup|Sheet tab

I'm guessing you don't have them in your Rows to repeat at top.
 
Top