为什么30w左右的BBA被很多人当做智商税，销量却一直高居不下？

步行街主干道

人在北美，不懂就问：英菲尼迪这样的好车，为啥国内无人问津？

都在说美国不好，那么美国有没有干过啥好事啊

26岁的货币资产

这期踢馆歌手亚当兰伯特 啥水平？？ 

现在卖车主播都这样穿了吗？

亲，你愿意拿彩礼娶哪一个？

如何解决玄幻小说力量体系后期的大崩坏？

菏泽郭有财一首诺言走红！

准备倒闭，退出家电行业，有关家电的问题，有问必答

单纯吃瓜

请回答1988神级催泪《你不要担心》

“饥饿游戏”应于现实——“欧美”光鲜亮丽下的冷漠与悲哀

1997年27岁现状

太离谱了 真不能碰

这个跳跃什么水平？差点以为自己要凉了。

心情无比兴奋

对美国登月是真是假的舆论变化

现在看到在外网宣传我们多好多好的，我就头皮发麻。希望大家别再这样做了

把你最喜欢的漫画名字分享出来！

建议认真学习一下本期内容，都是技巧性的操作，不难但是非常好用。

如果JRs感兴趣，下期可以讲讲CODE函数。

<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:Calibri;<br>mso-ascii-theme-font:minor-latin;mso-fareast-font-family:宋体;mso-fareast-theme-font:<br>minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin">本帖分为三个部分</span><span lang="EN-US">——<o:p></o:p></span></p><br><br><p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:Calibri;<br>mso-ascii-theme-font:minor-latin;mso-fareast-font-family:宋体;mso-fareast-theme-font:<br>minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin">一、百科三连自我介绍：</span><span lang="EN-US"><o:p></o:p></span></p><p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:Calibri;<br>mso-ascii-theme-font:minor-latin;mso-fareast-font-family:宋体;mso-fareast-theme-font:<br>minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin"></span></p><div><p><img src="https://i1.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574299190_s_214041_o_w_1000_h_862_65126.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="750" data-h="646" data-imgid="5114f64ea3126df8f882e7a6e77353f9" data-imgid="5114f64ea3126df8f882e7a6e77353f9"></p><br></div><p></p><p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:Calibri;<br>mso-ascii-theme-font:minor-latin;mso-fareast-font-family:宋体;mso-fareast-theme-font:<br>minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin">二、直入主题：</span>Excel中Alt键十大技巧，至少让你看起来像是大神！</p><p class="MsoNormal">1、Alt + Enter：单元格内换行</p><p class="MsoNormal"></p><div><p><img src="https://i2.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574299397_s_29469_o_w_542_h_441_8794.gif?x-oss-process=image/resize,w_800/format,webp" data-w="542" data-h="441" data-imgid="71612a463029f1378d7248cdd44a145a" data-imgid="71612a463029f1378d7248cdd44a145a"></p><br><br></div><div>2、Alt + =：快速求和</div><div><span style="font-family: tahoma, 宋体; font-size: medium; text-align: justify; background-color: rgb(255, 255, 255);">选中要汇总求和的单元格区域和与其相邻的行或列或二者兼得，同时按Alt键和=键，即可完成批量输入SUM函数汇总求和。</span><br></div><div><span style="text-align: justify; background-color: rgb(255, 255, 255);"><div style="font-family: tahoma, 宋体; font-size: medium;"><p><img src="https://i2.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574299637_s_40595_o_w_546_h_375_42451.gif?x-oss-process=image/resize,w_800/format,webp" data-w="546" data-h="375" data-imgid="c45cc7b94c21724bc1890c50de82e9b5" data-imgid="c45cc7b94c21724bc1890c50de82e9b5"></p></div><div style="font-family: tahoma, 宋体; font-size: medium;"><br></div><div style="font-family: tahoma, 宋体; font-size: medium;">3、<span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;">Alt + Page Up/Page Down：左右方向滚屏</span></div><div style="font-family: tahoma, 宋体; font-size: medium;">按PgDn键可以向下滚屏，而同时按Alt键和PgDn键可以向右滚屏；同理，按PgUp键可以向上滚屏，而同时按Alt键和PgUp键可以向左滚屏。<span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;"><br></span></div><div style=""><div style="font-family: tahoma, 宋体; font-size: medium;"><p><img src="https://i2.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574299793_s_53674_o_w_546_h_413_92956.gif?x-oss-process=image/resize,w_800/format,webp" data-w="546" data-h="413" data-imgid="b27aceb4b9c37379f589319badbf467d" data-imgid="b27aceb4b9c37379f589319badbf467d"></p></div><div style="font-family: tahoma, 宋体; font-size: medium;"><br></div><div style="font-family: tahoma, 宋体; font-size: medium;">4、<span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;">Alt + D</span><span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;">&nbsp;</span><span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;">+</span><span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;">&nbsp;P：</span><span style="font-size: 14px;"><span style="font-size: medium;">调用数据透视表向导</span></span></div><div style=""><span style="text-align: start;"><div style="font-family: Arial, Helvetica, sans-serif; font-size: 14px;"><p><img src="https://i2.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574299872_s_73757_o_w_546_h_448_56735.gif?x-oss-process=image/resize,w_800/format,webp" data-w="546" data-h="448" data-imgid="56216cd811ea1d2f5cc9ea6db70c5973" data-imgid="56216cd811ea1d2f5cc9ea6db70c5973"></p><br><br></div><div style="font-family: Arial, Helvetica, sans-serif; font-size: 14px;">5、Alt + ↓：<span style="font-family: tahoma, 宋体; font-size: medium; text-align: justify;">快速简易下拉选项表</span></div><div style=""><span style="text-align: justify;"><div style="font-family: tahoma, 宋体; font-size: medium;"><b><p><img src="https://i3.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574299967_s_20205_o_w_546_h_375_48987.gif?x-oss-process=image/resize,w_800/format,webp" data-w="546" data-h="375" data-imgid="7ea384d30eeaf8dfeba650ab61c3701c" data-imgid="7ea384d30eeaf8dfeba650ab61c3701c"></p></b><br><br></div><div style="font-family: tahoma, 宋体; font-size: medium;">6、<span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;">Alt + 字符代码：输入特殊字符</span></div><div style="font-family: tahoma, 宋体; font-size: medium;">许多特殊字符在键盘上无法直接找到，而用输入法去找特殊字符又降低了速度，此愁何计可消除？当Alt与数字相遇，一切便迎刃而解。例如：按住alt依次输入41446，会输出℃；按住alt依次输入41409，会输出×；按住alt依次输入41420，会输出✔。</div><div style="font-family: tahoma, 宋体; font-size: medium;">注意此处的数字都要从小键盘输入。<span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;"><br></span></div><div style=""><div style="font-family: tahoma, 宋体; font-size: medium;"><p><img src="https://i1.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574300234_s_104493_o_w_609_h_399_76429.gif?x-oss-process=image/resize,w_800/format,webp" data-w="609" data-h="399" data-imgid="892c3da567e9e1b78d8aafcb8824207a" data-imgid="892c3da567e9e1b78d8aafcb8824207a"></p></div><div style="font-family: tahoma, 宋体; font-size: medium;">至于如何查询特殊字符的代码，这个需要用到CODE函数，JRs如果感兴趣可以放到下期讲。</div><div style="font-family: tahoma, 宋体; font-size: medium;"><div><p><img src="https://i3.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574300380_s_7561_o_w_418_h_321_43601.png?x-oss-process=image/resize,w_800/format,webp" data-w="418" data-h="321" data-imgid="606f75a218b9198cab891a7e56465f60" data-imgid="606f75a218b9198cab891a7e56465f60"></p><br><br></div><div>7、<span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;">Alt + 鼠标左键：</span><span style="font-size: 14px;"><span style="font-size: medium;">跨表拖动单元格区域</span></span></div><div><p><img src="https://i1.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574300557_s_103495_o_w_789_h_415_81065.gif?x-oss-process=image/resize,w_800/format,webp" data-w="789" data-h="415" data-imgid="f0c3856385d9f4f3c7500152b812b763" data-imgid="f0c3856385d9f4f3c7500152b812b763"></p><br></div></div><div style="font-family: tahoma, 宋体; font-size: medium;"><div><br></div><div>8、<span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;">Alt + ；：</span><span style="font-size: 14px;"><span style="font-size: medium;">选中可见单元格</span></span><br></div></div><div style="font-family: tahoma, 宋体; font-size: medium;">部分行或列被隐藏不可见的情况下，仅针对与可见单元格的部分跨行列经常会“城门失火，殃及池鱼”，如何避免这种低级错误呢？那就是按&lt;Alt+;&gt;来选中这些可见单元格，方能做到精确打击！<span style="font-size: 14px;"><span style="font-size: medium;"><br></span></span></div><div style=""><div style="font-family: tahoma, 宋体; font-size: medium;"><p><img src="https://i2.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574300685_s_144799_o_w_542_h_441_94476.gif?x-oss-process=image/resize,w_800/format,webp" data-w="542" data-h="441" data-imgid="df82643476bb7ed1698af79c917feeec" data-imgid="df82643476bb7ed1698af79c917feeec"></p></div><div style="font-family: tahoma, 宋体; font-size: medium;"><br></div><div style="font-family: tahoma, 宋体; font-size: medium;">9、<span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;">Alt + Ctrl + V：</span><span style="font-size: 14px;"><span style="font-size: medium;">选择性粘贴</span></span></div><div style=""><div style="text-align: start;"><div><p><img src="https://i1.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574300803_s_148287_o_w_546_h_413_32984.gif?x-oss-process=image/resize,w_800/format,webp" data-w="546" data-h="413" data-imgid="ef20f14a4735d7803dd6a316e9f749e1" data-imgid="ef20f14a4735d7803dd6a316e9f749e1"></p></div><div><br>10、<span style="font-family: tahoma, 宋体; text-align: justify;"><span style="font-size: medium;">Alt键的无限可能性</span></span></div><div><span style="font-family: tahoma, 宋体; font-size: medium; text-align: justify;">打开任意工作簿，按alt键，此时在功能区的标签和快速访问工具栏的按钮上将会显示特定按键，此时，点击对应的按键，即可调用该功能。继续点击对应按键即可调用该选功能区中的功能或继续显示明细功能按键，以此类推。例如</span>Alt + H + M&nbsp;+ M：<font face="tahoma, 宋体" size="3">居中。</font></div><div><font face="tahoma, 宋体" size="3"><div><p><img src="https://i1.hoopchina.com.cn/blogfile/201911/21/BbsImg_173995720314093_1574300929_s_275755_o_w_546_h_483_98164.gif?x-oss-process=image/resize,w_800/format,webp" data-w="546" data-h="483" data-imgid="d3b4d8c1da171542a65e8d94e4a1044d" data-imgid="d3b4d8c1da171542a65e8d94e4a1044d"></p></div><div><p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:Calibri;<br>mso-ascii-theme-font:minor-latin;mso-fareast-font-family:宋体;mso-fareast-theme-font:<br>minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin">三、感谢观看，祝各位</span><span lang="EN-US">JRs</span><span style="font-family:宋体;mso-ascii-font-family:Calibri;<br>mso-ascii-theme-font:minor-latin;mso-fareast-font-family:宋体;mso-fareast-theme-font:<br>minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin">早日上街薪、提街车，走上人生巅峰。也欢迎</span><span lang="EN-US">JRs</span><span style="font-family:宋体;mso-ascii-font-family:Calibri;<br>mso-ascii-theme-font:minor-latin;mso-fareast-font-family:宋体;mso-fareast-theme-font:<br>minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin">提出意见或者建议，谢谢！</span><span lang="EN-US"><o:p></o:p></span></p><br></div><br></font></div><br></div><br></div><br><br></div><br></div></span></div></span><span style="font-family: Arial, Helvetica, sans-serif; font-size: 14px; text-align: start;">&nbsp;</span></div><div style="font-family: tahoma, 宋体; font-size: medium;"><br></div><br></div><div style=""><div style="text-align: start;"><br></div><br></div><br></span></div><br><p></p><p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:Calibri;<br>mso-ascii-theme-font:minor-latin;mso-fareast-font-family:宋体;mso-fareast-theme-font:<br>minor-fareast;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin"><br></span></p><div></div>

[Office不费思]第四期：Excel中Alt键十大技巧，带你装X带你飞！

[Office不费思]第四期：Excel中Alt键十大技巧，带你装X带你飞！ - 虎扑社区