Printing Frozen Rows
 

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.

Check under File|Page setup|Sheet tab

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

Brandt wrote:

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.

--

Dave Peterson

Hi
goto 'File - Pagesetup - sheets' and define your repeating rows

--
Regards
Frank Kabel
Frankfurt, Germany

Brandt wrote:
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.