Excel 2007 - Nothing shows up in the cell while I'm typing!

[piker78]

I'm running into an issue with a range of cells in a spreadsheet where
nothing shows up in the cell as I type. I can see the cursor moving
to the right to show that I'm typing something, but the value that I'm
typing doesn't actually appear in the cell until I hit <Enter>.

I'm maintaining a large workbook with lots of formulas and named
ranges. It was built by someone who no longer works here, so I'd
rather not blow it away and start over. It appears it was built using
Excel 2003. I'm now managing the file in Excel 2007. I've been
adding records to this spreadsheet for several days now and didn't
have this issue. But now all of a sudden, I get to a certain row (in
this case, Row 1776) and nothing I type shows up until I hit enter.
If I clear the contents of any row above row 1776, I can clearly see
everything as I type it. But with Row 1776 and beyone, I can't see
what I type.

I am able to see what I'm typing in the formula bar at the top of the
page, but not in the cell itself.

Any help would be greatly appreciated!

 

[Ron de Bruin]

Hi

See if the text color is not white or the same is as the color of the background

 

[piker78]

Hi

See if the text color is not white or the same is as the color of the background

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm








- Show quoted text -

Thanks for the response, but I don't think that's the issue. The text
just doesn't show up while I'm typing, but once I hit enter, the text
does appear in the color that I specified in the formatting options.
This one has stumped me so far!

 

[Ken Johnson]

Thanks for the response, but I don't think that's the issue. The text
just doesn't show up while I'm typing, but once I hit enter, the text
does appear in the color that I specified in the formatting options.
This one has stumped me so far!

Sounds similar to below from this group May 5

Bizarre Excel 2007 behavior solved

Ken Johnson

 

[Jim Rech]

In the post Ken cited it was conditional formatting that caused the problem.
Specifically the worksheet had:

"two columns with conditional formatting such that if the entry is zero no
data appears in those columns."

http://snipurl.com/28s5n [groups_google_com]

I assume by this that the conditional formatting was to use white font color
when the cell had a "0" value. I tried this is it does result in the
problem of seeing nothing while typing in a cell.

Perhaps piker78 can check for conditional formatting in a problem cell.

Btw, I think the more common way to not displaying zero values is with a
number format like this:

#,##0_);(#,##0);

The ending semicolon does it. This has the advantage of not appearing in a
printout when the "black and white" print setting is used, unlike white
font. And it seems to fix the typing problem too.



--
Jim
| On May 14, 7:48 am, (e-mail address removed) wrote:
| >
| >
| >
| > > Hi
| >
| > > See if the text color is not white or the same is as the color of the
background
| >
| > > --
| >
| > > Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
| >
message| > > > I'm running into an issue with a range of cells in a spreadsheet
where
| > > > nothing shows up in the cell as I type. I can see the cursor moving
| > > > to the right to show that I'm typing something, but the value that
I'm
| > > > typing doesn't actually appear in the cell until I hit <Enter>.
| >
| > > > I'm maintaining a large workbook with lots of formulas and named
| > > > ranges. It was built by someone who no longer works here, so I'd
| > > > rather not blow it away and start over. It appears it was built
using
| > > > Excel 2003. I'm now managing the file in Excel 2007. I've been
| > > > adding records to this spreadsheet for several days now and didn't
| > > > have this issue. But now all of a sudden, I get to a certain row
(in
| > > > this case, Row 1776) and nothing I type shows up until I hit enter.
| > > > If I clear the contents of any row above row 1776, I can clearly see
| > > > everything as I type it. But with Row 1776 and beyone, I can't see
| > > > what I type.
| >
| > > > I am able to see what I'm typing in the formula bar at the top of
the
| > > > page, but not in the cell itself.
| >
| > > > Any help would be greatly appreciated!- Hide quoted text -
| >
| > > - Show quoted text -
| >
| > Thanks for the response, but I don't think that's the issue. The text
| > just doesn't show up while I'm typing, but once I hit enter, the text
| > does appear in the color that I specified in the formatting options.
| > This one has stumped me so far!
|
| Sounds similar to below from this group May 5
|
| Bizarre Excel 2007 behavior solved
|
| Ken Johnson

 

[KMP]

You may have multiple worksheets selected. Ensure that only the sheet you are working on is selected by clicking off the other tabs. This solution worked for me when I had this issue.