Excel Problem

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

shelly24

Thread Starter
Joined
Jul 4, 2001
Messages
21
Hi, I hope someone can help me. I think it is probably a simple option that is set that I don't know about. Someone in my office has a spreadsheet. It contains dollar amounts and customer names the first 2 rows are title rows that tell you what is in the row. Somehow the words are not there and when we type they do not show up. You can see them in the formula bar but not in the cells. When you go to print preview sometimes you can see the words that way. What could cause this. Thank you for any help.
 
Joined
Jul 29, 2001
Messages
21,334
The cells are either hidden or someone has changed the font color to white..
 

shelly24

Thread Starter
Joined
Jul 4, 2001
Messages
21
Rockn, Thank you I think it must have been the font color. We deleted the rows and inserted new ones before I saw your reply. But when I used white font on another spreadsheet it did the same thing. Smart thinking. Thank's again.
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,749
Just to make you aware.

If you put a custom format on cells, and type:

;;;

into the custom format bar, this also hides the cell contents. I think you only need two semi-colons in Excel 97. I tried it in 2K and thought they might have removed the option, but there it was when I tried three.
 

shelly24

Thread Starter
Joined
Jul 4, 2001
Messages
21
Dreamboat, Thank you for your reply. I did try that in excel and you are correct. If you put three semi-colons in the custom format box it does hide the contents of the cell. But with the problem I was having when I typed in the cell you could not see any characters at all displayed as you typed. With the custom format you mentioned you can see the characters as you type but as soon as you hit enter or tab and go to a different cell the characters are hidden. So I think the problem must have been the white font color. Thank's again.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top