Excel 中在显示公式本身和它的值之间切换

这篇文章的内容来自Excel帮助文件。我本来已经在编辑Blog的时候把它翻译成了中文，谁知道在发表的时候失败了，竹篮打水一场空。我经常在编辑CSDN的Blog时遇到前功尽弃的事情，幸好还没有疯掉。有时候我会从头来过，不过今天这篇英文就英文吧。

Switch between displaying formulas and their values on a worksheet

• Press CTRL + ` (grave accent).

Prevent a formula from displaying in the formula bar

Caution  This procedure also prevents the cells that contain the formula from being edited.

1. Select the range of cells whose formulas you want to hide. You can also select nonadjacent ranges or the entire sheet.
2. On the Format menu, click Cells, and then click the Protection tab.
3. Select the Hidden check box.
4. Click OK.
5. On the Tools menu, point to Protection, and then click Protect Sheet.
6. Make sure the Protect worksheet and contents of locked cells check box is selected.

(注，最好把 Blocked 也选上，用户在可以选择单元格的情况下，公式可能会消失。)