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
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
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 12: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 08:57 PM.

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"