Excel表格常用快捷键大全之21-26个（含快捷键操作演示）
<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>分享的Excel常用快捷键，这是第三篇，咱们继续。</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;">第二十一，自动生成下拉列表</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"> 看小面的下拉列表，不是用数据有效性做的哈。咱们在A1：A5单元格输入内容之后，在A6单元格，<span style="color: black;">能够</span>按下ALT+向下箭头，此时Excel<span style="color: black;">能够</span><span style="color: black;">按照</span><span style="color: black;">咱们</span>已输入过的内容自动生成下拉列表。您试试！</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>A6单元格为空，在A7单元格按下ALT+向下箭头，得到<span style="color: black;">亦</span>是一个空白的下拉框。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyXNlPmwiaO5rDzpOHq9rZqxyP2Flfd97XafZ6SMZ2gFIch1gHRd2SIl8FUuhR44Vp6B3tTv2peG8g/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"> </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;">第二十二，<span style="color: black;">选择</span>非<span style="color: black;">隐匿</span>区域</span></strong></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>了第四行。我的本意是想将A1：A5单元格区域中的可见单元格复制到<span style="color: black;">另一</span>的单元格。<span style="color: black;">倘若</span>选中A1：A5单元格区域，复制粘贴，会将<span style="color: black;">隐匿</span>的第四行<span style="color: black;">亦</span>复制进去。</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>A1：A5单元格区域，按alt+; <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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyXNlPmwiaO5rDzpOHq9rZqx81KaibG2Ku3EQkDg7ZjMPrMmhd75kV1f5WELHvvUicD79lMFibZ2SHYtA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"> </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></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"> 在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>的对齐到A1单元格的右边线和下边线。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyXNlPmwiaO5rDzpOHq9rZqxKo9xUfuicUlrlYjrpN1a9pnVzySItaK6Yob8L7TiaG14IlicEfmibHSPdw/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"> </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>按alt键再拖动，拖一两下瞬间就<span style="color: black;">能够</span>对齐了。按住ALT键拖动<span style="color: black;">能够</span><span style="color: black;">快速</span>将<span style="color: black;">照片</span>对齐到单元格边框线。</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;">第二十四~六，数字0，傲娇的主，驾驭它！</span></strong></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;">1. 让Excel<span style="color: black;">表示</span>0</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>是输入序号时数字0不<span style="color: black;">表示</span>，如<span style="color: black;">咱们</span>在A1单元格输入 “0001”按回车确认输入，结果只出现“1”，前面3个0被Excel密西了！</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>，如数字0001，则输入0001。</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;">2.不让Excel<span style="color: black;">表示</span>0</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"> 下面截图的销量，有些为0，怎么批量把数字0<span style="color: black;">表示</span>为符号“-”呢？</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyXNlPmwiaO5rDzpOHq9rZqxbYOBpgrC33ll5Tmgf8Cwd2PuNfVCTUzmL7fH8GmMaN4WGLFlYDAm7A/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"> </span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Ctrl+F调出【<span style="color: black;">查询</span>和替换】，<span style="color: black;">查询</span>数字0，勾选【单元格匹配】，<span style="color: black;">查询</span>到结果后，按Ctrl+A全选<span style="color: black;">查询</span>结果。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyXNlPmwiaO5rDzpOHq9rZqxEVwNIlGpD8T5cNOicxicsgRegY9BNLLeGnXwG6lmo7rvrzlibEcT0eP7w/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"> 按下CTRL+1，打开“设置单元格格式”，【自定义】>输入[=0]"-"，按确定<span style="color: black;">就可</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyXNlPmwiaO5rDzpOHq9rZqxQ1tXiaNIicicg9RzzLasFCkEg0Z956kvia7X0fTqyDVeXbuztJStnNXZvA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"> </span></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;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"> </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;">3.精确输入0的个数</span></strong></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">录入时数额太大，如1000000，一不小心就少了几个0，<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>方式录入，如1000000，有6个0，则录入时输入1**6<span style="color: black;">就可</span>。输入完毕，在将格式从科学记数变为常规<span style="color: black;">就可</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">新一期《Excel极速贯通班》11月4日开班，需要全面系统学习的小伙伴，加老师QQ：603830039咨询报名。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz/k6kCsib3eJMwpWOV8GqBlibDC5FTOu6icVQTy18nibI8WSqy7ugJV4K6K0dPERArlgYIIcedF4oywbd8dJJpm5fIKg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span></p>
楼主的文章非常有意义，提升了我的知识水平。
页:
[1]