Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I had to type in a very long description with paragraphs (by pressing alt
return) in one cell in excel. I formatted the cell to "wrap text" and to align to the top of the cell. I have now lost the last part of the text and this will only appear if I extend the column width. what am I doing wrong and how can I rectify it? |
#2
![]() |
|||
|
|||
![]()
Hi
how many characters do you have in this cell. If you have more than 1000 this could happen -- Regards Frank Kabel Frankfurt, Germany text in cell in exces wrote: I had to type in a very long description with paragraphs (by pressing alt return) in one cell in excel. I formatted the cell to "wrap text" and to align to the top of the cell. I have now lost the last part of the text and this will only appear if I extend the column width. what am I doing wrong and how can I rectify it? |
#3
![]() |
|||
|
|||
![]()
I recreated your problem and solved it by adjusting the alignment
horizontally and vertically in the cell. I think it was solved when I set them both to centre in the cell both ways. Interestingly when I opened a new document I could not recreate the problem you had. Anyway, you might try resetting the alignment and hopefully will get all your text showing. Hal "text in cell in exces" wrote: I had to type in a very long description with paragraphs (by pressing alt return) in one cell in excel. I formatted the cell to "wrap text" and to align to the top of the cell. I have now lost the last part of the text and this will only appear if I extend the column width. what am I doing wrong and how can I rectify it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
typing text onto two lines (one above the other) in one cell | Excel Discussion (Misc queries) | |||
Hide text that doesn't fit in the cell | Excel Discussion (Misc queries) | |||
How I do I rotate text in an excel cell? The rotate commands is g. | Excel Discussion (Misc queries) | |||
Can I place visible text in cell that won't print | Excel Discussion (Misc queries) | |||
I am trying to link based on a text value instead of cell position | Links and Linking in Excel |