2010年12月16日星期四

Continued to show the formula instead of the cell displays the calculated values

 In Excel, a cell of arbitrary type a formula such as = 1 +1, press the Enter key, then this cell will no longer display the formula, and the results showed 2, and sometimes we do not want to Immediately see the results, but we hope this will continue to show the cell formulas, how to solve this problem? Very simple formula in the cell after the input, then click the menu bar "Tools"-"Formula Auditing"- "formula auditing mode ", so that you can keep the formula intact; and if you want to show the formula The results, you can again click on the "Formula Auditing Mode"button.

没有评论:

发表评论