Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Text Wrap
User has a cell that is set for text wrap. She has textwrap in that the last
line will not show up. Have increased cell height, but text does not show. Have gotten text to show, but only by widening the cell. This is not an option because the columns will not fit on one page then. Row height is not an issue, except that not all of the text will show no matter the height you make the cell. Does Excel have a limitation on the number of characters can be in a cell and would this limitation be negated by increasing the width of the cell/column? |
#2
|
|||
|
|||
If you add some alt-enters (every 80-100 characters) in that cell, can you see
everything--you may have to resize that rowheight manually, though. holy dog wrote: User has a cell that is set for text wrap. She has textwrap in that the last line will not show up. Have increased cell height, but text does not show. Have gotten text to show, but only by widening the cell. This is not an option because the columns will not fit on one page then. Row height is not an issue, except that not all of the text will show no matter the height you make the cell. Does Excel have a limitation on the number of characters can be in a cell and would this limitation be negated by increasing the width of the cell/column? -- Dave Peterson |
#3
|
|||
|
|||
Thank you. I tested this and it works, although the user insists that she
should not need to do this. Oh well. "Dave Peterson" wrote: If you add some alt-enters (every 80-100 characters) in that cell, can you see everything--you may have to resize that rowheight manually, though. holy dog wrote: User has a cell that is set for text wrap. She has textwrap in that the last line will not show up. Have increased cell height, but text does not show. Have gotten text to show, but only by widening the cell. This is not an option because the columns will not fit on one page then. Row height is not an issue, except that not all of the text will show no matter the height you make the cell. Does Excel have a limitation on the number of characters can be in a cell and would this limitation be negated by increasing the width of the cell/column? -- Dave Peterson |
#4
|
|||
|
|||
Did you insist that you shouldn't have to pay taxes?
<vbg holy dog wrote: Thank you. I tested this and it works, although the user insists that she should not need to do this. Oh well. "Dave Peterson" wrote: If you add some alt-enters (every 80-100 characters) in that cell, can you see everything--you may have to resize that rowheight manually, though. holy dog wrote: User has a cell that is set for text wrap. She has textwrap in that the last line will not show up. Have increased cell height, but text does not show. Have gotten text to show, but only by widening the cell. This is not an option because the columns will not fit on one page then. Row height is not an issue, except that not all of the text will show no matter the height you make the cell. Does Excel have a limitation on the number of characters can be in a cell and would this limitation be negated by increasing the width of the cell/column? -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
NO, I wish I would have thought of it then, but then you know the customer is
always right even when they are wrong. I appreciate the help. Thank You Holy Dog "Dave Peterson" wrote: Did you insist that you shouldn't have to pay taxes? <vbg holy dog wrote: Thank you. I tested this and it works, although the user insists that she should not need to do this. Oh well. "Dave Peterson" wrote: If you add some alt-enters (every 80-100 characters) in that cell, can you see everything--you may have to resize that rowheight manually, though. holy dog wrote: User has a cell that is set for text wrap. She has textwrap in that the last line will not show up. Have increased cell height, but text does not show. Have gotten text to show, but only by widening the cell. This is not an option because the columns will not fit on one page then. Row height is not an issue, except that not all of the text will show no matter the height you make the cell. Does Excel have a limitation on the number of characters can be in a cell and would this limitation be negated by increasing the width of the cell/column? -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
Alt+Enter does gain you an automatic text wrap, but
You probably want to know why the Alt-Enter is needed in some cases but not in most cases when cell wrap is already turned on. If you look in HELP you will see that it indicates .under "specification" (specification limits) Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. By using Alt+Enter you can display over 1,024 chars (and/or spaces) in a cell, one case where specification limits apparently were incorrectly/incompletely documented. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "holy dog" wrote in message ... NO, I wish I would have thought of it then, but then you know the customer is always right even when they are wrong. I appreciate the help. Thank You Holy Dog "Dave Peterson" wrote: Did you insist that you shouldn't have to pay taxes? <vbg holy dog wrote: Thank you. I tested this and it works, although the user insists that she should not need to do this. Oh well. "Dave Peterson" wrote: If you add some alt-enters (every 80-100 characters) in that cell, can you see everything--you may have to resize that rowheight manually, though. holy dog wrote: User has a cell that is set for text wrap. She has textwrap in that the last line will not show up. Have increased cell height, but text does not show. Have gotten text to show, but only by widening the cell. This is not an option because the columns will not fit on one page then. Row height is not an issue, except that not all of the text will show no matter the height you make the cell. Does Excel have a limitation on the number of characters can be in a cell and would this limitation be negated by increasing the width of the cell/column? -- Dave Peterson -- Dave Peterson |
#7
|
|||
|
|||
Thanks, I looked under the help, but did not check specifications. I do
appreciate the assistance and have learned much from you all. These NGs are the greatest thing since sliced bread "David McRitchie" wrote: Alt+Enter does gain you an automatic text wrap, but You probably want to know why the Alt-Enter is needed in some cases but not in most cases when cell wrap is already turned on. If you look in HELP you will see that it indicates .under "specification" (specification limits) Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar. By using Alt+Enter you can display over 1,024 chars (and/or spaces) in a cell, one case where specification limits apparently were incorrectly/incompletely documented. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "holy dog" wrote in message ... NO, I wish I would have thought of it then, but then you know the customer is always right even when they are wrong. I appreciate the help. Thank You Holy Dog "Dave Peterson" wrote: Did you insist that you shouldn't have to pay taxes? <vbg holy dog wrote: Thank you. I tested this and it works, although the user insists that she should not need to do this. Oh well. "Dave Peterson" wrote: If you add some alt-enters (every 80-100 characters) in that cell, can you see everything--you may have to resize that rowheight manually, though. holy dog wrote: User has a cell that is set for text wrap. She has textwrap in that the last line will not show up. Have increased cell height, but text does not show. Have gotten text to show, but only by widening the cell. This is not an option because the columns will not fit on one page then. Row height is not an issue, except that not all of the text will show no matter the height you make the cell. Does Excel have a limitation on the number of characters can be in a cell and would this limitation be negated by increasing the width of the cell/column? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap text | Excel Discussion (Misc queries) | |||
row height not accounting for wrap text | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
Why doesn't text wrap in a cell in Excel? | Excel Discussion (Misc queries) |