Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
DaveT
 
Posts: n/a
Default wrap text function causes data to disappear in cell (visually only

When I use the wrap text option for a cell, the data in the cell is no longer
viewable when I move to another cell but is clearly still there when the cell
is activated again. The data string can be any length so exceeding the
maximum number of characters in not the problem. When I double click in the
cell or click in the formula area the data reappears in the cell. Any idea
what might be causing this?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Hanr3
 
Posts: n/a
Default wrap text function causes data to disappear in cell (visually only

Did you format the row height to automatic?
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"DaveT" wrote:

When I use the wrap text option for a cell, the data in the cell is no longer
viewable when I move to another cell but is clearly still there when the cell
is activated again. The data string can be any length so exceeding the
maximum number of characters in not the problem. When I double click in the
cell or click in the formula area the data reappears in the cell. Any idea
what might be causing this?

  #3   Report Post  
Posted to microsoft.public.excel.misc
DaveT
 
Posts: n/a
Default wrap text function causes data to disappear in cell (visually

Yes it is set to automatic. The file works fine on other computers so it is
definitley a setting issue on my computer. I just don't know which setting
is causing it. It is a new computer so it may be an issue caused by initial
set-up. It has to be something simple...

"Hanr3" wrote:

Did you format the row height to automatic?
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"DaveT" wrote:

When I use the wrap text option for a cell, the data in the cell is no longer
viewable when I move to another cell but is clearly still there when the cell
is activated again. The data string can be any length so exceeding the
maximum number of characters in not the problem. When I double click in the
cell or click in the formula area the data reappears in the cell. Any idea
what might be causing this?

  #4   Report Post  
Posted to microsoft.public.excel.misc
Chris
 
Posts: n/a
Default wrap text function causes data to disappear in cell (visually

I am having this problem as well. Whenever word wrap is enabled on a
cell, the text is not visible in the cell. If I select the cell, the
text is visible in the formula bar. It is also visible in Print
Preview. The issue is not related to cell width or height... it occurs
even with a small entry in the cell. The text color is not white on a
white background. So it is something else on this PC. The same file
works fine on another PC. Any help would be appreciated.

  #5   Report Post  
Posted to microsoft.public.excel.misc
Hanr3
 
Posts: n/a
Default wrap text function causes data to disappear in cell (visually

Check to make sure the data from an adjoining cell isn't hidding this cell.
Easiest way is to auto adjust the column wideth of the surrounding
coumns/rows. Also make sure the date isn't centered in the cell.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Chris" wrote:

I am having this problem as well. Whenever word wrap is enabled on a
cell, the text is not visible in the cell. If I select the cell, the
text is visible in the formula bar. It is also visible in Print
Preview. The issue is not related to cell width or height... it occurs
even with a small entry in the cell. The text color is not white on a
white background. So it is something else on this PC. The same file
works fine on another PC. Any help would be appreciated.




  #6   Report Post  
Posted to microsoft.public.excel.misc
HFB
 
Posts: n/a
Default wrap text function causes data to disappear in cell (visually

I also had this issue in Excel 2003 and XP. I do not know enough about
Excel to know why this worked, but I solved it by having Excel
re-register with the OS. This can be done by going to the "Run..."
command in the start menu and typing the following:

Excel /o

Be sure to close Excel before running this command. This evidently
re-registers Excel and fixes the bad value. I hope this helps, it took
me a long time to figure it out, and an Excel expert finally helped me
clear it up!

- Jason

Hanr3 wrote:
Check to make sure the data from an adjoining cell isn't hidding this cell.
Easiest way is to auto adjust the column wideth of the surrounding
coumns/rows. Also make sure the date isn't centered in the cell.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Chris" wrote:

I am having this problem as well. Whenever word wrap is enabled on a
cell, the text is not visible in the cell. If I select the cell, the
text is visible in the formula bar. It is also visible in Print
Preview. The issue is not related to cell width or height... it occurs
even with a small entry in the cell. The text color is not white on a
white background. So it is something else on this PC. The same file
works fine on another PC. Any help would be appreciated.



  #7   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default wrap text function causes data to disappear in cell (visually

I also have this issue. The main differences are that I'm using Excel
2000, and XP. It's on a laptop using dual monitors, but switching
monitors doesn't help.

I've tried the instructions below (Excel /o) and it does not fix my
problem.

Lakin

HFB wrote:
I also had this issue in Excel 2003 and XP. I do not know enough about
Excel to know why this worked, but I solved it by having Excel
re-register with the OS. This can be done by going to the "Run..."
command in the start menu and typing the following:

Excel /o

Be sure to close Excel before running this command. This evidently
re-registers Excel and fixes the bad value. I hope this helps, it took
me a long time to figure it out, and an Excel expert finally helped me
clear it up!

- Jason

Hanr3 wrote:
Check to make sure the data from an adjoining cell isn't hidding this cell.
Easiest way is to auto adjust the column wideth of the surrounding
coumns/rows. Also make sure the date isn't centered in the cell.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Chris" wrote:

I am having this problem as well. Whenever word wrap is enabled on a
cell, the text is not visible in the cell. If I select the cell, the
text is visible in the formula bar. It is also visible in Print
Preview. The issue is not related to cell width or height... it occurs
even with a small entry in the cell. The text color is not white on a
white background. So it is something else on this PC. The same file
works fine on another PC. Any help would be appreciated.



  #8   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default wrap text function causes data to disappear in cell (visually

I found a workaround. The laptop that I'm using has an external
monitor hooked up to it. Whenever this starts to happen, if I open the
display settings and disable one of the monitors, then click apply, it
starts to work. The odd thing is that I can then re-enable the monitor
and it still works.

It's been working since then, and I can no longer reproduce the
problem. I assume that the problem will crop up again eventually.

I hope this helps some of you deal with the problem, and maybe this
will help us track down the true cause.

Lakin


wrote:
I also have this issue. The main differences are that I'm using Excel
2000, and XP. It's on a laptop using dual monitors, but switching
monitors doesn't help.

I've tried the instructions below (Excel /o) and it does not fix my
problem.

Lakin

HFB wrote:
I also had this issue in Excel 2003 and XP. I do not know enough about
Excel to know why this worked, but I solved it by having Excel
re-register with the OS. This can be done by going to the "Run..."
command in the start menu and typing the following:

Excel /o

Be sure to close Excel before running this command. This evidently
re-registers Excel and fixes the bad value. I hope this helps, it took
me a long time to figure it out, and an Excel expert finally helped me
clear it up!

- Jason

Hanr3 wrote:
Check to make sure the data from an adjoining cell isn't hidding this cell.
Easiest way is to auto adjust the column wideth of the surrounding
coumns/rows. Also make sure the date isn't centered in the cell.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Chris" wrote:

I am having this problem as well. Whenever word wrap is enabled on a
cell, the text is not visible in the cell. If I select the cell, the
text is visible in the formula bar. It is also visible in Print
Preview. The issue is not related to cell width or height... it occurs
even with a small entry in the cell. The text color is not white on a
white background. So it is something else on this PC. The same file
works fine on another PC. Any help would be appreciated.



  #9   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default wrap text function causes data to disappear in cell (visually

Thank you! Thank you!

This issue was causing me great grief, but the Excel /o did the trick


HFB wrote:
I also had this issue in Excel 2003 and XP. I do not know enough about
Excel to know why this worked, but I solved it by having Excel
re-register with the OS. This can be done by going to the "Run..."
command in the start menu and typing the following:

Excel /o

Be sure to close Excel before running this command. This evidently
re-registers Excel and fixes the bad value. I hope this helps, it took
me a long time to figure it out, and an Excel expert finally helped me
clear it up!

- Jason

Hanr3 wrote:
Check to make sure the data from an adjoining cell isn't hidding this cell.
Easiest way is to auto adjust the column wideth of the surrounding
coumns/rows. Also make sure the date isn't centered in the cell.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Chris" wrote:

I am having this problem as well. Whenever word wrap is enabled on a
cell, the text is not visible in the cell. If I select the cell, the
text is visible in the formula bar. It is also visible in Print
Preview. The issue is not related to cell width or height... it occurs
even with a small entry in the cell. The text color is not white on a
white background. So it is something else on this PC. The same file
works fine on another PC. Any help would be appreciated.



  #10   Report Post  
Posted to microsoft.public.excel.misc
Garth
 
Posts: n/a
Default wrap text function causes data to disappear in cell (visually

Thank you Lakin! This workaround solved my issue. Must be an issue when you
expand your desktop to multiple monitors. I did notice this morning when I
booted up today after docking my laptop, my Windows login screen was showing
on my external monitor instead of my laptop display (where it usually shows).
After that I experienced this text wrapping issue. As soon as I stopped
expanding my desktop, and then re-enabled it, the problem went away.

It's the typical Windows fix, isn't it? Turn something off, and then turn it
on again to get the fixed result. I remember reading something about
repeating actions and the definition of insanity that closely resembles this
behavior... !

" wrote:

I found a workaround. The laptop that I'm using has an external
monitor hooked up to it. Whenever this starts to happen, if I open the
display settings and disable one of the monitors, then click apply, it
starts to work. The odd thing is that I can then re-enable the monitor
and it still works.

It's been working since then, and I can no longer reproduce the
problem. I assume that the problem will crop up again eventually.

I hope this helps some of you deal with the problem, and maybe this
will help us track down the true cause.

Lakin


wrote:
I also have this issue. The main differences are that I'm using Excel
2000, and XP. It's on a laptop using dual monitors, but switching
monitors doesn't help.

I've tried the instructions below (Excel /o) and it does not fix my
problem.

Lakin

HFB wrote:
I also had this issue in Excel 2003 and XP. I do not know enough about
Excel to know why this worked, but I solved it by having Excel
re-register with the OS. This can be done by going to the "Run..."
command in the start menu and typing the following:

Excel /o

Be sure to close Excel before running this command. This evidently
re-registers Excel and fixes the bad value. I hope this helps, it took
me a long time to figure it out, and an Excel expert finally helped me
clear it up!

- Jason

Hanr3 wrote:
Check to make sure the data from an adjoining cell isn't hidding this cell.
Easiest way is to auto adjust the column wideth of the surrounding
coumns/rows. Also make sure the date isn't centered in the cell.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Chris" wrote:

I am having this problem as well. Whenever word wrap is enabled on a
cell, the text is not visible in the cell. If I select the cell, the
text is visible in the formula bar. It is also visible in Print
Preview. The issue is not related to cell width or height... it occurs
even with a small entry in the cell. The text color is not white on a
white background. So it is something else on this PC. The same file
works fine on another PC. Any help would be appreciated.






  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default wrap text function causes data to disappear in cell (visually

Thanks Lakin! My situation was identical to Garth's with the multiple
monitors, the login screen being on the second monitor after I docked
my laptop, and the text wrap issue. I tried all the various Run
commands, but the only thing that fixed it was disabling & re-enabling
my second monitor. What an odd problem! At least the workaround is
pretty simple.


Garth wrote:
Thank you Lakin! This workaround solved my issue. Must be an issue when you
expand your desktop to multiple monitors. I did notice this morning when I
booted up today after docking my laptop, my Windows login screen was showing
on my external monitor instead of my laptop display (where it usually shows).
After that I experienced this text wrapping issue. As soon as I stopped
expanding my desktop, and then re-enabled it, the problem went away.

It's the typical Windows fix, isn't it? Turn something off, and then turn it
on again to get the fixed result. I remember reading something about
repeating actions and the definition of insanity that closely resembles this
behavior... !

" wrote:

I found a workaround. The laptop that I'm using has an external
monitor hooked up to it. Whenever this starts to happen, if I open the
display settings and disable one of the monitors, then click apply, it
starts to work. The odd thing is that I can then re-enable the monitor
and it still works.

It's been working since then, and I can no longer reproduce the
problem. I assume that the problem will crop up again eventually.

I hope this helps some of you deal with the problem, and maybe this
will help us track down the true cause.

Lakin


wrote:
I also have this issue. The main differences are that I'm using Excel
2000, and XP. It's on a laptop using dual monitors, but switching
monitors doesn't help.

I've tried the instructions below (Excel /o) and it does not fix my
problem.

Lakin

HFB wrote:
I also had this issue in Excel 2003 and XP. I do not know enough about
Excel to know why this worked, but I solved it by having Excel
re-register with the OS. This can be done by going to the "Run..."
command in the start menu and typing the following:

Excel /o

Be sure to close Excel before running this command. This evidently
re-registers Excel and fixes the bad value. I hope this helps, it took
me a long time to figure it out, and an Excel expert finally helped me
clear it up!

- Jason

Hanr3 wrote:
Check to make sure the data from an adjoining cell isn't hidding this cell.
Easiest way is to auto adjust the column wideth of the surrounding
coumns/rows. Also make sure the date isn't centered in the cell.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Chris" wrote:

I am having this problem as well. Whenever word wrap is enabled on a
cell, the text is not visible in the cell. If I select the cell, the
text is visible in the formula bar. It is also visible in Print
Preview. The issue is not related to cell width or height... it occurs
even with a small entry in the cell. The text color is not white on a
white background. So it is something else on this PC. The same file
works fine on another PC. Any help would be appreciated.





  #12   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default wrap text function causes data to disappear in cell (visually

I'm encountering this problem too, but none of the suggestions elsewhere in
this old-but-long thread helped. I'm not convinced it is even related to the
wrap text function, though that was one of the first things I checked.

Not sure if it will help, but... I'm seeing it in several forms. One is that
all of the text in the cell becomes a single line of XXXXs when I leave the
cell. The original text spans several lines, and it reappears when the cell
is selected. In the other form, only the last part of the data disappears
(but completely) when I leave the cell. I pasted that data into a new cell,
just to see what happens, and the new copy also disappears when I leave its
cell.

Anyone else have new ideas? But for now, I'm off to search for new candidate
threads...

wrote:
Thanks Lakin! My situation was identical to Garth's with the multiple
monitors, the login screen being on the second monitor after I docked
my laptop, and the text wrap issue. I tried all the various Run
commands, but the only thing that fixed it was disabling & re-enabling
my second monitor. What an odd problem! At least the workaround is
pretty simple.


Garth wrote:
Thank you Lakin! This workaround solved my issue. Must be an issue
when you expand your desktop to multiple monitors. I did notice this
morning when I booted up today after docking my laptop, my Windows
login screen was showing on my external monitor instead of my laptop
display (where it usually shows). After that I experienced this text
wrapping issue. As soon as I stopped expanding my desktop, and then
re-enabled it, the problem went away.

It's the typical Windows fix, isn't it? Turn something off, and then
turn it on again to get the fixed result. I remember reading
something about repeating actions and the definition of insanity
that closely resembles this behavior... !

" wrote:

I found a workaround. The laptop that I'm using has an external
monitor hooked up to it. Whenever this starts to happen, if I open
the display settings and disable one of the monitors, then click
apply, it starts to work. The odd thing is that I can then
re-enable the monitor and it still works.

It's been working since then, and I can no longer reproduce the
problem. I assume that the problem will crop up again eventually.

I hope this helps some of you deal with the problem, and maybe this
will help us track down the true cause.

Lakin


wrote:
I also have this issue. The main differences are that I'm using
Excel 2000, and XP. It's on a laptop using dual monitors, but
switching monitors doesn't help.

I've tried the instructions below (Excel /o) and it does not fix my
problem.

Lakin

HFB wrote:
I also had this issue in Excel 2003 and XP. I do not know enough
about Excel to know why this worked, but I solved it by having
Excel re-register with the OS. This can be done by going to the
"Run..." command in the start menu and typing the following:

Excel /o

Be sure to close Excel before running this command. This
evidently re-registers Excel and fixes the bad value. I hope
this helps, it took me a long time to figure it out, and an Excel
expert finally helped me clear it up!

- Jason

Hanr3 wrote:
Check to make sure the data from an adjoining cell isn't hiding
this cell. Easiest way is to auto adjust the column width of
the surrounding columns/rows. Also make sure the date isn't
centered in the cell. --
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if
they are wrong.


"Chris" wrote:

I am having this problem as well. Whenever word wrap is
enabled on a cell, the text is not visible in the cell. If I
select the cell, the text is visible in the formula bar. It is
also visible in Print Preview. The issue is not related to
cell width or height... it occurs even with a small entry in
the cell. The text color is not white on a white background.
So it is something else on this PC. The same file works fine
on another PC. Any help would be appreciated.


  #13   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default wrap text function causes data to disappear in cell (visually

I found this happens more often when using a laptop with dual monitors
with one monitor using the analog cable port (blue port VGA) and the
other using the digital cable port (white port Digital). What I
discoverd is that it is related to the Analog Video card not being set
at the primary. Make sure the Analog monitor is on the left and the
Digital Monitor is on the Right. In addition in the Display Properties
| Settings Tab | Advanced - Under Display's or Monitor and Digital
Display - set the Analog monitor as the Primary Device and the Extended
Desktop or Seconday Device as the Digital Display.

Techie68
AOS CST, A+, Network+


Shannon Jacobs wrote:
I'm encountering this problem too, but none of the suggestions elsewhere in
this old-but-long thread helped. I'm not convinced it is even related to the
wrap text function, though that was one of the first things I checked.

Not sure if it will help, but... I'm seeing it in several forms. One is that
all of the text in the cell becomes a single line of XXXXs when I leave the
cell. The original text spans several lines, and it reappears when the cell
is selected. In the other form, only the last part of the data disappears
(but completely) when I leave the cell. I pasted that data into a new cell,
just to see what happens, and the new copy also disappears when I leave its
cell.

Anyone else have new ideas? But for now, I'm off to search for new candidate
threads...

wrote:
Thanks Lakin! My situation was identical to Garth's with the multiple
monitors, the login screen being on the second monitor after I docked
my laptop, and the text wrap issue. I tried all the various Run
commands, but the only thing that fixed it was disabling & re-enabling
my second monitor. What an odd problem! At least the workaround is
pretty simple.


Garth wrote:
Thank you Lakin! This workaround solved my issue. Must be an issue
when you expand your desktop to multiple monitors. I did notice this
morning when I booted up today after docking my laptop, my Windows
login screen was showing on my external monitor instead of my laptop
display (where it usually shows). After that I experienced this text
wrapping issue. As soon as I stopped expanding my desktop, and then
re-enabled it, the problem went away.

It's the typical Windows fix, isn't it? Turn something off, and then
turn it on again to get the fixed result. I remember reading
something about repeating actions and the definition of insanity
that closely resembles this behavior... !

" wrote:

I found a workaround. The laptop that I'm using has an external
monitor hooked up to it. Whenever this starts to happen, if I open
the display settings and disable one of the monitors, then click
apply, it starts to work. The odd thing is that I can then
re-enable the monitor and it still works.

It's been working since then, and I can no longer reproduce the
problem. I assume that the problem will crop up again eventually.

I hope this helps some of you deal with the problem, and maybe this
will help us track down the true cause.

Lakin


wrote:
I also have this issue. The main differences are that I'm using
Excel 2000, and XP. It's on a laptop using dual monitors, but
switching monitors doesn't help.

I've tried the instructions below (Excel /o) and it does not fix my
problem.

Lakin

HFB wrote:
I also had this issue in Excel 2003 and XP. I do not know enough
about Excel to know why this worked, but I solved it by having
Excel re-register with the OS. This can be done by going to the
"Run..." command in the start menu and typing the following:

Excel /o

Be sure to close Excel before running this command. This
evidently re-registers Excel and fixes the bad value. I hope
this helps, it took me a long time to figure it out, and an Excel
expert finally helped me clear it up!

- Jason

Hanr3 wrote:
Check to make sure the data from an adjoining cell isn't hiding
this cell. Easiest way is to auto adjust the column width of
the surrounding columns/rows. Also make sure the date isn't
centered in the cell. --
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if
they are wrong.


"Chris" wrote:

I am having this problem as well. Whenever word wrap is
enabled on a cell, the text is not visible in the cell. If I
select the cell, the text is visible in the formula bar. It is
also visible in Print Preview. The issue is not related to
cell width or height... it occurs even with a small entry in
the cell. The text color is not white on a white background.
So it is something else on this PC. The same file works fine
on another PC. Any help would be appreciated.


  #14   Report Post  
Posted to microsoft.public.excel.misc
LC LC is offline
external usenet poster
 
Posts: 8
Default wrap text function causes data to disappear in cell (visually

Thank you! Thank you! Thank you!

This issue was causing me great grief as well for a long time now.
The "Excel /o" trick did not work but the external monitor solution for
multiple monitors trick cleared it.

Thank you Lakin,
LC
================================================== ===
" wrote:

I found a workaround. The laptop that I'm using has an external
monitor hooked up to it. Whenever this starts to happen, if I open the
display settings and disable one of the monitors, then click apply, it
starts to work. The odd thing is that I can then re-enable the monitor
and it still works.

It's been working since then, and I can no longer reproduce the
problem. I assume that the problem will crop up again eventually.

I hope this helps some of you deal with the problem, and maybe this
will help us track down the true cause.

Lakin


wrote:
I also have this issue. The main differences are that I'm using Excel
2000, and XP. It's on a laptop using dual monitors, but switching
monitors doesn't help.

I've tried the instructions below (Excel /o) and it does not fix my
problem.

Lakin

HFB wrote:
I also had this issue in Excel 2003 and XP. I do not know enough about
Excel to know why this worked, but I solved it by having Excel
re-register with the OS. This can be done by going to the "Run..."
command in the start menu and typing the following:

Excel /o

Be sure to close Excel before running this command. This evidently
re-registers Excel and fixes the bad value. I hope this helps, it took
me a long time to figure it out, and an Excel expert finally helped me
clear it up!

- Jason

Hanr3 wrote:
Check to make sure the data from an adjoining cell isn't hidding this cell.
Easiest way is to auto adjust the column wideth of the surrounding
coumns/rows. Also make sure the date isn't centered in the cell.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


"Chris" wrote:

I am having this problem as well. Whenever word wrap is enabled on a
cell, the text is not visible in the cell. If I select the cell, the
text is visible in the formula bar. It is also visible in Print
Preview. The issue is not related to cell width or height... it occurs
even with a small entry in the cell. The text color is not white on a
white background. So it is something else on this PC. The same file
works fine on another PC. Any help would be appreciated.




  #15   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default wrap text function causes data to disappear in cell (visually

THANK YOU LAKIN!!!

I'm so glad your post is still here 6 years later (March 2013).
I have Excel 2010 and was having the same problem as everyone else on this thread. I tried Excel /o...didn't work :(/

Then tried your method. Turned off my desktop on the 2nd monitor, opened Excel to see it work correctly. I then extended my desktop back onto the 2nd monitor and Excel is still handling the word wrap and auto size correctly.

Wow...I spent over an hour surfing the net for a solution. Found nothing till I came here. Thought I was going crazy...Microsoft crazy.

Who knew that dual monitors screwed up the wrap/auto-adjust in Excel?

Lakin did.

;0)


-----------------------------------------------------------------
-----------------------------------------------------------------

On Wednesday, June 7, 2006 3:05:19 PM UTC-5, wrote:
I also have this issue. The main differences are that I'm using Excel
2000, and XP. It's on a laptop using dual monitors, but switching
monitors doesn't help.

I've tried the instructions below (Excel /o) and it does not fix my
problem.

Lakin




  #16   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default wrap text function causes data to disappear in cell (visually only

уторак, 09. мај 2006. 19.14.02 UTC+2, DaveT је написао/ла:
When I use the wrap text option for a cell, the data in the cell is no longer
viewable when I move to another cell but is clearly still there when the cell
is activated again. The data string can be any length so exceeding the
maximum number of characters in not the problem. When I double click in the
cell or click in the formula area the data reappears in the cell. Any idea
what might be causing this?


Тхe only option is to wrap text transfer in word and print
  #17   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default wrap text function causes data to disappear in cell (visually

On Wednesday, 6 March 2013 03:06:20 UTC+2, wrote:
THANK YOU LAKIN!!!

I'm so glad your post is still here 6 years later (March 2013).
I have Excel 2010 and was having the same problem as everyone else on this thread. I tried Excel /o...didn't work :(/

Then tried your method. Turned off my desktop on the 2nd monitor, opened Excel to see it work correctly. I then extended my desktop back onto the 2nd monitor and Excel is still handling the word wrap and auto size correctly.

Wow...I spent over an hour surfing the net for a solution. Found nothing till I came here. Thought I was going crazy...Microsoft crazy.

Who knew that dual monitors screwed up the wrap/auto-adjust in Excel?

Lakin did.

;0)


-----------------------------------------------------------------
-----------------------------------------------------------------

On Wednesday, June 7, 2006 3:05:19 PM UTC-5, wrote:
I also have this issue. The main differences are that I'm using Excel
2000, and XP. It's on a laptop using dual monitors, but switching
monitors doesn't help.

I've tried the instructions below (Excel /o) and it does not fix my
problem.

Lakin


2015 - Hidden Text on excel: i am super super grateful to Lakin. disabling the extra screen completely and working on my Laptop only. and not disconnecting BUT disabling the monitor worked wonders. I was so frustrated for the whole 2 hours searching the NET like crazy
  #18   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default wrap text function causes data to disappear in cell (visually

On Tuesday, November 3, 2015 at 11:20:42 AM UTC, wrote:
On Wednesday, 6 March 2013 03:06:20 UTC+2, wrote:
THANK YOU LAKIN!!!

I'm so glad your post is still here 6 years later (March 2013).
I have Excel 2010 and was having the same problem as everyone else on this thread. I tried Excel /o...didn't work :(/

Then tried your method. Turned off my desktop on the 2nd monitor, opened Excel to see it work correctly. I then extended my desktop back onto the 2nd monitor and Excel is still handling the word wrap and auto size correctly.

Wow...I spent over an hour surfing the net for a solution. Found nothing till I came here. Thought I was going crazy...Microsoft crazy.

Who knew that dual monitors screwed up the wrap/auto-adjust in Excel?

Lakin did.

;0)


-----------------------------------------------------------------
-----------------------------------------------------------------

On Wednesday, June 7, 2006 3:05:19 PM UTC-5, wrote:
I also have this issue. The main differences are that I'm using Excel
2000, and XP. It's on a laptop using dual monitors, but switching
monitors doesn't help.

I've tried the instructions below (Excel /o) and it does not fix my
problem.

Lakin


2015 - Hidden Text on excel: i am super super grateful to Lakin. disabling the extra screen completely and working on my Laptop only. and not disconnecting BUT disabling the monitor worked wonders. I was so frustrated for the whole 2 hours searching the NET like crazy


Well, it's 2017 and I'm having the same problem but can't resolve it using the start menu because Apple doesn't seem to have the same menu as microsoft. I'm using Office for Mac 2011.
However, what is doubly confusing is that this is only happening with one lot of text from a Word document. I have successfully copied and pasted (and wrapped) text from other word documents on to the same Excel spreadsheet - in adjoining cells.
A possibility is this: The original Word document was completed using assistive software (Dragon) and I received it as an Email attachment. I added text to the document (in the midst of the existing text) using straightforward typing on my Mac. I have copied and pasted the required text (the ordinary typing) onto another Word document and altered the formatting just to remove new paragraph (enter) characters. It is this text that disappears when I try to use wrap in Excel. I've tried 'paste special' and that doesn't work.
Could the assistive software be responsible for having some hidden influence?

I have just resorted to typing the whole of the affected text into the cell (and then the formula bar as I'd clicked off the cell briefly). At first it continued doing the same thing so I copied it from the formular bar and pasted it into a different cell in the same spreadsheet. The text wrapping worked! I deleted the part of the column that the affected cell was in and then cut the cell that worked and pasted it. It now seems to be behaving properly!

I also tried typing some rubbish at the end of the Word document after the text written with Dragon (instead of in the middle of it) and copying and pasting that into Excel. That worked fine.

Therefore, I suspect that there is some mysterious formatting software that accompanied my text into Excel and corrupted that particular cell. (I'd obviously tried using different cells before but using the affected text).

Maybe some of the questioners on this thread had got text that had used some other means than straight typing to write it?
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
Why am I getting XXX error in text cell with word wrap turned on? HMF Excel Discussion (Misc queries) 2 March 16th 06 01:44 AM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Formulas dealing with text data Bagia Excel Worksheet Functions 6 June 20th 05 10:29 PM
####### within a wrap text cell. OrlandoJayHu Excel Discussion (Misc queries) 2 May 18th 05 08:55 PM
Wrap text limits in Excel 2003 cell formatting Adelrose Excel Discussion (Misc queries) 1 April 19th 05 06:32 PM


All times are GMT +1. The time now is 11:02 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"