• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ghosted enteries

D

Dean

New Member
Using excel 2003, spreadsheet cols. A-X, rows 1-125. Every thing works with the exception of cols. M&N rows 2-125. Unless I higlight this area I do not see the entery, but I can use formulas, there is information in cells m2-m125. What did I do to make this disappear? How do I fix it?


Thanks for the help, I think this problem is 2 simple compared to the other post I have been reading!
 
Good day Deam

Might be clutching at straws here but you text fonts in the columns is not formatted to white!!
 
Dean

What I meant was that for some reason you text in the affected cells may be formatted in white and as such would not be visible. If you select all the cells in columns M&N rows 2-125 and in your format group pick black for the text.
 
I highlighted/selected the affected cells, choose format cells, font, selected black and they still do not appear. Thanks again, You wouldn't think that this problem could be so complicated.


I inserted 2 cols. and they respond the same way??????
 
Dean


Firstly, Welcome to the Chandoo.org Forums


Do the cells have a Conditional Format applied


Select some of the cells

Goto Format, Conditonal Format and remove the CF or at least inspect it to see
 
Thank you, apparenyly the 1st row was cond, formated all the others weren't. How I continuely overlooked something so simple. Thanks again
 
You must log in or register to reply here.
Back
Top