View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Extend text to next cell

Maybe you could merge those cells (A1:A3 or did you really mean A1:C1?)

But be aware that merging cells causes trouble with sorting, pasting, and lots
of other stuff.

Format|cells|alignment tab is where you can toggle merged cells.

Stanley wrote:

I am trying to get my text to run over to the next cell only in display not
actual value of that cell. So if A1 says, "How now brown cow.", it should
show over cells A2 and A3. However, I also need the carriage returns to be
picked up. If I use the "Wrap Text" property it only shows the sentence in
that cell. If I don't use it I get the [] (brackets) in place of the carriage
return.


--

Dave Peterson