Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can not see text in Excel when cell format is set to wrap text Mark New Users to Excel 1 May 29th 07 02:07 PM
How do I view all text in a merged cell? Wrap text is activated. susjorg Excel Discussion (Misc queries) 1 January 23rd 07 07:34 PM
Text cell w/wrap text shows # DLFiumara Excel Discussion (Misc queries) 1 October 30th 06 11:36 PM
Text not continuing to wrap for large block of text in Excel cell Mandra Charts and Charting in Excel 1 May 15th 06 07:13 PM
How do I set text to top of cell next to wrap text in Excel? Carpenter Gary New Users to Excel 1 October 25th 05 06:26 PM


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"