Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Wrapping Issue
This is in Excel 2003 and appears to be a bug.
I have a cell with a large amount of text. Text wrapping has been enabled and works fine for part of the cell. Eight lines down, it suddenly stops wrapping and runs off the page. I've tried Paste Special off other cells to correct this; turning off word wrap and turning it back on--I even tried pasting it into a different cell with the same result. Nothing works except to manually insert a carriage return, which is a big nuisance. I don't know if it helps, but this problem starts at 164 words and and 960 characters. -- Linda Adams http://www.hackman-adams.com http://www.david-hedison.com ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Wrapping Issue
If you add alt-enters (to force new lines in the cell) every 80-100 characters,
you should be able to see more characters. Linda Adams wrote: This is in Excel 2003 and appears to be a bug. I have a cell with a large amount of text. Text wrapping has been enabled and works fine for part of the cell. Eight lines down, it suddenly stops wrapping and runs off the page. I've tried Paste Special off other cells to correct this; turning off word wrap and turning it back on--I even tried pasting it into a different cell with the same result. Nothing works except to manually insert a carriage return, which is a big nuisance. I don't know if it helps, but this problem starts at 164 words and and 960 characters. -- Linda Adams http://www.hackman-adams.com http://www.david-hedison.com ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Wrapping Issue
I've seen this before in 2003, all I do is go between the cells, say
between rows 17 and 18, place my pointer directly in the middle of the two rows directly on the left side of the page (i.e., between the actual row numbers) until my pointer changes to the up/down arrow pointer and double click. This expands the row to allow for all of my text to show. I sometime have to do this a few times, but not that often. Not sure what is in 2003... HTH |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Wrapping Issue
Unfortunately, after it starts no longer wrapping, I have to do a hard return
at the end of every single line. This is a big nuisance on something where I am constantly adding information and have to go back through and start adding carriage returns so everyone can see the text. -- Linda Adams http://www.hackman-adams.com http://www.david-hedison.com "Dave Peterson" wrote: If you add alt-enters (to force new lines in the cell) every 80-100 characters, you should be able to see more characters. Linda Adams wrote: This is in Excel 2003 and appears to be a bug. I have a cell with a large amount of text. Text wrapping has been enabled and works fine for part of the cell. Eight lines down, it suddenly stops wrapping and runs off the page. I've tried Paste Special off other cells to correct this; turning off word wrap and turning it back on--I even tried pasting it into a different cell with the same result. Nothing works except to manually insert a carriage return, which is a big nuisance. I don't know if it helps, but this problem starts at 164 words and and 960 characters. -- Linda Adams http://www.hackman-adams.com http://www.david-hedison.com ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Wrapping Issue
I've tried this, too. The text still runs off the page and doesn't wrap.
-- Linda Adams http://www.hackman-adams.com http://www.david-hedison.com "DNA" wrote: I've seen this before in 2003, all I do is go between the cells, say between rows 17 and 18, place my pointer directly in the middle of the two rows directly on the left side of the page (i.e., between the actual row numbers) until my pointer changes to the up/down arrow pointer and double click. This expands the row to allow for all of my text to show. I sometime have to do this a few times, but not that often. Not sure what is in 2003... HTH |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Wrapping Issue
I didn't say it wasn't irritating <bg, I just said that alt-enters would fix
the problem. Have you thought of using a textbox instead? Linda Adams wrote: Unfortunately, after it starts no longer wrapping, I have to do a hard return at the end of every single line. This is a big nuisance on something where I am constantly adding information and have to go back through and start adding carriage returns so everyone can see the text. -- Linda Adams http://www.hackman-adams.com http://www.david-hedison.com "Dave Peterson" wrote: If you add alt-enters (to force new lines in the cell) every 80-100 characters, you should be able to see more characters. Linda Adams wrote: This is in Excel 2003 and appears to be a bug. I have a cell with a large amount of text. Text wrapping has been enabled and works fine for part of the cell. Eight lines down, it suddenly stops wrapping and runs off the page. I've tried Paste Special off other cells to correct this; turning off word wrap and turning it back on--I even tried pasting it into a different cell with the same result. Nothing works except to manually insert a carriage return, which is a big nuisance. I don't know if it helps, but this problem starts at 164 words and and 960 characters. -- Linda Adams http://www.hackman-adams.com http://www.david-hedison.com ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text Wrapping Issue
Hello Linda,
apparently, it's not a bug. I'm using the Dutch version, and it behaves exactly the same way. I was looking in this forum, found your question and someone else's. the other person got an answer: "From Excel's Help (search 'specifications') Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar." Apparently it's intentional, I haven't got the faintest clue why, but we'll just have to live with it I supposte :-| I'm going to try to figure out how to use the text box feature. Menno. "Linda Adams" wrote: This is in Excel 2003 and appears to be a bug. I have a cell with a large amount of text. Text wrapping has been enabled and works fine for part of the cell. Eight lines down, it suddenly stops wrapping and runs off the page. I've tried Paste Special off other cells to correct this; turning off word wrap and turning it back on--I even tried pasting it into a different cell with the same result. Nothing works except to manually insert a carriage return, which is a big nuisance. I don't know if it helps, but this problem starts at 164 words and and 960 characters. -- Linda Adams http://www.hackman-adams.com http://www.david-hedison.com ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
wrapping text from one row to the next | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Pivot Table - Wrapping Text | Excel Discussion (Misc queries) | |||
Issue with copying Text. | Excel Discussion (Misc queries) |