Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
david
 
Posts: n/a
Default 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   Report Post  
Richard Neville
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can I enter books of the bible into excel and print out bingo. BArtneedsHELP New Users to Excel 5 August 31st 05 09:10 PM
How do I set up print titles in Excel? ON1 Excel Worksheet Functions 1 February 22nd 05 04:11 PM
Set "print all text as black" as default in Excel CMK Excel Worksheet Functions 0 January 25th 05 09:31 PM
Microsoft Excel could not find anything to print cyndi Excel Discussion (Misc queries) 1 December 22nd 04 02:40 PM
How to print invoices for each advertiser from Excel worksheet Fred Excel Worksheet Functions 1 December 20th 04 10:08 AM


All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"