Repeat rows or columns as headers when printing?

[Ed]

When printing a range that will cover a few pages, is it possible to repeat
the header rows or columns on every page (like Word's option for table
layouts)?

Ed

 

[Dave Peterson]

File|Page setup|Sheet tab|
click rows to repeat at top and select the rows you want with the mouse.

As an aside, if you want to always see those same rows while you're editting the
data (say rows 1:3), you can select A1 (just so that it's visible), then select
A4.

Window|freeze panes

Everything above the selected cell will always be visible.

And if you selected C4, then everything above that cell and everything to the
left of that cell will be frozen.

 

[Ed]

Many thanks, Dave! I used the Freeze Panes to work on this, but when I
moved over to the second page, the Print Preview showed me the "hidden"
columns instead. When I _really_ hid them (using the right-click Hide
command), then they didn't show up in the preview. Much better as a page
format, though. I appreciate the boost.

Ed