Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How print pages without including the first sheet? | New Users to Excel | |||
Breaking a long column to print on one sheet | Excel Discussion (Misc queries) | |||
How to print multiple pages per sheet | Excel Discussion (Misc queries) | |||
Print multiple pages on one sheet | Excel Discussion (Misc queries) | |||
Print 2 pages per sheet | Excel Programming |