Repeat rows or columns as headers when printing?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 01 Nov 2006 15:16 GMT

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

Reply to this Message

Dave Peterson - 01 Nov 2006 15:27 GMT

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.

> 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

Signature

Dave Peterson

Reply to this Message

Ed - 01 Nov 2006 15:40 GMT

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

> File|Page setup|Sheet tab|
> click rows to repeat at top and select the rows you want with the mouse.
[quoted text clipped - 19 lines]
>>
>> Ed

Reply to this Message