excell

  • Thread starter Thread starter debbie
  • Start date Start date
D

debbie

HOW CAN I, WORKING IN EXCELL, MAKE THE TEXT WRAP AROUND
FROM LINE TO LINE AFTER I HAVE MERGED ALL OF THE CELL INTO
1 LINE, EXAMPLE LIKE A WORD DOCUMENT?
 
Hi Debbie,

First, please don't write in caps. To us readers, it seems like you are
shouting at us. And I am sure that is not the impression you want.

Second, you are limited to a certain number of character to one cell. I
think the number might be 256 characters. It might be more. In any event,
you cannot write paragraphs in a single cell. You can format a cell...

Format | Cells | Alignment | Wrap Text

If you want the text to automatically go from cell to cell and wrap for you,
I am not sure how you can easily accomplish this. I think Microsoft Word is
a better choice.

Hope this helps.

Regards,
Kevin
 
If you enable wrap text, then it'll wrap in a merged cell. But excel won't let
you autofit the rowheight for merged cells. But you could change the rowheight
manually or use a macro written by Jim Rech:

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

===

But even if you do everything ok, you might not see what you typed. Left to its
own devices, excel will only show about 1000 characters in a cell (although you
can put almost 32k characters in that cell).

You can see more by adding alt-enters (to force a new line within the cell) to
your text whenever you want to force a line break.
 
Back
Top