Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrapping of very long text in EXCEL 2002 cells
I have a very long text with multiple lines in one cell (formatted as text).
That cell shows(and prints) only #####################... When I select the cell is shows the proper text lines in the toolbar. Autowrap is turned on, but does not seem to working for this cell (it does for others). I tried making the row hight large enough to show it, but no luck. I need to keep the column width fixed. How can format the cell to have autowrap work correctly? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrapping of very long text in EXCEL 2002 cells
Use ALT+ENTER at the point where the text is to break
best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "prjman" wrote in message ... I have a very long text with multiple lines in one cell (formatted as text). That cell shows(and prints) only #####################... When I select the cell is shows the proper text lines in the toolbar. Autowrap is turned on, but does not seem to working for this cell (it does for others). I tried making the row hight large enough to show it, but no luck. I need to keep the column width fixed. How can format the cell to have autowrap work correctly? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrapping of very long text in EXCEL 2002 cells
Re-format as General.
Excel has a problem when the number of characters is between 255 and 1024. Gord Dibben MS Excel MVP On Thu, 15 Jun 2006 10:51:02 -0700, prjman wrote: I have a very long text with multiple lines in one cell (formatted as text). That cell shows(and prints) only #####################... When I select the cell is shows the proper text lines in the toolbar. Autowrap is turned on, but does not seem to working for this cell (it does for others). I tried making the row hight large enough to show it, but no luck. I need to keep the column width fixed. How can format the cell to have autowrap work correctly? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
wrapping of very long text in EXCEL 2002 cells
Thanks for your quick feedback, Bernard.
I had already used Alt+enter to separate the lines within the cell. So there must me something else to do. Regards, prjman "Bernard Liengme" wrote: Use ALT+ENTER at the point where the text is to break best wishes -- Bernard Liengme www.stfx.ca/people/bliengme remove CAPS in email address "prjman" wrote in message ... I have a very long text with multiple lines in one cell (formatted as text). That cell shows(and prints) only #####################... When I select the cell is shows the proper text lines in the toolbar. Autowrap is turned on, but does not seem to working for this cell (it does for others). I tried making the row hight large enough to show it, but no luck. I need to keep the column width fixed. How can format the cell to have autowrap work correctly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should have a hanging indent for long text entries | Excel Discussion (Misc queries) | |||
I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) | |||
Truncated wrapped text cells in Excel | Excel Discussion (Misc queries) | |||
moving text from a word document to excel | New Users to Excel | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |