Excel有效办公秘籍：五大必须技巧解析
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">Excel<span style="color: black;">有效</span>办公秘籍：五大<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.<strong style="color: blue;"><span style="color: black;">恢复E+13<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;">当Excel中的数字<span style="color: black;">表示</span>为“E+13”这种科学记数法时，<span style="color: black;">倘若</span>需要将它们以</span><strong style="color: blue;"><span style="color: black;">常规</span></strong><span style="color: black;">的数字格式<span style="color: black;">表示</span>。此时，只需选中这些单元格，如下图所示，<span style="color: black;">而后</span>按Ctrl+1打开“设置单元格格式”对话框，在“数字”选项卡下<span style="color: black;">选取</span>“常规”或更改为【自定义】格式类型为“0”，点击“确定”后，数字就能以正常的格式<span style="color: black;">表示</span>。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/8f59e7a0cfac474eab8e4de40bde50a7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=vpTnw1lGHcBr19h3wVXa0SSLwmk%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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6a2d123164bc4efc9ac5d61909cd0b34~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=TYFLq50fYEBxnmXU0euhc1yKXDs%3D" style="width: 50%; margin-bottom: 20px;"></div><strong style="color: blue;"><span style="color: black;">快速填充空白单元格</span></strong>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">若要将空白单元格填充为上一个非空白单元格的内容，<span style="color: black;">能够</span><span style="color: black;">首要</span>定位这些空白单元格。如下图所示，<span style="color: black;">经过</span>按【Ctrl+G】打开“定位”对话框，<span style="color: black;">而后</span>单击【定位<span style="color: black;">要求</span>】，<span style="color: black;">选取</span>“空值”进行定位。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/da5587cbd68f4b779d3edf0c3b6b0792~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=cgxy4S62hg5jef8h0mxz732cjqQ%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;">接着，如下图，在ExceL编辑栏中输入公式=上一个单元格的引用（例如，<span style="color: black;">倘若</span>当前空白单元格在A3，且A2有值，则输入=A2），<span style="color: black;">而后</span>不要直接按回车，而是按【Ctrl+Enter】来批量填充所有选中的空白单元格。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f9af0d3e5a3241158689163a8a59ee10~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=VeTDA%2Fbn8ZljazvWUbpz04vj13w%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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/da8584387bc7414795cd8a56df06ff07~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=h%2F9k3iuaM2lzt6YujJTQ22xvjHc%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;">3，</span><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 style="color: black;">次序</span><span style="color: black;">同样</span>，核对数据，<span style="color: black;">选取</span>区域，按快捷键Ctrl+\</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><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+\】快捷键。这将直接选中与活动单元格内容<span style="color: black;">区别</span>的单元格，之后你<span style="color: black;">能够</span>为它们填充颜色以便识别。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/fbbf70555f11482b8683bfbd6a63c917~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=rxlx5UOq5Wql25wpL6UervnbKXw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/13151af2f40a4cafb3ebb9c69e11d7f3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=d56ECUDVjedms3SPisCyCyole%2BQ%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 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 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>单元格（例如B12），右键点击并<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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4f45e7e1f2194ef38915087bf8b69c34~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=%2BYc6tzsYsoG0f1gjDsj1ak%2BZK%2BY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/13d384513e514a83ae77cd70d3b5ab01~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=Qv9WK5qsKyg7mvML%2FQM%2Fi4VYGHc%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;">5<span style="color: black;">次序</span><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 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>标题行或合并的单元格），鼠标定位在表格中的一个单元格（例如A1），单击“数据”选项卡，点击“高级”。在弹出的“高级筛选”对话框中，如下图所示，<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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b046568add7b47219f7901a5dd5f813b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=OyvsyD1g4fqdj8NxXzLaQ5X7b5M%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 style="color: black;">而后</span>清除筛选，以便快速识别<span style="color: black;">那些</span>数据在两个列表中都有。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/586789cbabb4449cb24a77bdfd10b420~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=W20l%2BqXjvBhupQI4WawvRgDacOA%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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f12e80034e5944e68c35f997d2301b29~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727967472&x-signature=bA2kqalQn0K9i9nZHo7HNl5sSwI%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;">这些小技巧在Excel数据处理中非常实用，<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>关注【Excel老陈学堂】公众号；</span></p>
页:
[1]