View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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!