Wrapping Columns?

C

Chaudfeu

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?
 
T

tedmi

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change defualt word wrap in Excel 2007 2
Breaking a long column to print on one sheet 1
wrap columns to print in rows 1
How to "merge" multiple colums to reduce page count 4
Error on text wrap pivot table 1
importing specific data from one spread sheet into a new spreadshe 7
Scroll data into 3 columns 2
Transfer information from column 3

Top