software

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
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?

--

Aline Wrote:
gt; Hello,
gt;
gt; Cells in Excel with wrap-text format checked do not appear as text
gt; anymore, just a blank cell. Any new data entered with the wrap-text
gt; format checked also show-up as blank. The cell is large enough and
gt; text
gt; is in black. When deselecting the wrap text option, text appears
gt; again.
gt; All my documents have this problem now and never had it in the past.
gt; Does anyone have a solution?
gt;
gt; Kind regards,
gt; Aline--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=534903Hi Bryan,

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

Kind regards,
Aline
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

--

Aline Wrote:
gt; Hi Bryan,
gt;
gt; No blank lines, and yes, the text is visible in the formula bar.
gt;
gt; Kind regards,
gt; Aline--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=534903Hi Bryan,

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

Kind regards,
Aline
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

--

Aline Wrote:
gt; Hi Bryan,
gt;
gt; I have just sent you an example file by e-mail, hopefully you can find
gt; something.
gt;
gt; Kind regards,
gt; Aline--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=534903