ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   word wrap in non-merged cells (https://www.excelbanter.com/excel-discussion-misc-queries/115147-word-wrap-non-merged-cells.html)

Arun

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?

Raffael

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?




Manoj

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?



All times are GMT +1. The time now is 04:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com