Printing spread sheet

[willquill]

Is there ban easier way to cut and paste a long document only printing the first three columns on one page?

 

[Oaktree]

If you want to print only columns A:C, just select columns A:C and go to Page Layout --> Print Area --> Set Print Area.

And, if you only want to print the first page, you can do that in File --> Print by changing the "Pages" entry in the settings section to be 1 to 1.

Is that what you mean?

Or are you saying you want the data from columns A:C from all rows transposed so that it fits on one page? (e.g. A1:C50 in A:C, then A51:C100 in E:G, etc.)?

If *that's* what you're after, you could either use a macro or an index function on a new sheet like this:

'new sheet'!A1 =INDEX(Sheet1!$A:$A,ROW()+(COLUMN()-COLUMN($A$1))/4*50)
'new sheet'!B1 =INDEX(Sheet1!$B:$B,ROW()+(COLUMN()-COLUMN($B$1))/4*50)
'new sheet'!C1 =INDEX(Sheet1!$C:$C,ROW()+(COLUMN()-COLUMN($C$1))/4*50)

Copy A1:C1 down through A50:C50 (or 25, modifying the 50s to 25s at the end of the formulas).

Then, copy A:D to E:H, I:L, etc. until you've captured all of the data.