Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When some of my Office 2003 excel files are opened I can only see the data if
I select the cell and view the data in the data entry field at the top of the worksheet. How do I resolve this issue? I tried doing a repair several times and that didn't work. I am trying to avoid uninstalling Office and reinstalling. Thanks in advanced for your help. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If the data is visible in the formula bar, but not in the cell, then check to
make sure that the font color is not the same as the cell background color. -- Gary''s Student - gsnu200762 "Usmerlin" wrote: When some of my Office 2003 excel files are opened I can only see the data if I select the cell and view the data in the data entry field at the top of the worksheet. How do I resolve this issue? I tried doing a repair several times and that didn't work. I am trying to avoid uninstalling Office and reinstalling. Thanks in advanced for your help. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The font is black and the cells are white. I just noticed that text that is
vertically justified is bunching up. Basically all the letters are together as one black blob. "Gary''s Student" wrote: If the data is visible in the formula bar, but not in the cell, then check to make sure that the font color is not the same as the cell background color. -- Gary''s Student - gsnu200762 "Usmerlin" wrote: When some of my Office 2003 excel files are opened I can only see the data if I select the cell and view the data in the data entry field at the top of the worksheet. How do I resolve this issue? I tried doing a repair several times and that didn't work. I am trying to avoid uninstalling Office and reinstalling. Thanks in advanced for your help. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does this mean you can't see the cells in the window below the formulabar?
If yes, then try: window|arrange|tiled and then you can resize that window the way you want. If no, maybe you could be more descriptive. Usmerlin wrote: When some of my Office 2003 excel files are opened I can only see the data if I select the cell and view the data in the data entry field at the top of the worksheet. How do I resolve this issue? I tried doing a repair several times and that didn't work. I am trying to avoid uninstalling Office and reinstalling. Thanks in advanced for your help. -- Dave Peterson |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Yes that is problem. For example I have a calendar and the only thing in the
cells are numbers, which are not visible until I click on the cell and see the number in the formula bar. This problem just recently occurred. Data I could see in files before, I cannot see now until I select the cell and look at the formula bar. I have had others open the files I am having issues with and there is no problem on their end. "Dave Peterson" wrote: Does this mean you can't see the cells in the window below the formulabar? If yes, then try: window|arrange|tiled and then you can resize that window the way you want. If no, maybe you could be more descriptive. Usmerlin wrote: When some of my Office 2003 excel files are opened I can only see the data if I select the cell and view the data in the data entry field at the top of the worksheet. How do I resolve this issue? I tried doing a repair several times and that didn't work. I am trying to avoid uninstalling Office and reinstalling. Thanks in advanced for your help. -- Dave Peterson |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I was trying to describe that you couldn't even see the cells. So my previous
suggestion won't work. Do you use multiple monitors? http://groups.google.co.uk/group/mic...09488256478b2d or http://snipurl.com/1crbf Mike Brambley posts a link to a suggestion that worked for him. Usmerlin wrote: Yes that is problem. For example I have a calendar and the only thing in the cells are numbers, which are not visible until I click on the cell and see the number in the formula bar. This problem just recently occurred. Data I could see in files before, I cannot see now until I select the cell and look at the formula bar. I have had others open the files I am having issues with and there is no problem on their end. "Dave Peterson" wrote: Does this mean you can't see the cells in the window below the formulabar? If yes, then try: window|arrange|tiled and then you can resize that window the way you want. If no, maybe you could be more descriptive. Usmerlin wrote: When some of my Office 2003 excel files are opened I can only see the data if I select the cell and view the data in the data entry field at the top of the worksheet. How do I resolve this issue? I tried doing a repair several times and that didn't work. I am trying to avoid uninstalling Office and reinstalling. Thanks in advanced for your help. -- Dave Peterson -- Dave Peterson |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dave,
Thank you very much for that link. I will have to switch monitors out, but I unchecked "extend my Windows desktop onto this monitor" and opened the files I was having issues with and they are now working properly. Thanks again, I appreciate it. Mike "Dave Peterson" wrote: I was trying to describe that you couldn't even see the cells. So my previous suggestion won't work. Do you use multiple monitors? http://groups.google.co.uk/group/mic...09488256478b2d or http://snipurl.com/1crbf Mike Brambley posts a link to a suggestion that worked for him. Usmerlin wrote: Yes that is problem. For example I have a calendar and the only thing in the cells are numbers, which are not visible until I click on the cell and see the number in the formula bar. This problem just recently occurred. Data I could see in files before, I cannot see now until I select the cell and look at the formula bar. I have had others open the files I am having issues with and there is no problem on their end. "Dave Peterson" wrote: Does this mean you can't see the cells in the window below the formulabar? If yes, then try: window|arrange|tiled and then you can resize that window the way you want. If no, maybe you could be more descriptive. Usmerlin wrote: When some of my Office 2003 excel files are opened I can only see the data if I select the cell and view the data in the data entry field at the top of the worksheet. How do I resolve this issue? I tried doing a repair several times and that didn't work. I am trying to avoid uninstalling Office and reinstalling. Thanks in advanced for your help. -- Dave Peterson -- Dave Peterson |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm not sure if this'll help, but you may want to review Chip Pearson's site:
http://cpearson.com/excel/MultipleMonitors.aspx Usmerlin wrote: Dave, Thank you very much for that link. I will have to switch monitors out, but I unchecked "extend my Windows desktop onto this monitor" and opened the files I was having issues with and they are now working properly. Thanks again, I appreciate it. Mike "Dave Peterson" wrote: I was trying to describe that you couldn't even see the cells. So my previous suggestion won't work. Do you use multiple monitors? http://groups.google.co.uk/group/mic...09488256478b2d or http://snipurl.com/1crbf Mike Brambley posts a link to a suggestion that worked for him. Usmerlin wrote: Yes that is problem. For example I have a calendar and the only thing in the cells are numbers, which are not visible until I click on the cell and see the number in the formula bar. This problem just recently occurred. Data I could see in files before, I cannot see now until I select the cell and look at the formula bar. I have had others open the files I am having issues with and there is no problem on their end. "Dave Peterson" wrote: Does this mean you can't see the cells in the window below the formulabar? If yes, then try: window|arrange|tiled and then you can resize that window the way you want. If no, maybe you could be more descriptive. Usmerlin wrote: When some of my Office 2003 excel files are opened I can only see the data if I select the cell and view the data in the data entry field at the top of the worksheet. How do I resolve this issue? I tried doing a repair several times and that didn't work. I am trying to avoid uninstalling Office and reinstalling. Thanks in advanced for your help. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XL2003, how can I set the view to show only the cells with data | Setting up and Configuration of Excel | |||
View only Highlighted Cells | Excel Discussion (Misc queries) | |||
Excel-cannot view info placed in cells | Excel Discussion (Misc queries) | |||
Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
How do I view formulas by values not by which cells they use to c. | Excel Discussion (Misc queries) |