这篇文章的内容来自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.
- Select the range of cells whose formulas you want to hide. You can also select nonadjacent ranges or the entire sheet.
- On the Format menu, click Cells, and then click the Protection tab.
- Select the Hidden check box.
- Click OK.
- On the Tools menu, point to Protection, and then click Protect Sheet.
- Make sure the Protect worksheet and contents of locked cells check box is selected.
(注,最好把 Blocked 也选上,用户在可以选择单元格的情况下,公式可能会消失。)