print in blocks in excel
 

How can i keep "for exemple"; 5 rows together whin i print so that the
furst 2 are not on page 1 and the last 3 on page 2.

But that the 5 rows are all on page 2 whin the 5 rows do not fit anymore on
page 1.

my form is bild up in blocks of rows that must stay thogether. The blocks
(groep of rows) can be hidden so that the position of the blocks can change.

can i do this with a macro?

You don't need a macro. In the View menu, select Page Break Preview, and use
the mouse to move the horizontal blue line so you will keep the 5 rows
together. Then switch back to Normal view.

"david" wrote in message
...

How can i keep "for exemple"; 5 rows together whin i print so that the
furst 2 are not on page 1 and the last 3 on page 2.

But that the 5 rows are all on page 2 whin the 5 rows do not fit anymore
on
page 1.

my form is bild up in blocks of rows that must stay thogether. The blocks
(groep of rows) can be hidden so that the position of the blocks can
change.

can i do this with a macro?