excel wrap text no show

[Aline]

Hello,

Cells in Excel with wrap-text format checked do not appear as text
anymore, just a blank cell. Any new data entered with the wrap-text
format checked also show-up as blank. The cell is large enough and text
is in black. When deselecting the wrap text option, text appears again.
All my documents have this problem now and never had it in the past.
Does anyone have a solution?

Kind regards,
Aline

[Bryan Hessey]

If you wrap a cell and select that cell, in the formula bar do you see a number of blank lines following the display?

Do you see the required text in the formula bar?

--

Hello,

Cells in Excel with wrap-text format checked do not appear as text
anymore, just a blank cell. Any new data entered with the wrap-text
format checked also show-up as blank. The cell is large enough and text
is in black. When deselecting the wrap text option, text appears again.
All my documents have this problem now and never had it in the past.
Does anyone have a solution?

Kind regards,
Aline

[Aline]

Hi Bryan,

No blank lines, and yes, the text is visible in the formula bar.

Kind regards,
Aline

[Bryan Hessey]

Interesting, can you copy the sheet to a new book, remove all except a few such cells and post that either as a .zip file or email to me at myfullnameas [email protected]

--

Hi Bryan,

No blank lines, and yes, the text is visible in the formula bar.

Kind regards,
Aline

[Aline]

Hi Bryan,

I have just sent you an example file by e-mail, hopefully you can find
something.

Kind regards,
Aline

[Bryan Hessey]

Hi, email response included:

The file looks ok and I cannot get it to fault.

The only thing that looks out of place is that the first row is 'wrap text' but a very small amount of data, so no wrap is involved.

With row 1 = wrap, and the other rows not wrapped, if you now reduce the column size to 1 character wide you will not see any difference in the display, the cell will NOT wrap on column width adjustment, this appears normal. When you then rightmouse-Format the cell will height-adjust to allow for the depth required (but Excel is not that great at counting height and may make the row wider than required), reason unknown and it's no big deal.

suggested to remove the Excel11.xlb file from C:\Documents and Settings\-your name-\Application Data\Microsoft\Excel And let it re-generate with Excel defaults, also try
Go to the Windows Start menu, and choose Run.
Enter
Excel.exe /regserver

Also - check whether in Excel, Help - Detect and Repair the .xls might help.

You can also keep a note of which other workbooks you have had open during the day, to see if some left-over code from there has affected your setup.

Let me know how you go

Cheers

--

Hi Bryan,

I have just sent you an example file by e-mail, hopefully you can find
something.

Kind regards,
Aline