Printing Fozen Panes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 
Back
Top