print in blocks in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing: page count exceeds pages in tab 1
Excel Fit to page print options in Excel 1
Print rows at end of pages 4
Comparing 2 blocks of text and data 2
Print Setup 3
wrap columns to print in rows 1
Arggh! Each row prints on separate page 2
Help Reg Print 1

Back
Top