Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Wrapping Columns?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Wrapping | Excel Worksheet Functions | |||
wrapping columns | Excel Discussion (Misc queries) | |||
wrapping columns in a printout | Excel Discussion (Misc queries) | |||
wrapping text across a number of columns | New Users to Excel | |||
Wrapping Text | Excel Discussion (Misc queries) |