Wrapping Columns?
Assumptions: Data in columns A & B; headings in row 1, 40 rows on a page.
In C1: =A1; in D1: =B1
In C2: =A41; in D2: =B41
Copy C2,D2 down to row 40
Repeat in cols E & F if desired, but in E2 put =A81
Adjust as nec. for your layout.
--
TedMi
"Chaudfeu" wrote:
Is there any way in excel to wrap columns?
I have two columns of information and would like if possible for them to
wrap to the next available two columns when the information hits the end of
the page. Is there a way to do this aside from manually cutting and pasting?
|