Excel精英培训网

 找回密码
 注册
数据透视表40+个常用小技巧,让你一次学会!
楼主: mrs222

[函数] 用Excel剿灭木马病毒

[复制链接]
发表于 2008-11-26 18:05 | 显示全部楼层
excel精英培训的微信平台,每天都会发送excel学习教程和资料。扫一扫明天就可以收到新教程
回复

使用道具 举报

发表于 2008-11-27 09:03 | 显示全部楼层

既然选择了地平线,留给世界的只能是自己的背影,不管身后的狂风骤雨,我只能风雨兼程
回复

使用道具 举报

发表于 2008-11-27 10:12 | 显示全部楼层

<font style="BACKGROUND-COLOR: #9eb34d;">不能错过了</font>[em29]
回复

使用道具 举报

发表于 2008-11-29 21:30 | 显示全部楼层

<p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">做法</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;">:<br/>&nbsp; &nbsp;&nbsp; &nbsp;1.</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">首先看下拉列表的做法</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;">(</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">如图</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;">1).<br/>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">数据源区域</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;">:$A$2:$A$12[</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">上图看不见</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;">,</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">是因为设置字体为白色</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;">]<br/>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">单元格链接</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;">:$B$3[</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">上图看不见的原因同上</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;">]<br/>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp; &nbsp;</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">下拉显示项数</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;">:11[</span><span style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 宋体; mso-ascii-font-family: Tahoma; mso-hansi-font-family: Tahoma; mso-bidi-font-family: Tahoma; mso-font-kerning: 0pt;">可根据自己需要而设置的</span><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;">.]</span></p><p class="MsoNormal" align="left" style="MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: left; mso-pagination: widow-orphan;"><span lang="EN-US" style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Tahoma; mso-font-kerning: 0pt;"></span>&nbsp;</p><br/><img src="http://www.excelpx.com/skins/default/filetype/jpg.gif" border="0" alt=""/>此主题相关图片如下:<br/><a id="ImgSpan" href="http://www.excelpx.com/UploadFile/2007-7/200771917283468699.jpg" target="_blank"><img alt="按此在新窗口浏览图片" src="http://www.excelpx.com/UploadFile/2007-7/200771917283468699.jpg" border="0"/></a><br/><br/><img src="http://www.excelpx.com/skins/default/filetype/jpg.gif" border="0" alt=""/>此主题相关图片如下:<br/><a id="ImgSpan" href="http://www.excelpx.com/UploadFile/2007-7/200771917284866804.jpg" target="_blank"><img alt="按此在新窗口浏览图片" src="http://www.excelpx.com/UploadFile/2007-7/200771917284866804.jpg" border="0"/></a>
回复

使用道具 举报

发表于 2008-11-30 16:12 | 显示全部楼层

<p>谢谢分享</p>[em01]
回复

使用道具 举报

发表于 2008-12-10 06:27 | 显示全部楼层

<p>看下。是不是与我想的同样</p>[em04][em04]
回复

使用道具 举报

发表于 2008-12-12 01:39 | 显示全部楼层

[em17][em17][em17]
回复

使用道具 举报

发表于 2008-12-12 09:00 | 显示全部楼层
提示: 作者被禁止或删除 内容自动屏蔽
回复

使用道具 举报

发表于 2008-12-12 14:46 | 显示全部楼层

看看咋弄得,多谢楼主分享
回复

使用道具 举报

发表于 2008-12-12 15:33 | 显示全部楼层

可能吗?表示奇大的怀疑
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|Archiver|Excel精英培训 ( 豫ICP备11015029号 )

GMT+8, 2024-6-6 19:17 , Processed in 0.521821 second(s), 8 queries , Gzip On, Yac On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表