论坛 › 产品发布 › 学会这8个超实用的Excel技巧！办公效率咻的一下上去了

qzmjef 发表于 2024-10-1 14:42:45

学会这8个超实用的Excel技巧！办公效率咻的一下上去了

    <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>Excel制作表格的时候，<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>Excel技巧吗？我整理了8个超实用的技巧，学会之后老板都夸你办公效率<span style="color: black;">加强</span>啦。</p>

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/ffa55033002e4b6f9c3d60864b290802~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=KGeTOfLQRBw%2FeaF8nZmIFXk9VXk%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">快捷键</strong></span></p>
    <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>，好方便。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">Alt+Enter-</strong><strong style="color: blue;">自动换行</strong></p>
    <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>按下<strong style="color: blue;">【</strong><strong style="color: blue;">Alt</strong><strong style="color: blue;">】</strong><strong style="color: blue;">+</strong><strong style="color: blue;">【</strong><strong style="color: blue;">Enter</strong><strong style="color: blue;">】</strong>就<span style="color: black;">能够</span>啦。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/c6d41292cd3643188a02304cef9ffdf1~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=EGBX7h1WIYb3eLKm%2BxiAIDSRVQ8%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">Ctrl+F-</strong><strong style="color: blue;"><span style="color: black;">查询</span>和替换</strong></p>
    <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>试试【Ctrl】+【F】键，<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;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/af9fb0a0aa0344f0b487ce04788c3c52~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=ciZBUhRarEJiOsDSVn11keD1wgQ%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">选取</span>性粘贴</span></strong></p>
    <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>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">转置</strong><strong style="color: blue;">-</strong><strong style="color: blue;">将横排数据变竖排</strong></p>
    <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>这个<span style="color: black;">办法</span>。下面就以将横排数据转成竖排数据为例进行展示。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中要转换方向的数据，按下【Ctrl】+【C】进行复制，<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>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/6bafbd3b80d3484eadec9b663547f8e4~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=Db%2B0mi5qYHul72qTyPE0iIQFYeo%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">粘贴运算</strong><strong style="color: blue;">-</strong><strong style="color: blue;">核对两个表格数据的差异</strong></p>
    <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>【运算】下方的【-】点击【确定】。</p>
    <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>【0】，有其它数字，<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;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/471c00cf3eb8486c96ae683eda92b72a~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=nysL4KVyjV5ClWpVGVNPw5Mr0UY%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">照相机</strong></span></p>
    <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>把照相机找出来。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/18972b94e8f5482682f7c1446757b585~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=Ss2ClUdf%2FCSq08hiKFBTTwSVgqA%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">截图</strong></p>
    <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>截图了。用这种<span style="color: black;">办法</span>截取的<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;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/6fc0081396bf486880a72dba88dfffa4~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=HpSxl18vQmes4GLI0Q8AXf6FIAM%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <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>转成数据放回Excel里，<span style="color: black;">能够</span>借助<span style="color: black;"><strong style="color: blue;">全能</strong><strong style="color: blue;">PDF</strong><strong style="color: blue;">转换助手</strong></span>，它不仅<span style="color: black;">能够</span>对PDF进行转换处理，还有许多其他的实用工具，例如：文字识别、文字转语音、<span style="color: black;">照片</span>翻译、视频压缩等。它的<span style="color: black;">照片</span>转文字工具就<span style="color: black;">能够</span>将<span style="color: black;">照片</span>内容提取到Excel里。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">打开<strong style="color: blue;"><span style="color: black;">全能PDF转换助手</span></strong>，点击【文字识别】，<span style="color: black;">选取</span>【<span style="color: black;">照片</span>转Excel】，添加要转换的<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>输出为Excel，<span style="color: black;">因此</span><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;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/067c68c228bd43bdadf63e3b9329fb09~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=9YD0zl7Y2xvBLcdnNWQ%2FIbHMUcA%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">数据</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">调节</span>不规则日期</strong></p>
    <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>【YMD】，点击【完成】<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>不适用于含有文字的日期，例如：2022年10月2日；<span style="color: black;">亦</span>不适用于画风和其它日期不<span style="color: black;">同样</span>的，例如其它日期是：22.10.2，排序方式是年月日，<span style="color: black;">那样</span>2.10.22这种排序方式是日月年的日期，<span style="color: black;">亦</span><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;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/53c56191b50b4bc5b363463b33f59751~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=GfK6elRdoFvjnW6C5FU99ZbzrYw%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">拆分单元格内容</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">拆分单元格内容不难操作，用【分列】就能搞定。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">选中要拆分的单元格，点击【数据】，<span style="color: black;">选取</span>【分列】，点击【下一步】直接进入第2步，设置分隔符号，点击【下一步】，<span style="color: black;">选取</span>【<span style="color: black;">目的</span>区域】，<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;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/78bd3f56725a4d078deac0ee30a31c77~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=7TrXjtTFaXP2wEupFhabkk%2FMKtU%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">函数</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">合并单元格内容</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">双击选中一个空白的单元格，输入【=】选中要合并内容的单元格，单元格之间<span style="color: black;">运用</span>【&amp;】进行分割，例如：（=B9&amp;C9&amp;D9&amp;E9），<span style="color: black;">而后</span>按下【Enter】键，开头选中的空白单元格就会<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>想进行计算，<span style="color: black;">能够</span>将【&amp;】换成【+】、【-】等符号。</p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/4f2ee7ba33aa4aab8d9260a8e6916e02~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968863&amp;x-signature=tPFKw4KK0MPJTeWF9bxCcrwe7JY%3D" style="width: 50%; margin-bottom: 20px;"></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">以上<span style="color: black;">便是</span>今天分享的8个Excel实用技巧，学会了的话工作效率咻的一下就上去啦。<span style="color: black;">大众</span>有需要的话就跟着上面的<span style="color: black;">过程</span>试一试操作吧。</p>

j8typz 发表于 2024-10-7 00:47:37

感谢您的精彩评论，为我带来了新的思考角度。

4zhvml8 发表于 2024-10-20 19:14:06

外贸网站建设方法 http://www.fok120.com/

m5k1umn 发表于 2024-10-24 11:09:14

期待与你深入交流，共探知识的无穷魅力。

查看完整版本: 学会这8个超实用的Excel技巧！办公效率咻的一下上去了