盘点Excel中1秒钟完成的技巧，你会几个？
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel技巧有<span style="color: black;">非常多</span>，<span style="color: black;">然则</span>一秒钟就<span style="color: black;">能够</span>完成的，<span style="color: black;">博主</span>分享职场工作中，实用的5个1秒钟技巧，<span style="color: black;">瞧瞧</span>你会几个？</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1、自动求和</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">如下所示，<span style="color: black;">咱们</span>需要快速汇总横向和纵向的小计</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/416684efeda54a3a85a4f54fb3c7368c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948906&x-signature=HbZ9BZzP%2BQQBWcq5KkF7xULuAKw%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>选中数据区域，<span style="color: black;">而后</span>点击右上角的自动求和，就<span style="color: black;">能够</span>完成计算了，快捷键是alt+=号</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/046a0b59fad740138a4720af107bfbf9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948906&x-signature=SGfouXHDRFltblV65xIUpLMBgW0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2、快速核对两列数据</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">如下所示，需要快速核对两列数据，找出差异的部分</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6f936cc0a5164a528f8e4d4460cc28ac~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948906&x-signature=LRfFmkp%2FyPbni%2FMMWdtAONnKWZ0%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>只需要选中数据，按ctrl+\就<span style="color: black;">能够</span>快速<span style="color: black;">查询</span>出来，最后标记一个颜色<span style="color: black;">就可</span>：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/84a7a2f527ae409e99db257a37b13dd3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948906&x-signature=s77H%2FSp1AbNokLDs62dejdyj%2BgQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">3、快速美化表格</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">上面是普通的表格，<span style="color: black;">咱们</span>只需要按快捷键ctrl+t，就<span style="color: black;">能够</span>一键转换成下方的智能表格</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">表格的颜值瞬间拉满</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/ba838b1bae6c44f7936db13cbfd9a8e0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948906&x-signature=NnmJ%2FOXSARx31S0AM7uiwhwZHRg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">4、快速找到重复值</h1>
<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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f8cd84a8b8d4412dad22f3e2a7de83bf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948906&x-signature=YdLlhZuWAH4jdnQmYB2Mr2U4VMI%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>只需要选中a列数据，点击<span style="color: black;">要求</span>格式，<span style="color: black;">而后</span><span style="color: black;">选取</span><span style="color: black;">明显</span><span style="color: black;">表示</span>单元格规则，<span style="color: black;">选取</span>重复值，这个时候，重复的数据，就立刻被标记了一个颜色，如下所示：</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/9421693813904dd5957791e4bf9d6401~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948906&x-signature=VOZkbFgv4krjIkWtdg49Y9O%2Bmd8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">5、固定首行</h1>
<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>想标题行固定<span style="color: black;">表示</span>，这些<span style="color: black;">咱们</span>才<span style="color: black;">晓得</span>这些数据到底是什么</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/af2a42fb28f54960b6230bf1507cc0ff~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948906&x-signature=yU2rUOjfUVleZQUClk%2Bu56eezDU%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>在视图选项卡，点击冻结首行，<span style="color: black;">这般</span><span style="color: black;">咱们</span>数据，向下滚动的时候，就能看到第1行的标题字段了</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/32917ae3ebbf4a549a88bf9b3aad5598~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727948906&x-signature=wbMS2BuVHDu5wHOu2MfjbmWsJYk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">以上技巧，你会用几个，动手试试吧！</p>
论坛是一个舞台，让我们在这里尽情的释放自己。 谷歌网站排名优化 http://www.fok120.com/
页:
[1]