![]() |
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? |
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? |
All times are GMT +1. The time now is 06:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com