[贴图]EXCEL常用操作图解

jx1680000

<p>1）单列不允许出现重复值设定</p><p>2）有重复值用颜色标出</p><p>3）用颜色隔行标数据，加以区分</p><p>4）控件控制条件格式</p><p>&nbsp;</p><p><img src="data/attachment/forum/dvbbs/2007-2/200722612373157242.gif" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" /></p><p><img src="data/attachment/forum/dvbbs/2007-3/200732912444812781.gif" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" /><br/></p>

[此贴子已经被作者于2007-3-29 12:45:48编辑过]

jx1680000

<img src="data/attachment/forum/dvbbs/2007-2/200722812211225887.gif" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" />

[此贴子已经被作者于2007-2-28 15:52:31编辑过]

jx1680000

<img src="data/attachment/forum/dvbbs/2007-3/2007361628539697.gif" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" /><br/>

[此贴子已经被作者于2007-3-6 16:30:04编辑过]

jingletxj

<p>很有用的图解，谢谢楼主</p>[em01]

diandian501

<p>[em01]</p><p>图文并茂！不错！</p><p>有用得很啊！</p>

jx1680000

<p>如果你要在一张大表中找出一些不符合要求的数据</p><p>我推荐一个好的方法给你，呵呵，好直观的！</p><p><img src="data/attachment/forum/dvbbs/2007-3/200731211273246478.gif" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" /><br/></p>

[此贴子已经被作者于2007-3-12 11:28:31编辑过]

jx1680000

<p>这可能是少有人用的注解吧！</p><p><img src="data/attachment/forum/dvbbs/2007-3/20073121514555413.gif" border="0" onclick="zoom(this)" onload="if(this.width>document.body.clientWidth*0.5) {this.resized=true;this.width=document.body.clientWidth*0.5;this.style.cursor='pointer';} else {this.onclick=null}" alt="" /><br/></p>

[此贴子已经被作者于2007-3-12 15:02:26编辑过]

biggozs

<p>非常直观，谢谢楼主！</p>

excel_jxz

<p>louzhu 楼主太帮了，这个网站很好，对我有很大帮助哦、。</p><p></p>

周星弛

谢版主,顶!