repeat headline that are not connected

[mario]

hi,
i need a headliner for every print sheet, but they donnot beloong together
for example
Line 4 and Line 6
may anyone help me?

greez mario

 

[JAVB]

Could you give a simple example of the layout. I am not comprehendin
what you are trying to do.

JAV

 

[Bart Snel]

mario schreef:

hi,
i need a headliner for every print sheet, but they donnot beloong together
for example
Line 4 and Line 6
may anyone help me?

greez mario

File > Page setup > Sheet-tab
Here you can select the rows you want to appear

 

[David McRitchie]

Hi Mario,
You have to select contiguous rows, so you cannot chose row 4 and row 6 only.
What you could do is force a page break where you want the 2nd page to
break, say select row 50 then Insert, Page Break.

Then copy row 6 before row 51, and copy row 4 before row 51
then under page setup rows to repeat at top 51:52

Freeze Panes for view and Repeat row/col headings for printing
http://www.mvps.org/dmcritchie/excel/freeze.htm

 

[David McRitchie]

concept is correct but insert the page break after copying rows before
row 50, then insert the page break (before) with row 50 selected.
So rows 1-49 are on first page, and the rest of the pages will
page break automatically.