How about something like this, assuming that your original data is all in one column:
Create a second worksheet to pull in the data from the first. Let's say that you want 45 items in each column. So, the first 45 data points would be in column A on the new sheet, the second 45 would be in column 2, and so on. You could do this manually, or you could use a formula. When you go to print the second sheet, you can go to File -- >Page Setup and force it to print 1 page tall by 1 page wide. In other words, shrink to fit.
If you want to speed this up, you can use a formula like this on the second sheet:
=OFFSET(Sheet1!$A$1,(COLUMN()-1)*Sheet1!$G$1+ROW()-1,0)
That assumes that your original data starts in A1 on sheet 1, and that you have a cell (G1 in my example) that tells how many (45?) data points should be in each column. It also assumes that the data in sheet 2 also starts in A1.
Just put that formula in A1 on sheet 2, copy it down to A45. Now, copy that range across to however many columns you need. If your data doesn't completely fill the lasy column(s) then you'll get zeros as the result. You can turn off the display of zeros (assuming that none of your actual data points are zeros) by going to Tools --> Options and then on the View tab uncheck Zero Values. This will only affect sheet 2, not sheet 1.
If I've misunderstood, please explain again.
Facebook
Twitter