Mrex, are you saying you want to print cols A-D on the first line of a page, then E-H on the second line, I-L on the third line and so on? One worksheet row to each page, for example?

Someone here may know of a way you can get Excel to do that, but I'll bet you'll have to write a program to rearrange the data. You're right, you don't want to do it by hand. Are you willing to tackle that? Because off-hand I don't know of any other way.