[贴图]EXCEL常用操作图解

jx1680000

<p>特殊隐藏(在大表操作中，有选择性隐藏一些不常用或无关的不连续数据)</p><p><br/>

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

jx1680000

<p><table cellspacing="0" cellpadding="0" width="271" border="0" xstr="" style="WIDTH: 203pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="271" style="WIDTH: 203pt; mso-width-source: userset; mso-width-alt: 8672;"></col></colgroup><tbody><tr height="21" style="HEIGHT: 15.75pt;"><td width="271" height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 203pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">1<font class="font0">.右键取消隐藏</font></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">2<font class="font0">.拖动取消隐藏</font></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">3<font class="font0">.手动设行高取消隐藏</font></font></td></tr><tr height="21" style="HEIGHT: 15.75pt;"><td height="21" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 15.75pt; BACKGROUND-COLOR: transparent;"><font face="宋体">4<font class="font5">.自动全表合适行高列宽取消隐藏</font></font></td></tr></tbody></table></p><p><img src="data/attachment/forum/dvbbs/2007-2/20072268525463839.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-2-26 8:53:25编辑过]

jx1680000

<p>用SHIFT配合选取！</p><p><img src="data/attachment/forum/dvbbs/2007-2/20072269484554056.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-2-26 20:18:29编辑过]

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编辑过]