repeat headline that are not connected

M

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
 
J

JAVB

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

JAV
 
B

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
Click to expand...
File > Page setup > Sheet-tab
Here you can select the rows you want to appear
 
D

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
D

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.

David McRitchie said:
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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm



Bart Snel said:
mario schreef:
File > Page setup > Sheet-tab
Here you can select the rows you want to appear
Click to expand...
Click to expand...
 
Top