#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 52
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text Wrapping Gaffnr Excel Worksheet Functions 2 November 20th 07 10:43 AM
wrapping columns mcarrington Excel Discussion (Misc queries) 0 August 16th 06 09:22 PM
wrapping columns in a printout Jim Excel Discussion (Misc queries) 2 July 12th 06 08:48 PM
wrapping text across a number of columns Den New Users to Excel 8 April 4th 06 03:32 AM
Wrapping Text Confused Excel Discussion (Misc queries) 2 June 17th 05 12:53 AM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"