Excel九大平常表格操作技巧，分分钟加强你的工作效率
<div style="color: black; text-align: left; margin-bottom: 10px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">针对</span>许多刚接触Excel的<span style="color: black;">朋友</span><span style="color: black;">来讲</span>，Excel到底该怎么学才好。Excel里面<span style="color: black;">咱们</span>有这几大块<span style="color: black;">大众</span>需要记住，<span style="color: black;">大众</span><span style="color: black;">能够</span>从这几个方面入手。1、Excel函数；2、Excel表格操作技巧；3、数据透视表；4、Excel图表；5、Excel代码编辑（VBA）。今天<span style="color: black;">咱们</span>就<span style="color: black;">经过</span>Excel表格操作技巧，让<span style="color: black;">大众</span><span style="color: black;">能够</span>尽快的上手学习Excel。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">1、将文字颠倒<span style="color: black;">次序</span></strong></h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/pgc-image/5b90dfc6cfa8466a9e200f3c5f667075~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988907&x-signature=amX0m8yENc9M1SRQhkeuVEPDGCE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">复制正常<span style="color: black;">次序</span>对象→在字体前加@→点击向下旋转文字→点击自动换行</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">2、制作打钩方框</strong></h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/707b738fe0af47cda47db8e664a39ddd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988907&x-signature=w1P8nEInif%2BwKvK%2FdX21unSNJ8c%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">输入"R"→设置字体为Wingdings2</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">3、给汉字标注拼音</strong></h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/d49dafc81d124897af9c80d421d54052~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988907&x-signature=8PgjDNnoyBwtK7Y19hKxMxrcjdY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">标注拼音→输入汉字→<span style="color: black;">选取</span>拼音设置→居中→编辑拼音→输入拼音→<span style="color: black;">表示</span>拼音字符</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">4、<span style="color: black;">插进</span>带音调的拼音</strong></h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/a27cd9aca83041ac83af7dd8483e66df~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988907&x-signature=FdoL62Epug7trCk6v5EWymDDvlA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">标注带音调的拼音→<span style="color: black;">插进</span>-符号→拉丁语扩充-B→输入带音调的拼音（备注：动图中“们”应为第二声。）</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">5、用斜线分割单个单元格</strong></h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/b03e8828d25145d29d58cc3f681f411f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988907&x-signature=HZsu1bfwPmeQMhcMSt%2FLI7%2BP044%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中对象→<span style="color: black;">插进</span>形状（直线）→ALT+鼠标 快速定位单元格边角→F4 重复动作，添加分割线→<span style="color: black;">插进</span>文本框→<span style="color: black;">调节</span>字体</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">6、<span style="color: black;">隐匿</span>不需要<span style="color: black;">表示</span>区域</strong></h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/c28cdfb762ec453ea745591bb6c1f142~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988907&x-signature=HGqxIkbHpbqc5x1I44MVqpEYwfc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中对象→Ctrl+1→点击自定义→输入；；；</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">7、分段<span style="color: black;">表示</span>手机号码</strong></h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/09d588b3438248de9d3c68d207760c84~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988907&x-signature=27VNTG9lIu5zQyaR5eJkkXbacEE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中号码→Ctrl+1→点击自定义→输入000-0000-0000</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">8、数据以万为单位<span style="color: black;">表示</span></strong></h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/852f33d8d61845c8afecfcd998e878ea~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988907&x-signature=RvwStG%2FXRoDRADf3H%2BYnl4CQgCs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中对象→Ctrl+1→点击自定义→输入0！.0,"万"</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">9、对个案百分比排序</strong></h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/611792cf18a747f4a8e2694fb639dcd9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727988907&x-signature=f0pZGRWIUiwKDa0y3Uuqp6Y2%2Fig%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中对象→排序→取消勾选数据<span style="color: black;">包括</span>标题→<span style="color: black;">选取</span>序列。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此刻</span>你学会了Excel的<span style="color: black;">有些</span>基本操<span style="color: black;">功效</span>法了吗？</p>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="http://p1.toutiaoimg.com/large/mosaic-legacy/dc0a0005586c0d120df3" style="width: 50%; margin-bottom: 20px;">
<div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">专栏</span></div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">Excel函数应用视频<span style="color: black;">教育</span></div>
<div style="color: black; text-align: left; margin-bottom: 10px;">作者：Excel函数与VBA实例</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">199币</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">3人已购</div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">查看</div>
</div>
</div>
</div>
</div>
</div>
在遇到你之前，我对人世间是否有真正的圣人是怀疑的。 可以发布外链的网站 http://www.fok120.com/ 谷歌外链发布 http://www.fok120.com/
页:
[1]