不是24分钟吗，还有其他答案

步行街主干道

第一次和女生出去旅游，定好酒店后她问我定的一间还是两间是什么意思？

客观评价世界杯表现，大罗和梅西，谁更强？

珍藏的动图

进口药和国产药的效果一样吗？

你小时候做过哪些离谱的行为

据说这种饭局还有3次，不知周鸿祎有没后悔，不是一个级别的坐一起吃饭，真的会很尴尬吗？

年轻人，玩的花也要注意度 

网友爆料褚会长把红衣大叔玩的团团转啊……

人羊大战名场面。

天天说那个国家药丸，能拍出辐射，排出冰血暴第五季的国家就不可能亡，只会螺旋式上升进步

龙珠如果拍真人版，这种画风是否打动你？

到底谁在折磨谁？

给你500万，只有一次选择机会，你会怎么选？

3你发布的主帖《转帖，毁成语，差强人意，能懂吗》改成不能发帖的模样

3你发布的主帖《转帖，毁成语，插枪人溢，能懂吗》

女生会舞蹈真的很有魅力

没有被打马赛克怎么办

亚青赛冠军，在考试

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

<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表格做美容——谈谈“超级表”和“切片器” - 虎扑社区