Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark_GS1CA
 
Posts: n/a
Default Text disappears when word wrap is used

I am haveing a problem with Excel.

Whenever word wrap is applied the text is not visable in the cell. It
remains visable only in the bar above.

I have already confirmed autofit and it reduces the column to 1 character
wide.

I tried detect and repair on the installation and nothing.

I even upgraded from Excel 2k to Excel 2003 and no change.

I would greatly appreciate help on this as it is really bugging me.


  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Mark,
Widen the column, to what you want then use autofit on the row(s)
not on the column. If you have merged cells involved you will have
to adjust the row height other than by autofit. Once you have manually
changed the row height you stuck with having to manually adjust
in future usage.


-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark_GS1CA" wrote in message ...
I am haveing a problem with Excel.

Whenever word wrap is applied the text is not visable in the cell. It
remains visable only in the bar above.

I have already confirmed autofit and it reduces the column to 1 character
wide.

I tried detect and repair on the installation and nothing.

I even upgraded from Excel 2k to Excel 2003 and no change.

I would greatly appreciate help on this as it is really bugging me.




  #3   Report Post  
Mark_GS1CA
 
Posts: n/a
Default

Hi David,

Thanks for your response. That was in fact the first thing I tried. There
are no merged cells on the sheet.

I start with a completly blank sheet, I enter any amount of text and the
instant I apply word wrap to eith ther the cell or the column ( I have tried
both seperatly) the text disappears from the screen.

Thanks again

"David McRitchie" wrote:

Hi Mark,
Widen the column, to what you want then use autofit on the row(s)
not on the column. If you have merged cells involved you will have
to adjust the row height other than by autofit. Once you have manually
changed the row height you stuck with having to manually adjust
in future usage.


-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark_GS1CA" wrote in message ...
I am haveing a problem with Excel.

Whenever word wrap is applied the text is not visable in the cell. It
remains visable only in the bar above.

I have already confirmed autofit and it reduces the column to 1 character
wide.

I tried detect and repair on the installation and nothing.

I even upgraded from Excel 2k to Excel 2003 and no change.

I would greatly appreciate help on this as it is really bugging me.





  #4   Report Post  
Dave Peterson
 
Posts: n/a
Default

Just some nutty things to discount...

What is the numberformat for the cell?
Try changing it to General.
(format|cells|Number tab)

When you say the text disappears, does the cell look empty or what?



Mark_GS1CA wrote:

Hi David,

Thanks for your response. That was in fact the first thing I tried. There
are no merged cells on the sheet.

I start with a completly blank sheet, I enter any amount of text and the
instant I apply word wrap to eith ther the cell or the column ( I have tried
both seperatly) the text disappears from the screen.

Thanks again

"David McRitchie" wrote:

Hi Mark,
Widen the column, to what you want then use autofit on the row(s)
not on the column. If you have merged cells involved you will have
to adjust the row height other than by autofit. Once you have manually
changed the row height you stuck with having to manually adjust
in future usage.


-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark_GS1CA" wrote in message ...
I am haveing a problem with Excel.

Whenever word wrap is applied the text is not visable in the cell. It
remains visable only in the bar above.

I have already confirmed autofit and it reduces the column to 1 character
wide.

I tried detect and repair on the installation and nothing.

I even upgraded from Excel 2k to Excel 2003 and no change.

I would greatly appreciate help on this as it is really bugging me.






--

Dave Peterson
  #5   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Mark,
Check that the formatting is still General and not something that would
suppress display like all semicolons

Make sure that there is not Conditional Formatting in Effect
if you don't see any, make sure
select all cells (ctrl+shift+spacebar even in Excel 2003)
format, Conditional Format, delete button , check all three and delete

Make sure that the font is still black for automatic

Try opening in "Safe Mode" which disables macros and add-ins.
http://www.mvps.org/dmcritchie/excel/slowresp.htm

I can't find anything in web searches to match your problem, well actually
I trying to specifically look for Excel 2003.

What version of Excel do you have.

Try clearing out your temporary internet file (from Internet Explorer), are
you short on disk space.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark_GS1CA" wrote in message ...
Hi David,

Thanks for your response. That was in fact the first thing I tried. There
are no merged cells on the sheet.

I start with a completly blank sheet, I enter any amount of text and the
instant I apply word wrap to eith ther the cell or the column ( I have tried
both seperatly) the text disappears from the screen.

Thanks again

"David McRitchie" wrote:

Hi Mark,
Widen the column, to what you want then use autofit on the row(s)
not on the column. If you have merged cells involved you will have
to adjust the row height other than by autofit. Once you have manually
changed the row height you stuck with having to manually adjust
in future usage.


-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark_GS1CA" wrote in message ...
I am haveing a problem with Excel.

Whenever word wrap is applied the text is not visable in the cell. It
remains visable only in the bar above.

I have already confirmed autofit and it reduces the column to 1 character
wide.

I tried detect and repair on the installation and nothing.

I even upgraded from Excel 2k to Excel 2003 and no change.

I would greatly appreciate help on this as it is really bugging me.









  #6   Report Post  
Mark_GS1CA
 
Posts: n/a
Default

Hi David

Thanks for your time in replying.

I am using Excel 2003 SP1 on XP Pro SP2

I open a brand new work sheet in safe mode
I type a line in a cell
I right click cell: format: alignment: click word wrap annd...
poof the text in the cell disappears

I too have never seen the like, however this problem persists even after a
reinstall of Office.

I guess I will have to try a repair on the OS and hope that its a shared dll
somewhere thats corrupted.

Thanks,




"David McRitchie" wrote:

Hi Mark,
Check that the formatting is still General and not something that would
suppress display like all semicolons

Make sure that there is not Conditional Formatting in Effect
if you don't see any, make sure
select all cells (ctrl+shift+spacebar even in Excel 2003)
format, Conditional Format, delete button , check all three and delete

Make sure that the font is still black for automatic

Try opening in "Safe Mode" which disables macros and add-ins.
http://www.mvps.org/dmcritchie/excel/slowresp.htm

I can't find anything in web searches to match your problem, well actually
I trying to specifically look for Excel 2003.

What version of Excel do you have.

Try clearing out your temporary internet file (from Internet Explorer), are
you short on disk space.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark_GS1CA" wrote in message ...
Hi David,

Thanks for your response. That was in fact the first thing I tried. There
are no merged cells on the sheet.

I start with a completly blank sheet, I enter any amount of text and the
instant I apply word wrap to eith ther the cell or the column ( I have tried
both seperatly) the text disappears from the screen.

Thanks again

"David McRitchie" wrote:

Hi Mark,
Widen the column, to what you want then use autofit on the row(s)
not on the column. If you have merged cells involved you will have
to adjust the row height other than by autofit. Once you have manually
changed the row height you stuck with having to manually adjust
in future usage.


-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark_GS1CA" wrote in message ...
I am haveing a problem with Excel.

Whenever word wrap is applied the text is not visable in the cell. It
remains visable only in the bar above.

I have already confirmed autofit and it reduces the column to 1 character
wide.

I tried detect and repair on the installation and nothing.

I even upgraded from Excel 2k to Excel 2003 and no change.

I would greatly appreciate help on this as it is really bugging me.








  #7   Report Post  
Daniel Felkins
 
Posts: n/a
Default Text disappears when word wrap is used

Was anyone ever able to solve this issue? I am having the exact same
problem. I can't find anything on it in the MS KB.

"Mark_GS1CA" wrote:

Hi David

Thanks for your time in replying.

I am using Excel 2003 SP1 on XP Pro SP2

I open a brand new work sheet in safe mode
I type a line in a cell
I right click cell: format: alignment: click word wrap annd...
poof the text in the cell disappears

I too have never seen the like, however this problem persists even after a
reinstall of Office.

I guess I will have to try a repair on the OS and hope that its a shared dll
somewhere thats corrupted.

Thanks,




"David McRitchie" wrote:

Hi Mark,
Check that the formatting is still General and not something that would
suppress display like all semicolons

Make sure that there is not Conditional Formatting in Effect
if you don't see any, make sure
select all cells (ctrl+shift+spacebar even in Excel 2003)
format, Conditional Format, delete button , check all three and delete

Make sure that the font is still black for automatic

Try opening in "Safe Mode" which disables macros and add-ins.
http://www.mvps.org/dmcritchie/excel/slowresp.htm

I can't find anything in web searches to match your problem, well actually
I trying to specifically look for Excel 2003.

What version of Excel do you have.

Try clearing out your temporary internet file (from Internet Explorer), are
you short on disk space.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark_GS1CA" wrote in message ...
Hi David,

Thanks for your response. That was in fact the first thing I tried. There
are no merged cells on the sheet.

I start with a completly blank sheet, I enter any amount of text and the
instant I apply word wrap to eith ther the cell or the column ( I have tried
both seperatly) the text disappears from the screen.

Thanks again

"David McRitchie" wrote:

Hi Mark,
Widen the column, to what you want then use autofit on the row(s)
not on the column. If you have merged cells involved you will have
to adjust the row height other than by autofit. Once you have manually
changed the row height you stuck with having to manually adjust
in future usage.


-
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mark_GS1CA" wrote in message ...
I am haveing a problem with Excel.

Whenever word wrap is applied the text is not visable in the cell. It
remains visable only in the bar above.

I have already confirmed autofit and it reduces the column to 1 character
wide.

I tried detect and repair on the installation and nothing.

I even upgraded from Excel 2k to Excel 2003 and no change.

I would greatly appreciate help on this as it is really bugging me.








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
Wrap Text anukrish17 Excel Discussion (Misc queries) 3 July 6th 05 08:02 PM
Wrap Text from one cell to another cell bras Excel Discussion (Misc queries) 2 June 23rd 05 02:07 AM
Why doesn't text wrap in a cell in Excel? rohrbaught Excel Discussion (Misc queries) 6 April 8th 05 06:13 PM
Problem with wrap text format Mitch Excel Worksheet Functions 1 January 20th 05 09:46 AM
In Excel, using line wrap with text, some cells will appear as ##. RSCoyner Excel Discussion (Misc queries) 4 January 19th 05 11:21 PM


All times are GMT +1. The time now is 10:35 AM.

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

About Us

"It's about Microsoft Excel"