software

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, quot;How now brown cow.quot;, it should
show over cells A2 and A3. However, I also need the carriage returns to be
picked up. If I use the quot;Wrap Textquot; 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.

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

--

Dave Peterson

Actually I cannot merge the cells for reasons that you mention as well as
some printing issues we have found in the past. And yes I meant A1:C1.

quot;Dave Petersonquot; wrote:

gt; Maybe you could merge those cells (A1:A3 or did you really mean A1:C1?)
gt;
gt; But be aware that merging cells causes trouble with sorting, pasting, and lots
gt; of other stuff.
gt;
gt; Format|cells|alignment tab is where you can toggle merged cells.
gt;
gt; Stanley wrote:
gt; gt;
gt; gt; I am trying to get my text to run over to the next cell only in display not
gt; gt; actual value of that cell. So if A1 says, quot;How now brown cow.quot;, it should
gt; gt; show over cells A2 and A3. However, I also need the carriage returns to be
gt; gt; picked up. If I use the quot;Wrap Textquot; property it only shows the sentence in
gt; gt; that cell. If I don't use it I get the [] (brackets) in place of the carriage
gt; gt; return.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Then I don't think you can do what you want.

If you use wraptext, the text won't overflow to the adjacent cells. If you have
wraptext off, then your alt-enters won't work the way you want.

How about an ugly solution.

You put the data in another worksheet set up exactly the way you want.

Then you take a picture of that cell and paste it over A1:C1.

Select your cell that's pretty
Edit|copy
select A1 of the other sheet
shift-Edit|Paste picture link

This may not work for the some of the same issues you had with merged cells,
though.

Stanley wrote:
gt;
gt; Actually I cannot merge the cells for reasons that you mention as well as
gt; some printing issues we have found in the past. And yes I meant A1:C1.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Maybe you could merge those cells (A1:A3 or did you really mean A1:C1?)
gt; gt;
gt; gt; But be aware that merging cells causes trouble with sorting, pasting, and lots
gt; gt; of other stuff.
gt; gt;
gt; gt; Format|cells|alignment tab is where you can toggle merged cells.
gt; gt;
gt; gt; Stanley wrote:
gt; gt; gt;
gt; gt; gt; I am trying to get my text to run over to the next cell only in display not
gt; gt; gt; actual value of that cell. So if A1 says, quot;How now brown cow.quot;, it should
gt; gt; gt; show over cells A2 and A3. However, I also need the carriage returns to be
gt; gt; gt; picked up. If I use the quot;Wrap Textquot; property it only shows the sentence in
gt; gt; gt; that cell. If I don't use it I get the [] (brackets) in place of the carriage
gt; gt; gt; return.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson