[卧谈会]一人说一个，你读过的最狂的诗词是哪句？

步行街主干道

兄弟们，有没有便宜好喝的茶叶

12月七日重新开放。历时五年重建巴黎圣母院。‍‍动员了250多家公司，2000多名工匠，斥资约7亿欧元（53亿元）。

72斤女生和84斤男生挑战30天增重会有什么变化？

联合国公认的37个发达国家

他卖了这么多年鸡，没有人看到过他去哪里进货吗？

1985年和2024年《明天会更好》要这修音师有何用？

迫击炮炮神

救命的知识，这个得学习

她把赚到的钱放进了小熊肚子里，小熊是年轻时的向往，钱是年长后的现实，她没有错，错的是这世界，是这世界病了，她的所有动作都楚楚可怜。

轩子最美，虎扑第一女神

极限二选一，能帮我看看嘛兄弟们

有人注意到这个细节吗

班德尔城的是普遍素质低吗

中奖了但是过期了

白居易和鲁迅，谁是更加伟大的文学家？

兄弟们给点建议

请问参加单位篮球联赛，练什么可以迅速提高水平

她是谁？

轩子巨二兔太好看了

发帖三小时，看帖三分钟，大家一定好好看啊

<div data-type="normal">不，换台电脑就没了</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">——<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"></p><div style="font-family: 宋体;"><p><img src="https://i2.hoopchina.com.cn/blogfile/201911/25/BbsImg_173995720314093_1574643086_s_214041_o_w_1000_h_862_48047.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="750" data-h="646" data-imgid="ccccc18d0c87942e0b59cc9140bb6457" data-imgid="ccccc18d0c87942e0b59cc9140bb6457"></p><br><span style="font-size: 10.5pt;">二、直入主题：</span>给Excel表格美容——谈谈“超级表”和“切片器”</div><div style=""><span style="background-color: rgb(255, 255, 255);"><font face="宋体">&nbsp; &nbsp;&nbsp;</font></span><span style="font-family: tahoma, 宋体; background-color: rgb(255, 255, 255); font-size: medium;">Excel中的隔行、隔列填充、筛选、自动汇总，你一般是怎样做的？我们使用超级表来完成，可以做得更好、更快、更简洁！</span></div><p></p><div style="line-height: 21px; font-family: tahoma, 宋体; background-color: rgb(255, 255, 255);"><span style="font-size: medium;">&nbsp; &nbsp; 下图的EXCEL数据源，我们需要完成几个问题：</span></div><div><div style="line-height: 21px; font-family: tahoma, 宋体; background-color: rgb(255, 255, 255);">&nbsp;</div><div style="line-height: 21px; font-family: tahoma, 宋体; background-color: rgb(255, 255, 255); margin-left: 18pt; text-indent: -18pt;"><span style="font-size: medium;">&nbsp; &nbsp; 1）&nbsp;对表格进行隔行、隔列填充单元格颜色，方便直观的查看数据；</span></div><div style="line-height: 21px; font-family: tahoma, 宋体; background-color: rgb(255, 255, 255); margin-left: 18pt; text-indent: -18pt;"><span style="font-size: medium;">&nbsp; &nbsp; 2）&nbsp;在增加姓名数据的时候，能够实时的进行成绩汇总；</span></div><div style="line-height: 21px; font-family: tahoma, 宋体; background-color: rgb(255, 255, 255); margin-left: 18pt; text-indent: -18pt;"><span style="font-size: medium;">&nbsp; &nbsp; 3）&nbsp;需要很方便的查询某个人的某一科成绩。</span></div></div><div style="line-height: 21px; font-family: tahoma, 宋体; background-color: rgb(255, 255, 255); margin-left: 18pt; text-indent: -18pt;"><span style="font-size: medium;"><div>&nbsp; &nbsp;&nbsp;<p><img src="https://i1.hoopchina.com.cn/blogfile/201911/25/BbsImg_173995720314093_1574643236_s_69113_o_w_577_h_307_70336.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="577" data-h="307" data-imgid="5e1e2e3a8d43e9fc921dd7ef9fbff498" data-imgid="5e1e2e3a8d43e9fc921dd7ef9fbff498"></p></div><div><span style="text-indent: 0px;">&nbsp; &nbsp; 根据上面的需求，我们在EXCEL中找寻对应的功能来实现：</span></div><div style="text-indent: 0px;"><span style="text-indent: -18pt;">&nbsp;1、</span><span style="text-indent: -18pt;">选择上面所有的数据区域：A1：G13；</span></div><div><div style="font-size: 14px; line-height: 21px; margin-left: 18pt; text-indent: -18pt;">&nbsp;<span style="font-size: medium; text-indent: -18pt;">2、</span><span style="font-size: medium; text-indent: -18pt;">执行“插入——表格”，或者按下快捷键：CTRL+T，可以快速将EXCEL普通数据转换成表格，大家也经常把这个“表格”称为“超级表”；</span></div><div style="font-size: 14px; line-height: 21px; margin-left: 18pt; text-indent: -18pt;"><span style="font-size: medium; text-indent: -18pt;"><div><p><img src="https://i3.hoopchina.com.cn/blogfile/201911/25/BbsImg_173995720314093_1574643319_s_20817_o_w_419_h_147_58950.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="419" data-h="147" data-imgid="31b05c39007378bbf99bccbff87df285" data-imgid="31b05c39007378bbf99bccbff87df285"></p></div><div>3、<span style="font-variant-numeric: normal; font-stretch: normal; line-height: normal;">&nbsp;</span>弹出“创建表”对话框， 直接点击“确定”即可；<br></div><div><div><p><img src="https://i2.hoopchina.com.cn/blogfile/201911/25/BbsImg_173995720314093_1574643354_s_69243_o_w_587_h_319_19740.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="587" data-h="319" data-imgid="9e7d5ab22a0c523854bbd972e7b03217" data-imgid="9e7d5ab22a0c523854bbd972e7b03217"></p></div><div>看，现在的表格，比最初的表格是否好看了些？</div><div><div><p><img src="https://i3.hoopchina.com.cn/blogfile/201911/25/BbsImg_173995720314093_1574643391_s_70357_o_w_585_h_305_70252.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="585" data-h="305" data-imgid="eb011d51b42ede0090f70eecce455423" data-imgid="eb011d51b42ede0090f70eecce455423"></p></div><div><p class="MsoNormal" style="text-align: left;"><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">“</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">”——“</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">”</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></p><p class="MsoNormal" style="text-align: left;"><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" style="text-align: left;"><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://i3.hoopchina.com.cn/blogfile/201911/25/BbsImg_173995720314093_1574643499_s_28447_o_w_615_h_129_16139.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="615" data-h="129" data-imgid="fe2ff54c9e5274724333982d13e12303" data-imgid="fe2ff54c9e5274724333982d13e12303"></p></div><div><span style="color: rgb(255, 0, 0); text-indent: 0px; font-family: tahoma, 宋体;">提示：镶边行、镶边列，就是我们所需的隔行、隔列填充效果。还可以进一步修改填充的</span></div><div><span style="color: rgb(255, 0, 0); text-indent: 0px; font-family: tahoma, 宋体;">颜色样式。</span></div><div><span style="text-indent: 0px; font-family: tahoma, 宋体;">我们接着单击上面截图所示，左边的“插入切片器”。咱们勾选所有字段。</span></div><div><p><img src="https://i3.hoopchina.com.cn/blogfile/201911/25/BbsImg_173995720314093_1574643568_s_9888_o_w_245_h_215_33008.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="245" data-h="215" style="font-family: tahoma, 宋体; text-indent: 0px;" data-imgid="196a827d51976cf6aea24fb0dbd73d39" data-imgid="196a827d51976cf6aea24fb0dbd73d39"></p></div><div><span style="font-family: tahoma, 宋体; text-indent: 0px;">现在我们只需要在下面的“筛选器”里面点击任意数据，即可筛选。比如需要查看“熊继”的</span></div><div><span style="font-family: tahoma, 宋体; text-indent: 0px;">成绩，点击名字即可。</span></div><div><p><img src="https://i2.hoopchina.com.cn/blogfile/201911/25/BbsImg_173995720314093_1574643646_s_59142_o_w_701_h_258_29394.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="701" data-h="258" style="font-family: tahoma, 宋体; text-indent: 0px;" data-imgid="b9ec9da8b5773ff3aaa7893a7c74a7a3" data-imgid="b9ec9da8b5773ff3aaa7893a7c74a7a3"></p></div><div><span style="font-family: tahoma, 宋体; text-indent: 0px;">又比如想查看“化学”中考40分的人是谁，咱们点击在“化学”筛选器点击“40”，此时EXCEL数</span></div><div><span style="font-family: tahoma, 宋体; text-indent: 0px;">据区，就筛选出下面的效果：</span></div><div><p><img src="https://i2.hoopchina.com.cn/blogfile/201911/25/BbsImg_173995720314093_1574643683_s_81376_o_w_753_h_367_53839.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="750" data-h="367" style="font-family: tahoma, 宋体; text-indent: 0px;" data-imgid="f0f0a04ff9cdfbeebbf5b3ccd51f7c95" data-imgid="f0f0a04ff9cdfbeebbf5b3ccd51f7c95"></p></div><div><span style="text-indent: 0px; font-family: tahoma, 宋体;">提示：随着几次筛选，有时候会遇到筛选不出所需的数据，是因为咱们之前开启了其他的</span></div><div><span style="text-indent: 0px; font-family: tahoma, 宋体;">帅选器。</span><span style="text-indent: 0px; font-family: tahoma, 宋体;">每个筛选器右上角有一个按钮，如果开启的状态点击一下，就可以清除筛选器。</span></div><div><p><img src="https://i1.hoopchina.com.cn/blogfile/201911/25/BbsImg_173995720314093_1574643739_s_26623_o_w_323_h_303_81779.jpg?x-oss-process=image/resize,w_800/format,webp" data-w="323" data-h="303" style="font-family: tahoma, 宋体; text-indent: 0px;" data-imgid="e94eaca583d0f4f99160f81668cf8a40" data-imgid="e94eaca583d0f4f99160f81668cf8a40"></p></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><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></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><span lang="EN-US"><o:p></o:p></span></p><div></div><p class="MsoNormal" style="text-align: left;"><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><span style="text-indent: 0px; font-family: tahoma, 宋体;"><div><br></div><br></span></div><p></p><div><span style="text-indent: 0px;"><div><div style="font-size: 14px; line-height: 21px;">&nbsp;</div></div><br></span></div><p class="MsoNormal" style="text-align: left;"><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><span style="font-family: tahoma, 宋体; text-indent: 0px;"><br></span></div><div><span style="text-indent: 0px; font-family: tahoma, 宋体;"><div><br></div><br></span></div><p></p><div><br></div><p class="MsoNormal" style="text-align: left;"><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><p class="MsoNormal" style="text-align: left;"><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><br><br></div><br></div><div><br><br></div><br></span></div><br></div><br></span></div>

[Office不费思]第六期：给Excel表格做美容——谈谈“超级表”和“切片器”

[Office不费思]第六期：给Excel表格做美容——谈谈“超级表”和“切片器” - 虎扑社区