Col head to repeat @ break

J

Jane H

If I set up column headings how can I get these to repeat
at each page break. I know I can print them, but is there
a quick way to copy them so that they show on screen at
each page break please
 
G

Gord Dibben

Jane

In Page Setup>Sheet. "Rows to repeat at top"

Enter 1:1(or point to the row) if one row of headings.

Gord Dibben Excel MVP
 
R

RagDyer

Have you tried "Freeze Panes"?

Select appropriate cell, then:
<Window> <FreezePanes>

This would not exactly put your headings at the top of each screen page
break, but would retain (freeze) them at the top row of the sheet as
displayed on the screen, even as you scroll.

Here's an old post that describes it in a little more detail:

http://tinyurl.com/2qdzt

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


If I set up column headings how can I get these to repeat
at each page break. I know I can print them, but is there
a quick way to copy them so that they show on screen at
each page break please
 
Top