Excel工作表中必须把握的20个技巧，直接套用，方便快捷
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/3d47fca77fa24592b5cb404b55a79c40~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=vkmk6rykvBejPp5uyDspt2%2FS6%2Bg%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工作表技巧：<span style="color: black;">不消</span>公式，快速提取身份证号码中的出生年月。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>快捷键Ctrl+E。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/6e5b7b702f104cff988c5e220b8dc79c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=fb%2BQAAlEyNWNc%2BSpkCqjB%2FCpgUY%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;">第1</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;">第1</span>个<span style="color: black;">已然</span>输入值的单元格），快捷组合键Ctrl+E<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+E仅在Excel的2016及更高版本中<span style="color: black;">运用</span>，当然在高版本的WPS中<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;">2、</span>Excel工作表技巧：批量删除空行。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>定位+删除。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/5f26404c30d14308b428342c7ab43f51~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=xEf%2FQxESFg%2B2RYthSnMUMyIeai4%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;">1、选定<span style="color: black;">目的</span>单元格区域，快捷键Ctrl+G打开【定位】对话框，单击【定位<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;">2、在任意选中的单元格中右键-【删除】，打开【删除】对话框，<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>选入待操作区域。</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>
<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;">工具：</strong>取消合并+定位+批量填充。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/489b2f7fa9f2488795ffb94393034001~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=hYXC2OSBSUBrpftC%2Bu6C4%2BHd2aI%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;">1、选中<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;">2、快捷键Ctrl+G打开【定位】对话框，单击【定位<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;">3、输入公式：=B3并Ctrl+Enter填充。</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;">第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;">4、</span>Excel工作表技巧：行列快速求和。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>快捷键Alt+=。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">目的：</strong>按“季度”和<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/pgc-image/61dca0f094304c30b15ec226ad909079~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=E%2BDcg44I%2BE4sBWxuy0p9noeGF48%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>单元格区域，快捷键Alt+=<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;">快捷键Alt+=<span style="color: black;">能够</span>看成是Sum函数的快捷键，对任何指定的区域快速求和。</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工作表技巧：让工作表的每一页都打印标题行。</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>给第二页至最后一页添加打印标题行。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>打印标题。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/15a2fec93ec74554853adfb579a607ee~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=K0iKE0%2F8yjEr4LVepJOLX%2F7SNhQ%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>需要打印的行，并单击箭头返回、【确定】<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工作表技巧：单色打印。</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>页面设置。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/6730a64483d542819a1048dc0e04aee7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=ZpA9CGFD65P3Ouc5KNg7peoJESg%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>【工作表】标签，<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;">7、</span>Excel工作表技巧：快速制作一级下拉菜单。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>数据验证。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/0370042be5634cce8d0d520f191afc33~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=AbkcW7Cq5El2JSk3GxMj7kphtgA%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>单元格区域，【数据】-【数据验证】，打开【数据验证】对话框，<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;">诠释</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>。</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;">8、</span>Excel工作表技巧：批量替换“0”值。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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;"><strong style="color: blue;">目的：</strong>将“0”值替换为空值。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/01a76ef82a624d568129743c0567730f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=mzIJtva4BJDs5DLuxG66SFhOrco%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>内容】中输入“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;"><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>不进行【单元格匹配】，则在替换时会将所有的“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;"><strong style="color: blue;"><span style="color: black;">9、</span>Excel工作表技巧：快速统计单元格的个数。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong><span style="color: black;">查询</span>和替换。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/51bd0d9de1134400ae511820b0434054~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=9fKhGAnNnR1NaoSdtjHvL6%2BoGdg%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>任意<span style="color: black;">目的</span>单元格区域，快捷键Ctrl+F打开【<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;">诠释</span>：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、<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;">2、相应单元格的个数<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;">十、Excel工作表技巧：将对应的日期转换为星期。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>自定义单元格格式。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/9a17da2bc33f412a909174995513cab5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=2Z4UK%2FUZjTPcK0TBI0AKJ%2BbYWxw%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>】中的【自定义】，并在【类型】中输入：aaaa并【确定】。</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;">代码aaaa<span style="color: black;">表率</span>长星期，即星期X，aaa<span style="color: black;">表率</span>短星期，即X，<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;">1、</span>Excel工作表技巧：批量删除<span style="color: black;">照片</span>。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>定位。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/14f9835216f84e73844e9b233c2254d1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=1J1wznqlxL9CF4rsFzu0%2B303IQA%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+G，打开【定位】对话框，单击【定位<span style="color: black;">要求</span>】，打开【定位<span style="color: black;">要求</span>】对话框，<span style="color: black;">选取</span>左下角的【对象】命令，并【确定】，按Delete键删除<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>形状、箭头、SmartArt等对象。</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工作表技巧：批量设置手机号格式为容易阅读的格式。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>自定义格式。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/1ac5c850b8b642de89863408157385ea~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=YDOHBDQXYROPzaVrXrzWFgGypz0%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并【确定】。</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;">【类型】中的代码除了“000 0000 0000”外，还<span style="color: black;">能够</span>是“000-0000-0000”等。</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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong><span style="color: black;">选取</span>性粘贴。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/c0a35e02bbfa4838b1a1155ee7001e4f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=fCSwf23bzlKh77YHbFqXdza6yco%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+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>【运算】中的【加】并【确定】<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>类似。</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>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong><span style="color: black;">选取</span>性粘贴。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/06176b6ba1f746168d07717758e09957~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=EIUydi2nd2UyJy1r0YxIbmyvVpw%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;">在任意空白单元格中输入1，并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>【运算】中的【乘】并【确定】<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>辅助值为1，运算【乘】、【除】均可；<span style="color: black;">倘若</span>辅助值为0，运算【加】、【减】均可。</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>手机号中间4位。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>Ctrl+E。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/fa773fb04a6f4fa2a8e164e14d2d5528~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=lPN91KVIx%2F5wzShl3mgtG75nSrE%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;">1、</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>输入值的第二个单元格区域），快捷键Ctrl+E<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>中间值。</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工作表技巧：限制单元格字符长度。</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>数据验证。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/9b2e79a4e3fc4b8c88f60287167ee97e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=0uC96WldLE%2BtA2eP78plCCDJoVM%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;">1、选定<span style="color: black;">目的</span>单元格区域，【数据】-【数据验证】，<span style="color: black;">选取</span>【<span style="color: black;">准许</span>】中的【文本长度】，【数据】中的【等于】，并在【长度】中输入11。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、单击【出错警告】标签，输入【标题】和【错误信息】并【确定】。</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;">手机号长度为11位，身份证号码长度为18位，在<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;">7、</span>Excel工作表技巧：快速筛选。</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>快速筛选功能。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>筛选。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p9-sign.toutiaoimg.com/pgc-image/c204bcb870264f08bbea3c8531d13db9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=F%2BgdfaCBGFKThbqOK23lnZg%2BrFI%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><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>【按所选单元格的颜色筛选】、【按所选单元格的字体颜色筛选】、【按所选单元格的图标筛选】。</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;">8、</span>Excel工作表技巧：快速将相同填充色的单元格聚在<span style="color: black;">一块</span>。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>排序。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/4a2d520254684d17a0e86d41f417fb0e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=qwMDiVQ8UkZS8rk2O7Tlct%2BaI9I%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>【排序】中的【将所选字体颜色放在最前面】。</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;">9、</span>Excel工作表技巧：清除所有格式。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>清除格式。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/f270369a841c49fc865ae6bdbcecf1a7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=97yguK%2BP6%2Bvm4W7g2MMmWtptZwM%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>单元格区域，<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>】菜单栏的最右侧。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">二十、Excel工作表技巧：快速提取不重复值。</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">工具：</strong>删除重复值。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/ff6c257d8abc4700af26bede650dc9fd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727968826&x-signature=LZf4nMT0WUVvWm9oUuncEJe1mYs%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>单元格区域，【数据】-【删除重复值】，打开【删除重复项警告】对话框，<span style="color: black;">选取</span>【以当前选定区域排序】，并【删除重复项】-【确定】<span style="color: black;">就可</span>。</p>
页:
[1]