pre-formatted sheet:

[CjTex61]

How do I get two columns to act like columns in word? I want two columns to
go the next two, then the next, etc for the page size of 8.5 x 11. I have a
worksheet that was sent to me and it's 28 pages long, but I'd like to have
one page.
I've probably confused you all, but I don't know how else to ask.

 

[Gord Dibben]

A "page" can be many different sizes depending upon margins so difficult to
say how many rows to a "page"

What is the actual range of data?

A1:B???

I take it you want to move data in columns A and B into several columns.

How do you want this data moved?

Snaked or side by side?

It may not fit on one sheet of paper without severe reduction in size.

Post back with some details.


Gord Dibben MS Excel MVP