I am having probems with wrap text. The last line, in a ten line entry,
won't wrap. Is there anything I can do about this as it is happening on at
least five cells
Many thanks
James
Have you tried to manually place the quot;carriage returnquot; by editing the cell
(F2), moving to the appropriate spot and simaltaneously hitting the Alt-Enter
keys? or is manual entry not an option in this instance?
quot; wrote:
gt; I am having probems with wrap text. The last line, in a ten line entry,
gt; won't wrap. Is there anything I can do about this as it is happening on at
gt; least five cells
gt;
gt; Many thanks
gt;
gt; James
Sludge
Already tried the Alt-Enter route to no avail. Interestingly if I use Alt
Enter then enter a letter, the letter appears but I'm still missing the text
on the line above.
Any thoughts (and thanks again for your help on this)
James
quot;SludgeQuakequot; wrote:
gt; Have you tried to manually place the quot;carriage returnquot; by editing the cell
gt; (F2), moving to the appropriate spot and simaltaneously hitting the Alt-Enter
gt; keys? or is manual entry not an option in this instance?
gt;
gt; quot; wrote:
gt;
gt; gt; I am having probems with wrap text. The last line, in a ten line entry,
gt; gt; won't wrap. Is there anything I can do about this as it is happening on at
gt; gt; least five cells
gt; gt;
gt; gt; Many thanks
gt; gt;
gt; gt; James
Did you adjust the rowheight?
wrote:
gt;
gt; Sludge
gt;
gt; Already tried the Alt-Enter route to no avail. Interestingly if I use Alt
gt; Enter then enter a letter, the letter appears but I'm still missing the text
gt; on the line above.
gt;
gt; Any thoughts (and thanks again for your help on this)
gt;
gt; James
gt;
gt; quot;SludgeQuakequot; wrote:
gt;
gt; gt; Have you tried to manually place the quot;carriage returnquot; by editing the cell
gt; gt; (F2), moving to the appropriate spot and simaltaneously hitting the Alt-Enter
gt; gt; keys? or is manual entry not an option in this instance?
gt; gt;
gt; gt; quot; wrote:
gt; gt;
gt; gt; gt; I am having probems with wrap text. The last line, in a ten line entry,
gt; gt; gt; won't wrap. Is there anything I can do about this as it is happening on at
gt; gt; gt; least five cells
gt; gt; gt;
gt; gt; gt; Many thanks
gt; gt; gt;
gt; gt; gt; James
--
Dave Peterson
Yes
quot;Dave Petersonquot; wrote:
gt; Did you adjust the rowheight?
gt;
gt; wrote:
gt; gt;
gt; gt; Sludge
gt; gt;
gt; gt; Already tried the Alt-Enter route to no avail. Interestingly if I use Alt
gt; gt; Enter then enter a letter, the letter appears but I'm still missing the text
gt; gt; on the line above.
gt; gt;
gt; gt; Any thoughts (and thanks again for your help on this)
gt; gt;
gt; gt; James
gt; gt;
gt; gt; quot;SludgeQuakequot; wrote:
gt; gt;
gt; gt; gt; Have you tried to manually place the quot;carriage returnquot; by editing the cell
gt; gt; gt; (F2), moving to the appropriate spot and simaltaneously hitting the Alt-Enter
gt; gt; gt; keys? or is manual entry not an option in this instance?
gt; gt; gt;
gt; gt; gt; quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I am having probems with wrap text. The last line, in a ten line entry,
gt; gt; gt; gt; won't wrap. Is there anything I can do about this as it is happening on at
gt; gt; gt; gt; least five cells
gt; gt; gt; gt;
gt; gt; gt; gt; Many thanks
gt; gt; gt; gt;
gt; gt; gt; gt; James
gt;
gt; --
gt;
gt; Dave Peterson
gt;
I put alt-enters every 80-100 characters to force new lines in the cell.
How often do you insert those alt-enters?wrote:
gt;
gt; Yes
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Did you adjust the rowheight?
gt; gt;
gt; gt; wrote:
gt; gt; gt;
gt; gt; gt; Sludge
gt; gt; gt;
gt; gt; gt; Already tried the Alt-Enter route to no avail. Interestingly if I use Alt
gt; gt; gt; Enter then enter a letter, the letter appears but I'm still missing the text
gt; gt; gt; on the line above.
gt; gt; gt;
gt; gt; gt; Any thoughts (and thanks again for your help on this)
gt; gt; gt;
gt; gt; gt; James
gt; gt; gt;
gt; gt; gt; quot;SludgeQuakequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Have you tried to manually place the quot;carriage returnquot; by editing the cell
gt; gt; gt; gt; (F2), moving to the appropriate spot and simaltaneously hitting the Alt-Enter
gt; gt; gt; gt; keys? or is manual entry not an option in this instance?
gt; gt; gt; gt;
gt; gt; gt; gt; quot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I am having probems with wrap text. The last line, in a ten line entry,
gt; gt; gt; gt; gt; won't wrap. Is there anything I can do about this as it is happening on at
gt; gt; gt; gt; gt; least five cells
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Many thanks
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; James
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;
--
Dave Peterson
Dave - I think the problem is there are more than 1200 characters in the cell
so hitting the 1024 problem
quot;Dave Petersonquot; wrote:
gt; I put alt-enters every 80-100 characters to force new lines in the cell.
gt;
gt; How often do you insert those alt-enters?
gt;
gt;
gt;
gt; wrote:
gt; gt;
gt; gt; Yes
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; Did you adjust the rowheight?
gt; gt; gt;
gt; gt; gt; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Sludge
gt; gt; gt; gt;
gt; gt; gt; gt; Already tried the Alt-Enter route to no avail. Interestingly if I use Alt
gt; gt; gt; gt; Enter then enter a letter, the letter appears but I'm still missing the text
gt; gt; gt; gt; on the line above.
gt; gt; gt; gt;
gt; gt; gt; gt; Any thoughts (and thanks again for your help on this)
gt; gt; gt; gt;
gt; gt; gt; gt; James
gt; gt; gt; gt;
gt; gt; gt; gt; quot;SludgeQuakequot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Have you tried to manually place the quot;carriage returnquot; by editing the cell
gt; gt; gt; gt; gt; (F2), moving to the appropriate spot and simaltaneously hitting the Alt-Enter
gt; gt; gt; gt; gt; keys? or is manual entry not an option in this instance?
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I am having probems with wrap text. The last line, in a ten line entry,
gt; gt; gt; gt; gt; gt; won't wrap. Is there anything I can do about this as it is happening on at
gt; gt; gt; gt; gt; gt; least five cells
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Many thanks
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; James
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;
I don't think that 1024 number will be a problem if you add those alt-enters
every 80-100 characters.
I've seen well over 5000 characters with font size small enough, rowheight and
columnwidth large enough.
wrote:
gt;
gt; Dave - I think the problem is there are more than 1200 characters in the cell
gt; so hitting the 1024 problem
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; I put alt-enters every 80-100 characters to force new lines in the cell.
gt; gt;
gt; gt; How often do you insert those alt-enters?
gt; gt;
gt; gt;
gt; gt;
gt; gt; wrote:
gt; gt; gt;
gt; gt; gt; Yes
gt; gt; gt;
gt; gt; gt; quot;Dave Petersonquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Did you adjust the rowheight?
gt; gt; gt; gt;
gt; gt; gt; gt; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Sludge
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Already tried the Alt-Enter route to no avail. Interestingly if I use Alt
gt; gt; gt; gt; gt; Enter then enter a letter, the letter appears but I'm still missing the text
gt; gt; gt; gt; gt; on the line above.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Any thoughts (and thanks again for your help on this)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; James
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;SludgeQuakequot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Have you tried to manually place the quot;carriage returnquot; by editing the cell
gt; gt; gt; gt; gt; gt; (F2), moving to the appropriate spot and simaltaneously hitting the Alt-Enter
gt; gt; gt; gt; gt; gt; keys? or is manual entry not an option in this instance?
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; quot; wrote:
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; I am having probems with wrap text. The last line, in a ten line entry,
gt; gt; gt; gt; gt; gt; gt; won't wrap. Is there anything I can do about this as it is happening on at
gt; gt; gt; gt; gt; gt; gt; least five cells
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; Many thanks
gt; gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; gt; James
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt;
gt; gt; gt; gt; Dave Peterson
gt; gt; gt; gt;
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;
--
Dave Peterson
- Aug 14 Mon 2006 20:09
Wrap text problem in Excel 2003
close
全站熱搜
留言列表
發表留言