</noscript> <style>.navbar-header img{ margin:10px;}.navbar-collapse .navbar-nav li{ float:left;}.height60{height:60px;}</style> <nav class="navbar navbar-default navbar-fixed-top"> <div class="container"> <div class="navbar-header"> <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar"> <span class="sr-only">电脑知识与技术</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a href="/"><img src="http://www.dnzs.com.cn/skin/2014/img/logomin.gif" width="122" height="30"></a> </div> <div id="navbar" class="navbar-collapse collapse"> <ul class="nav navbar-nav"> <li><a href="/">首 页</a></li> <li><a href="/yj/">电脑硬件</a></li> <li><a href="/xt/">操作系统</a></li> <li><a href="/rj/">应用软件</a></li> <li><a href="/wl/">网络技术</a></li> <li><a href="/yd/">移动终端</a></li> <li><a href="/bc/">语言编程</a></li> <li><a href="/w3cschool/">教程学习</a></li> <li><a href="/worknote/">工作笔记</a></li> <li><a href="/baike/">电脑百科</a></li> </ul> <ul class="nav navbar-nav navbar-right"> </ul> </div><!--/.nav-collapse --> </div> </nav> <div class="height60"></div> <div class="container bodyfff"> <div class="row"> <div class="col-md-8"> <div class="dnzs-com-cn-c-left-c1 visible-lg">您当前的位置：<a href="/index.html">首页</a> > <a href="/rj/">应用软件</a> > <a href="/rj/Excel/">Excel</a> </div> <div style="height:10px;"></div> <h3>在Excel2003中添加单元格简介说明文字</h3> <div style="height:10px;"></div> <div class="row"> <div class="col-md-6 dnzs-com-cn-c-left-c3">2014-08-16 DNZS.COM.CN</div> <div class="col-md-6 dnzs-com-cn-c-left-c3 visible-lg"> <div class="bdsharebuttonbox"><a href="#" class="bds_more" data-cmd="more"></a><a href="#" class="bds_weixin" data-cmd="weixin" title="分享到微信"></a><a href="#" class="bds_qzone" data-cmd="qzone" title="分享到QQ空间"></a><a href="#" class="bds_tsina" data-cmd="tsina" title="分享到新浪微博"></a><a href="#" class="bds_tqq" data-cmd="tqq" title="分享到腾讯微博"></a><a href="#" class="bds_sqq" data-cmd="sqq" title="分享到QQ好友"></a></div> </div> </div> <div class="visible-lg"> <!--google adsensee开始--> <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-6859217913961534" data-ad-slot="4293137274" data-ad-format="auto"></ins> <!--google adsensee结束--> </div> <div class="dnzs-com-cn-c-left-c4"> Excel中数据太多会导致混乱一片，最终导致我们找数据时非常困难。不妨试试给重要的单元格添加简介和说明，这样以后只需要将鼠标放到某个单元格上就会显示我们初始时填写的简介说明文字了，可以让我们很清楚的找到自己想要的内容。<br /><br /> <strong>在Excel2003单元格中添加简介说明文字方法：</strong><br /><br /> ①打开表格，选中需要添加简介说明的单元格，然后右键点击，选择“插入批注”；<br /><br /><img alt="插入批注" border="0" height="490" src="/d/file/rj/Excel/2014-08-16/a897a48335e1480a63161fe82e6cb5a7.jpg" style="border-bottom-style: none; border-right-style: none; border-top-style: none; border-left-style: none" width="468" /><br /><br /> ②在弹出的“插入批注”中输入简介说明文字即可完成。<br /><br /><img alt="输入简介说明文字" border="0" height="490" src="/d/file/rj/Excel/2014-08-16/abb2e4c99a4b32d9bec4cca168b89cc8.jpg" style="border-bottom-style: none; border-right-style: none; border-top-style: none; border-left-style: none" width="468" /><br /><br /> 添加好Excel批注后，你只需要将鼠标放到该单元格上就会自动显示你先前输入的简介说明文字了。<br /><br /><img alt="鼠标放到该单元格自动显示" border="0" height="347" src="/d/file/rj/Excel/2014-08-16/c9219a44103ae93fcc5292063244afc5.jpg" style="border-bottom-style: none; border-right-style: none; border-top-style: none; border-left-style: none" width="455" /><br /><br /> <strong>删除批注方法：</strong><br /><br /> 选中添加过简介说明的单元格，单击右键，在弹出菜单中选择“删除批注”即可。<br /><br /><img alt="删除批注" border="0" height="480" src="/d/file/rj/Excel/2014-08-16/aceac2346c92f9f897f448e3d35207b4.jpg" style="border-bottom-style: none; border-right-style: none; border-top-style: none; border-left-style: none" width="453" /><br /><br /><img alt="简介说明文字没有了" border="0" height="336" src="/d/file/rj/Excel/2014-08-16/dc1809fe5066229bf6f3a77dffaa1ce3.jpg" style="border-bottom-style: none; border-right-style: none; border-top-style: none; border-left-style: none" width="450" /></div> <div class="visible-lg"> <!--google adsensee开始--> <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-6859217913961534" data-ad-slot="4293137274" data-ad-format="auto"></ins> <!--google adsensee结束--> </div> <div class="dnzs-com-cn-c-left-c5"></div> <div id="hm_t_99372"></div> </div> <div class="col-md-4"> <div class="style_1"> <form method="post" id="searchform" action="/e/search/index.php"> <fieldset> <input id="keyboard" name="keyboard" type="text" value="输入关键字" class="text_input" onblur="if(this.value==''){this.value='输入关键字';}" onfocus="if(this.value =='输入关键字') {this.value=''; }" /> <input type="hidden" name="show" value="title" /> <input type="hidden" name="tempid" value="1" /> <input name="submit" type="submit" value="" /> </fieldset> </form> </div> <div style="clear:both; height:10px;"></div> <div class="dnzs-com-cn-c-right"> <!--google adsensee开始--> <ins class="adsbygoogle" style="display:block" data-ad-client="ca-pub-6859217913961534" data-ad-slot="4293137274" data-ad-format="auto"></ins> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> <!--google adsensee结束--> <img src="http://www.dnzs.com.cn/d/file/worknote/2017-05-25/10c6b210e83351e60d50f3ddabf36dc1.jpg" width="340" height="367" /> </div> </div> </div> </div> <!--foot--> <div class="container-fluid footer visible-lg"> <li><a href="/">网站首页</a> | <a href="/dnzs/about.html">关于我们</a> | <a href="/dnzs/server.html">服务条款</a> | <a href="/dnzs/ads.html">广告服务</a> | <a href="/dnzs/contact.html">联系我们</a> | <a href="/dnzs/sitemap.html">网站地图</a> | <a href="/dnzs/mianze.html">免责声明</a> | <a href="http://m.dnzs.com.cn" target="_blank">手机客户端</a> | <a href="/dnzs/link.html" target="_blank">友情链接</a> | <a href="/dnzs/tg.html" target="_blank">网站投稿</a> | <a href="/dnzs/JoinUs.html" target="_blank">加入我们</a> </li> <li>微信公众账号：dnzscomcn 自适应版（手机、PC）地址：m.dnzs.com.cn 网址：www.dnzs.com.cn </li> <li>Copyright © 2008-2017 电脑知识与技术(dnzs.com.cn) All rights reserved </li> <li>京ICP备13003036号 京公网安备110107000134 <script src="http://s5.cnzz.com/stat.php?id=814121&web_id=814121" language="JavaScript"></script></li> </div> <!--foot--> <script>window._bd_share_config={"common":{"bdSnsKey":{},"bdText":"","bdMini":"2","bdMiniList":false,"bdPic":"","bdStyle":"0","bdSize":"16"},"share":{},"image":{"viewList":["weixin","qzone","tsina","tqq","sqq"],"viewText":"分享到：","viewSize":"16"},"selectShare":{"bdContainerClass":null,"bdSelectMiniList":["weixin","qzone","tsina","tqq","sqq"]}};with(document)0[(getElementsByTagName('head')[0]||body).appendChild(createElement('script')).src='http://bdimg.share.baidu.com/static/api/js/share.js?v=89860593.js?cdnversion='+~(-new Date()/36e5)];</script> <script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script> <script> (adsbygoogle = window.adsbygoogle || []).push({}); </script> <!-- Bootstrap core JavaScript ================================================== --> <!-- Placed at the end of the document so the pages load faster --> <script src="//cdn.bootcss.com/jquery/1.11.3/jquery.min.js"></script> <script src="//cdn.bootcss.com/bootstrap/3.3.5/js/bootstrap.min.js"></script> <!-- IE10 viewport hack for Surface/desktop Windows 8 bug --> <script src="../../assets/js/ie10-viewport-bug-workaround.js"></script> <!-- UJian Button BEGIN --> <script type="text/javascript">var ujian_config = {num:5,showType:15};</script> <script type="text/javascript" src="http://v1.ujian.cc/code/ujian.js?uid=2066269"></script> <script type="text/javascript"> function stop() {alert("电脑知识与技术：www.dnzs.com.cn "); return false; }document.oncontextmenu=stop; </script> </body> </html>