复制粘贴的小技巧

复制粘贴的小技巧
0 L) L6 }  ^0 B<DIV class=t_msgfont id=postmessage_17961271>做报表时经常要把<NOBR><B class=kgb onmouseover='isShowAds = false;isShowAds2 = false;isShowGg = true;InTextAds_GgLayer="_u6570_u636E";KeyGate_ads.ShowGgAds(this,"_u6570_u636E",event)' style="BORDER-TOP-WIDTH: 0px; PADDING-RIGHT: 0px; PADDING-LEFT: 0px; FONT-WEIGHT: normal; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; CURSOR: hand; COLOR: #ff8000; PADDING-TOP: 0px; BORDER-RIGHT-WIDTH: 0px; TEXT-DECORATION: underline" onclick='javascript:window.open("http://pagead2.googlesyndication.com/pagead/iclk?sa=l&amp;ai=Bv6Omec0oSdLULpXwvgOAvbHwC7mSuHXtp8SQCcCNtwGw2wYQARgBIKy8kQooFDgAUNSc_vcCYJ2p2oHIBbIBD2Jicy4zNjZ0aWFuLm5ldMgBAdoBLWh0dHA6Ly9iYnMuMzY2dGlhbi5uZXQvdGhyZWFkLTkzNjc2NS0xLTEuaHRtbIACAakCDyDVL0-lgz7IAuWJhgaoAwHoA7wF6APTAfUDAAEAAJgEAA&amp;num=1&amp;adurl=http://www.hgtj.cn&amp;client=ca-pub-1681215984289622");GgKwClickStat("数据","www.hgtj.cn","afc","2000072008");' onmouseout='isShowGg = false;InTextAds_GgLayer="_u6570_u636E"'>数据</B></NOBR>从这个表复制到另一个表，但是有时候我们只需要粘贴数据，而默认情况下excel把格式也一起复制过去了，我想大家都有过这样的经历吧<BR>今天就说个如何只复制数值的小技巧，其实知道的人挺多的，就发给不知道的人看吧，不多说，自己看图了<BR>附件<BR>复制需要的内容后，粘贴时选“选择性粘贴”<BR><IMG alt="" src="http://www.chinadforce.com/attachments/day_081031/20081031_d990c53a893732b6b5020zXC7MJ6ala7.jpg" onload="attachimg(this, 'load')" border=0><BR><BR>在“选择性粘贴”选项中选择数值，“确定”后就OK了<BR><IMG alt="" src="http://www.chinadforce.com/attachments/day_081031/20081031_3d8b1d7ea7a4fbf0e5a05FcK0hP33Evj.jpg" onload="attachimg(this, 'load')" border=0></DIV>