5个超级实用的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>为你分享职场办公软件<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;">微X</span>号：桃大喵学习记</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">今天跟<span style="color: black;">大众</span>分享5个超实用的Excel小技巧，<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>快速制作工资条</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;"><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;">1、先建一个辅助列，<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-axegupay5k/d7a42081a0da44dd9d12bbec535a3bb5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981830&x-signature=APXS0cuu8C8mE%2BedNXnUfQ%2FRbWE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<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/2f88790cc5d1428ab955f4630f5f7764~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981830&x-signature=nRU4ijghvvZE1i4Wrmxx3ZrqtIY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3、再单击任意一个序号单元格，在【<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/ea06fcc9924b42c0819faaab4b493d45~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981830&x-signature=rcdoxTrAg5aispVpeBoL93kAoq0%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;">2、</span>用分列纠正错误的日期格式</strong></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>【YYYY-MM-DD】与【YYYY/MM/DD】2种，其余的格式都是错误的，错误的日期格式是<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 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>点击【数据】-【分列】→在弹出的“文本分列向导”对话框中点击2次【下一步】，在第三步中将格式设置为【日期】→最后直接点击【完成】<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/d07734d6117742ee9136b68f1db555ae~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981830&x-signature=tOH1IqoZmXwlD3QXFm%2FiknPIaR0%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;">3、</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>是11位数，并且提醒：请正确输入11位手机号码！</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7b89a2d09460471ea4e20c9060293327~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981830&x-signature=M%2FI6MD0SrJr6GbS%2FvfUwixAUxXM%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 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>“文本长度”；【数据】设置“等于”11→在【输入信息】选项卡下【输入信息】中，输入“请正确输入11位手机号码！”<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/a44332ae4d744ca98f2dd0e762d9c402~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981830&x-signature=LjHFCLGO1YtrAv08NckUqdn4sVA%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;">4、</span>快速恢复E+乱码<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;"><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>快捷键【Ctrl+1】调出“单元格格式”窗口→<span style="color: black;">运用</span>自定义单元格格式，在“类型”中输入一个0，<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/e2c2ba70ee4f45e5938346667038a638~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981830&x-signature=qlaYGCMpGc1j6KZ4iSK92bXirvI%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 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>等于15位的数字有效，才<span style="color: black;">能够</span>利用自定义单元格格式，在类型中输入一个0成将数据还原。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">②当大于15位数字时，15位之后的数字会被设置成0，并且<span style="color: black;">没法</span>还原。当遇到大于15位数字时可以提前把单元格格式设置成文本。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在Excel表格中太长的数值变成E+乱码，<span style="color: black;">重点</span>是<span style="color: black;">由于</span>Excel的精度<span style="color: black;">引起</span>的。Excel表格精度<span style="color: black;">仅有</span>15位数字，并且表格对超出11位的数字会以科学计数法<span style="color: black;">暗示</span>，<span style="color: black;">针对</span>15位以外的数字，超出部分会以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;">5、</span>双击锁定格式刷，开启无限刷格式模式</strong></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>结束。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/04a710bb8a2c44458b34851845bb07d4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727981830&x-signature=dTw8dMw7rqs%2BzuPyuEMXF4SzuGY%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><span style="color: black;">一起</span>成长！</p>
你字句如珍珠，我珍藏这份情。
页:
[1]