Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am not seeing all text in a cell despite wrap text
I am typing text into cells as normal but all the text is not visible, on the
last few lines it disappears off the sides of the cell depite the fact that I have checked "wrap text". Most of the lines are visible as the text automatically appears on the next line but there is about 15 lines of text and the last line of the text disappears off the side and is hidden under the adjacent cells. I have expanded the column and the line so the cell shows as big enough. If I click into the cell itself then all of the text shows correctly but as soon as I click in another cell the bottom of the text in the original cell disappears off the side. I hope I have made this question clear! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am not seeing all text in a cell despite wrap text
A single cell can only handle so many characters. You may want to try merging
two cells. Click on your coment cell and highlight to the cell to it's right. Format - Cells - Alignment and Check Merge. This should give you more room to view. "idkwia" wrote: I am typing text into cells as normal but all the text is not visible, on the last few lines it disappears off the sides of the cell depite the fact that I have checked "wrap text". Most of the lines are visible as the text automatically appears on the next line but there is about 15 lines of text and the last line of the text disappears off the side and is hidden under the adjacent cells. I have expanded the column and the line so the cell shows as big enough. If I click into the cell itself then all of the text shows correctly but as soon as I click in another cell the bottom of the text in the original cell disappears off the side. I hope I have made this question clear! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am not seeing all text in a cell despite wrap text
If you add alt-enters every 80-100 characters, I bet you can see those
characters that "drifted off". You may have to resize the rowheight manually, though. idkwia wrote: I am typing text into cells as normal but all the text is not visible, on the last few lines it disappears off the sides of the cell depite the fact that I have checked "wrap text". Most of the lines are visible as the text automatically appears on the next line but there is about 15 lines of text and the last line of the text disappears off the side and is hidden under the adjacent cells. I have expanded the column and the line so the cell shows as big enough. If I click into the cell itself then all of the text shows correctly but as soon as I click in another cell the bottom of the text in the original cell disappears off the side. I hope I have made this question clear! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can not see text in Excel when cell format is set to wrap text | New Users to Excel | |||
How do I view all text in a merged cell? Wrap text is activated. | Excel Discussion (Misc queries) | |||
Text cell w/wrap text shows # | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel |