在EXCEL中隐藏公式的问题，自己解决了，大家看看是不是正确。

ww0000

RHF R看看

igmq

看看先<br/>

dxwzm

<img alt="" src="http://www.excelpx.com/Skins/default/topicface/face10.gif"/>

dxwzm

<p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 28pt;"><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">如果公式多，选择包含公式的单元格区域也很麻烦，可这样操作：</font></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 28pt;"><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">1</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">、选择菜单中的编辑</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">定位</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">定位条件</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">公式</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">确定</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 28pt;"><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">2</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">、选择菜单中的格式</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">单元格</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">保护</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">选择隐藏和锁定</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">选择确定</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 28pt;"><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">3</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">、选择菜单中的工具</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">保护工作表</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">输入密码</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><font face="Times New Roman">-</font></span><span style="FONT-SIZE: 14pt; FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">确定</span><span lang="EN-US" style="FONT-SIZE: 14pt;"><p></p></span></p>

excel学者

kankan

xutong007

<p>看看，学习学习</p><p></p>

zjm3373132

rhrhr

xdwy81129

学习[em01][em01]

foud129

<p>下来看看</p>

bdgjw2010

hh