办公室必须的Excel工作表技巧，简单易学，效率优先
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/843d8fb07bd34a51bb70f6ed8550b1ed~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982642&x-signature=qHuekc9QD2kdWVsq9eiDda9ub8U%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>自己的Excel工作表技巧不到位，那别人下班，自己就只能加班呢……<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;">1、</span>Excel工作表技巧：批量修改工作表。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/0d0929ea8ee44eb5ae0ec935d9960386~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982642&x-signature=HvsMillVmGI0LYL%2FVrY53MHXKHw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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;">借助Ctrl键选定Excel工作表，修改单元格的内容，<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;"><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>要修改Excel工作簿中的所有工作表，<span style="color: black;">亦</span><span style="color: black;">能够</span>结束Shift键快速选中所有工作表，<span style="color: black;">办法</span>为，按住Shift键，单击<span style="color: black;">第1</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;"><span style="color: black;">2、</span>Excel工作表技巧：<span style="color: black;">照片</span>自动对齐网格线。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/8e38a1b8c81743469ce4e8da42203699~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982642&x-signature=tR4piJMnpS4JQa3tOZoKY6jxj3Y%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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;">按住Alt键，拖动<span style="color: black;">照片</span>至单元格区域，<span style="color: black;">倘若</span>有部分边框未对齐，按住Alt键不放，继续拖动照片边框<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;"><span style="color: black;">3、</span>Excel工作表技巧：批量换行。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/ee40f66601784fb08fc5db1a1e6d981f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982642&x-signature=uDSLU2PFkdELdZsd9uD5dW1ZuOE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>单元格区域，快捷键Ctrl+H打开【<span style="color: black;">查询</span>和替换】对话框，在【<span style="color: black;">查询</span>内容】中输入字段分隔符，在【替换为】中按下快捷键Ctrl+J，【<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;"><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>决定，<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;"><strong style="color: blue;"><span style="color: black;">4、</span>Excel工作表技巧：按指定颜色筛选数据。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/57ff44bdac084cf6b6305b14091b74c3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982642&x-signature=%2ByGZqC02u%2FsDHEJGeD36FB82KYY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>单元格处右击，【筛选】-【按所选单元格的颜色筛选】。</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>外，<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;"><span style="color: black;">5、</span>Excel工作表技巧：一键<span style="color: black;">表示</span>所有公式。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/c3edda9d4fb648ccbc62fada6e065c95~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982642&x-signature=fHBVZcLPlQIoAa3U2niqWD5cazA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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;">选定工作表中的任意单元格区域，快捷键Ctrl+~<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;"><span style="color: black;">诠释</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">快捷键Ctrl+~在<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;"><strong style="color: blue;"><span style="color: black;">6、</span>Excel工作表技巧：分段<span style="color: black;">表示</span><span style="color: black;">tel</span>号码。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/7cce7b0698434a7498a70b1149f25f64~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982642&x-signature=%2Btg9vZinPFNBa1OLfXMkmpblWYU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>单元格区域，快捷键Ctrl+1打开【设置单元格格式】对话框，<span style="color: black;">选取</span>【<span style="color: black;">归类</span>】中的【自定义】，并在【类别】中输入：000 0000 0000，【确定】<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;"><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>借助Text函数实现。</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;">7、</span>Excel工作表技巧：恢复“科学计数法”的值。</strong></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/f120663656374b078ed33255864519bd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982642&x-signature=TJLYx%2FsBzsOGLi0kG42XxxtGtiQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<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>单元格区域，快捷键Ctrl+1打开【设置单元格格式】对话框，<span style="color: black;">选取</span>【<span style="color: black;">归类</span>】中的【自定义】，并在【类别】中输入：0，【确定】<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;"><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>数值长度超过15位，则恢复后的数字第15位以后的会被0替代，在<span style="color: black;">实质</span>的应用中要<span style="color: black;">重视</span>区别对待。</p>
可以发布外链的网站 http://www.fok120.com/ 我赞同你的看法，你的智慧让人佩服，谢谢分享。
页:
[1]