Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Wrap text not showing text
1 view
Skip to first unread message
Jtanberg
May 15, 2006, 12:30:02 PM5/15/06
to
Hello. I have a user here that on his machine only when you format a cell and
choose wrap text the text dissapears from the cell but still shows in the
formula bar. It is with every spreadsheet including if we open a blank one
and try it. I have been searching google and others have the same issue but
can't seem to find an answer. He is running office 2000 SP4 but I do not
think the version is related. He is a programmer and he messes with dll's all
the time so I have a feeling it has something to do with a shared dll. Here
are the things I have tried. Any help is appreciated.
choose wrap text the text dissapears from the cell but still shows in the
formula bar. It is with every spreadsheet including if we open a blank one
and try it. I have been searching google and others have the same issue but
can't seem to find an answer. He is running office 2000 SP4 but I do not
think the version is related. He is a programmer and he messes with dll's all
the time so I have a feeling it has something to do with a shared dll. Here
are the things I have tried. Any help is appreciated.
Tried removing the Excel.xlb file from C:\Documents and
Settings\-your name-\Application Data\Microsoft\Excel
Detect and Repair
Made sure the text is not white
Tried changing the cell to General just to make sure there is nothing strange
CLR
May 15, 2006, 1:30:02 PM5/15/06
to
Right-click > FormatCells > AlignmentTab > make sure the "Horizontal"
selection is set to "General"......
selection is set to "General"......
Vaya con Dios,
Chuck, CABGx3
Jtanberg
May 15, 2006, 2:48:02 PM5/15/06
to
Checked and it is set to General. Thank you for the suggestion and any others
still welcome.
still welcome.
Dave Peterson
May 15, 2006, 3:15:54 PM5/15/06
to
I bet you have lots of text in that cell.
Try adding alt-enters (to force a new line within the cell) every 80-100
characters. Then you'll be able to see more characters.
--
Dave Peterson
Jtanberg
May 15, 2006, 4:20:02 PM5/15/06
to
No sir not true. I open a blank spreadsheet and put anything in it like "The
dog ran around the block three times this week" even tried 3 words "The Boy
Ran" and it disappears. It is very strange. Thank you for the suggestion and
all others still welcome. Thank you
dog ran around the block three times this week" even tried 3 words "The Boy
Ran" and it disappears. It is very strange. Thank you for the suggestion and
all others still welcome. Thank you
Jtanberg
May 15, 2006, 4:24:02 PM5/15/06
to
No sir but thank you for the response. I can open a brand new spreadsheet and
put a few words in it or a whole sentence and get the same thing. No matter
what text is in any cell as soon as you format and wrap text it dissapears.
Very strange
put a few words in it or a whole sentence and get the same thing. No matter
what text is in any cell as soon as you format and wrap text it dissapears.
Very strange
Dave Peterson
May 15, 2006, 5:51:41 PM5/15/06
to
Did you format the cell to wraptext?
Format|cells|alignment tab
And did you autofit the row height?
--
Dave Peterson
Jtanberg
May 16, 2006, 8:01:02 AM5/16/06
to
When we originally type text in there it is not wrap text and we can see it.
When I format cell and choose wrap text it dissapears. If I remove the
checkbox for wrap text the text re appears. Tried autofit and the same thing
happens.
When I format cell and choose wrap text it dissapears. If I remove the
checkbox for wrap text the text re appears. Tried autofit and the same thing
happens.
Dave Peterson
May 16, 2006, 8:18:31 AM5/16/06
to
I don't have another guess.
--
Dave Peterson
Jtanberg
May 16, 2006, 10:11:03 AM5/16/06
to
Thanks for trying.
0 new messages