Extend text to next cell
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. |
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 |
Extend text to next cell
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. "Dave Peterson" wrote: 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 |
Extend text to next cell
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: 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. "Dave Peterson" wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 07:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com