View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pygmalion pygmalion is offline
external usenet poster
 
Posts: 2
Default Print long sheet shared on pages

Hi

I'm struggling with the following problem.
I have an excel sheet that exists of two columns, name and e-mail.
Now, I have to print the entire sheet, but it is about 2500 rows long.

Is there a possibility to let excel print it twice per page?

So, for example:

Instead of printing the following (consider it to be a long list):

Jack Higgins
Peter Jackson

....
....
-- here would be the end of the first printed page
Mike Wilson

Joe Placido k.placido
....
....
-- here would be the end of te second printed page

Excel should be able to print it in the following way:

Jack Higgins
Mike Wilson

Peter Jackson
Joe Placido

..... ....
..... ....
..... ....


I'm a little familiar with programming in excel, but not so much in
implementing
it (with vb, for example). If you use such a method, please also
explain
how to implement it.

Thanks a lot in advance
pygmalion