新西兰天维网社区

标题: Please help!!! Excel formula [打印本页]

作者: KKO 时间: 2013-5-2 14:25:39 标题: Please help!!! Excel formula

Hi all, I am working in excel however suddenly my excel formula doesn’twork anymore, e.g. I type in 1+1 in one cell, and it shows blank! anyone knowshow to fix this? I have been working on this for the whole morning I don’t wantto redo everything, Help me! sorry cant type Chinese at work.

作者: 花天堂 时间: 2013-5-2 14:29:33

font colour is same as the cell colour?

作者: KKO 时间: 2013-5-2 14:31:02

yes it is

作者: KKO 时间: 2013-5-2 14:33:03

when i click on the cell, i can see the formula is there but its blank when i click somewhere else!

作者: LODD 时间: 2013-5-2 14:33:11

put a "=" before your "1+1" and see

作者: KKO 时间: 2013-5-2 14:38:29

yes, of course i put =1+1!!

作者: jarod_2003 时间: 2013-5-2 14:39:08

restart your PC

作者: myself2662 时间: 2013-5-2 14:49:13

Change your font colour to black.

作者: 假装多好 时间: 2013-5-2 16:29:09

变颜色试试吧前几天我做表格时候有一格不知道为什么改成白色字就看不到了

作者: 呼噜猫 时间: 2013-5-13 00:44:32

Go to the cell that has your formula. Press F9 - if the correct answer is displayed then the problem is that you have calculations set to Manual.

To change it to Automatic go to Tools -> Options -> Calculation tab, then select Automatic.

作者: superlady 时间: 2013-5-13 09:24:38

多数的可能是font的颜色被设置成白色了，所以看不见。

作者: yangp1 时间: 2013-5-13 14:04:29

呼噜猫发表于 2013-5-12 23:44
Go to the cell that has your formula. Press F9 - if the correct answer is displayed then the problem ...

I THINK THIS IS CORRECT ANSWER, THE FORMULA IS NOT AUTOMATIC LINK

欢迎光临新西兰天维网社区 (http://bbs.skykiwi.com/)