ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Wrapping Columns? (https://www.excelbanter.com/excel-discussion-misc-queries/201000-wrapping-columns.html)

Chaudfeu

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?

TedMi

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