Printing Fozen Panes

E

expect_ed

Is there a way to print a sheet so that the data in the pane above the pane
break prints with the data further down in the lower pane, so it looks like
the screen does after you scroll down?
I've tried designating the top part and the lower part as the print area but
the 2 parts print on separate pages.

Thanks in advance for any help.
ed
 
D

Dave Peterson

Maybe hiding the rows that you don't want printed would be enough.

Be aware that if you have manual pagebreaks in those hidden rows, then you'll
want to remove those pagebreaks first.
 
R

Rick Rothstein \(MVP - VB\)

Is there a way to print a sheet so that the data in the pane above the
pane
break prints with the data further down in the lower pane, so it looks
like
the screen does after you scroll down?
I've tried designating the top part and the lower part as the print area
but
the 2 parts print on separate pages.
Click to expand...

If I understand you correctly, you can click File/Page Setup on the Excel
menu and set the repeat areas (what you now have frozen) in the indicated
fields. Doing this will repeat them on each printed page.

Rick
 
Top