Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default word wrap in non-merged cells

I would like to put some paragraph length text in a box that is 3 columns
wide. I really do not want to merge the cells for numerous reasons detailed
on this board, however I do not want the text to be center aligned and I do
want it to wrap.

Is there any way to accomplish this without merging 3 horizontal cells?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 29
Default word wrap in non-merged cells

I'm afraid you cannot to do it without centering the text...


"Arun" escreveu na mensagem
...
I would like to put some paragraph length text in a box that is 3 columns
wide. I really do not want to merge the cells for numerous reasons
detailed
on this board, however I do not want the text to be center aligned and I
do
want it to wrap.

Is there any way to accomplish this without merging 3 horizontal cells?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 28
Default word wrap in non-merged cells

Dear Arun

Highlight the three columns and a few rows below it as a block. e.g. enter
text in cell A1 and highlight A1:C5. Then do a Edit - Fill - Justify.
This will break the text into the rows below and spread over the three
columns.

Manoj

"Arun" wrote:

I would like to put some paragraph length text in a box that is 3 columns
wide. I really do not want to merge the cells for numerous reasons detailed
on this board, however I do not want the text to be center aligned and I do
want it to wrap.

Is there any way to accomplish this without merging 3 horizontal cells?

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
Copying a column of single cells into a column of merged cells [email protected] Excel Discussion (Misc queries) 1 August 16th 06 01:18 PM
How to make (XL) Merge Cells and Word Wrap work concurrently? George D. Excel Discussion (Misc queries) 1 May 2nd 06 05:41 PM
contents in cells are not visible when word wrap is selected Steve Excel Discussion (Misc queries) 2 January 7th 06 12:36 AM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Is there a way to setup word wrap within cells? newbie Excel Discussion (Misc queries) 1 August 3rd 05 12:32 AM


All times are GMT +1. The time now is 02:18 PM.

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"