F4,Excel中万能的快捷键,可惜非常多人都没用过
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在Excel中有一个非常神奇快捷键,它<span style="color: black;">便是</span>F4键,<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>完成各式各样的操作,今天<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;"><strong style="color: blue;"><span style="color: black;">想要从零学习Excel,<span style="color: black;">这儿</span>↓↓↓↓</span></strong></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p1.toutiaoimg.com/large/tos-cn-i-jcdsk5yqko/92344094cc9241428c545c589d6654fa" style="width: 50%; margin-bottom: 20px;">
<div style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">专栏</span></div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">30天Excel从入门到精通</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">作者:Excel从零到一</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">
<div style="color: black; text-align: left; margin-bottom: 10px;">39.9币</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">1,090人已购</div>
</div>
<div style="color: black; text-align: left; margin-bottom: 10px;">查看</div>
</div>
</div>
</div>
</div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">1、</span>F4键的<span style="color: black;">功效</span></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1.更改单元格引用方式</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>按下F4键来快速更改单元格的引用方式,无需手动添加美元符号来改变单元格的引用方式,非常好用的,效果如下图所示</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/cce0ecc0064a4b9f973621145fd19c31~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969734&x-signature=%2BUKdfnYHQu2etyG9b0JV43%2BNy1k%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;">2.重复上一步操作</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">F4键会记录<span style="color: black;">咱们</span>上一步操作的内容,<span style="color: black;">这般</span>的话就<span style="color: black;">不消</span>再重复设置,只需按下F4键就能批量完成,快速<span style="color: black;">加强</span><span style="color: black;">咱们</span>的工作效率,今天<span style="color: black;">咱们</span>就着重来演示下这个操作技巧</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">2、</span>删除新增行列</h1>
<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>按下F4键就能快速<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-qvj2lq49k0/eba9549b00d04c849a4fc25a2ff4b293~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969734&x-signature=OqOkR3juuR1pb%2FoayYRiUnFiGMg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">3、</span>填充颜色</h1>
<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>再选中需要填充颜色的单元格,按下F4键就能快速填充颜色了</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/2f539756f2d94042921f5dde56cf7a97~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969734&x-signature=qrVFNCy%2Fg0OfB0knKkMSWoHwE1E%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">4、</span>合并单元格</h1>
<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>再选中需要合并单元格的区域,按下F4就能快速合并单元格</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/4e1944eddd554b928e15e10a8f1c4707~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969734&x-signature=Zt9BkRikQGZlh077iOx4ixGH%2Fgw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">5、</span>更改图表颜色</h1>
<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>其他的,按下F4键就能快速设置</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/74a1b779e21f42559491699377547694~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969734&x-signature=jaQLdGwQ03wDBiZJwTa59Gho4yQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">6、</span>删除Sheet</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">只需要先删除一个Sheet,<span style="color: black;">而后</span>再选中需要删除的sheet,按下F4键就能快速删除了</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/73ce27a898f84665895723f904b142ad~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969734&x-signature=9Yrj9IcnEp97dvjAwv3mFmoF8ZU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">7、</span>设置格式</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">如下图所示,F4键<span style="color: black;">亦</span>是<span style="color: black;">能够</span>快速设置数据格式的</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/db48c142e2294a649fbff68e95bfa06a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969734&x-signature=0XYRD7EcjuK%2FSn%2FgX1%2FHqUXv%2FXI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">8、</span>填充序号</h1>
<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>另个需要填充序号的表格按下F4就能实现快速填充序号了</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/3a1bf489c4fe4ca8a99a2bb7c09c6fae~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727969734&x-signature=dm9OQ4QHlOr1NgSwxm83KfDjaH4%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>的F4的<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>F4键试一下,它真的非常好用,<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;">我是Excel从零到一,关注我,<span style="color: black;">连续</span>分享<span style="color: black;">更加多</span>Excel技巧</p>
“板凳”(第三个回帖的人)
页:
[1]