Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
уторак, 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why am I getting XXX error in text cell with word wrap turned on? | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
####### within a wrap text cell. | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) |