Cell above goes blank.

D

David C.

I have a workbook with 2 worksheets. In the first one,
when I input in any cell on a new line, the cell above
goes blank. This doesn't happen in the second worksheet.
What gives?? Can anybody tell me how to stop the cell
above from going blank? Many thanks.
 
C

Celtic_Avenger

Are there any formular entries in the above cells, do you have an
conditional formating in the above cells, do you have any VBA macro
conecting to the above cells?

Celtic_Avenge
 
D

Dave Peterson

It could be conditional formatting that changes the font to white (so it only
appears blank).

When you select that cell that turned blank, do you see anything in the formula
bar.

If you do, try format|conditional formatting and either remove it or change it
to your liking.

If you don't, it could be an event macro that's clearing the cell above.

close excel
open excel in safe mode (disabling macros)
windows start button|run
excel /safe

File|open your workbook
and test it out.

If it works ok, then try to find the developer and ask them why.

If you're comfortable in the VBE (where macros live), you can look under that
worksheet's code module or under ThisWorkbook for some kind of worksheet_change
event.
 
G

Guest

Thanks for your reply, however, I may not have worded my
question properly. It would be more accurate to say that
when I start inputing in a cell, 2 lines open up, the top
one of which hides the one above - it doesn't actually
delete the contents which reappear when I finish. It is
very annoying and I hope someone can tell me how to stop
2 lines opening up. I do not have "Wrap Text" enabled,
and this happens on only this one worksheet.
David C.
 
D

Dave Peterson

It kind of sounds like it happens when you're editing the cell.

I like to edit the contents in the formula bar--not in the cell itself--for the
same reason as you.

If you want to try that to see if you like it better:

Tools|Options|Edit tab|Edit directly in cell (uncheck it)

The bad news is that sometimes with long formulas/values, the formula bar can
cover the first couple of rows. I just make the window slightly smaller and
move it out of the way.
 
D

David C.

Many thanks for your suggestion. Disabling "Edit directly
in the cell" did the trick on this one worksheet. But
it's weird - none of my many other worksheets were
affected by editing in the cell being on. Just this one.
Thanks again,
D.C.
-----Original Message-----
It kind of sounds like it happens when you're editing the cell.

I like to edit the contents in the formula bar--not in the cell itself--for the
same reason as you.

If you want to try that to see if you like it better:

Tools|Options|Edit tab|Edit directly in cell (uncheck it)

The bad news is that sometimes with long
Click to expand...
formulas/values, the formula bar can
 
Top