In Excel, how do I make the freezed pane area, print on each page.

J

Jane

I have a spreadsheet and I freezed the top part of the page like 4 lines, I
want that section to always print, without having to cut and paste with page
breaks. I have a few reports that do that, but i can't figure out how to do
myself. Office 2000
 
D

Dave Peterson

File|page setup|Sheet tab|
Click in the Rows to repeat at top.
Point at your rows with your mouse.
 
Top