Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I enter books of the bible into excel and print out bingo. | New Users to Excel | |||
How do I set up print titles in Excel? | Excel Worksheet Functions | |||
Set "print all text as black" as default in Excel | Excel Worksheet Functions | |||
Microsoft Excel could not find anything to print | Excel Discussion (Misc queries) | |||
How to print invoices for each advertiser from Excel worksheet | Excel Worksheet Functions |