Printing "Freeze Panes"

S

sh2195

Is it possible to print my document so that the same (heading) row is at the
top of each new page? Something like what is achieved using the "freeze
panes" option, but on the hard copy. I can't just use the header to achieve
my intended result.
thanks!
 
M

Marcelo

select FILE on the menu and PAGE SETUP, on the sheet tab, select the rows to
repeat at top.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"sh2195" escreveu:
 
E

Ernie Lippert

Yes, you can. Go to Tools>Page Setup>Sheet then use Rows to repeat at top to
select the heading you want on each new pare.
Regards,
Ernie Lippert
 
J

j B

Thank you! This is so helpful. I used this to create a tracking worksheet with a lot of inputs for a calendar.

In some ways it's also like "split view", in that it keeps the same stuff at the start of every page.

#split_view #freeze_panes #print_panes #print_freeze
 
Top