查询啦!chaxun.la
轻松做好关键词规划和内容创作已被0人收藏
&[android]高清盒连接nas的片子，无法使用字幕。
来自：保密
us b外接没问题，网络盘不行，有什么解决方法？
-==发送自:宽带山官方Android应用==-
-------------------------------------------------------------------------------------------
多大个事，我还以为抢鸡蛋呢！
...楼主...
来自：保密
-------------------------------------------------------------------------------------------
多大个事，我还以为抢鸡蛋呢！
来自：保密
发帖：17＋6389
你用什么播放软件？
-------------------------------------------------------------------------------------------
来自：保密
发帖：247＋1701
基本是播放器的问题
-------------------------------------------------------------------------------------------
来自：保密
你用什么播放软件？系统自带，也不知道是啥？
-------------------------------------------------------------------------------------------
多大个事，我还以为抢鸡蛋呢！
来自：保密
发帖：256＋19793
字幕文件和视频文件名严格一致了吗？包括字母大小写！
美如画R5表示连nas没问题
-------------------------------------------------------------------------------------------
来自：保密
字幕文件和视频文件名严格一致了吗？包括字母大小写！美如画R5表示连nas没问题同样的文件，外接U盘就没问题。海美迪q5，还有一台杰科蓝光机，都这样。
-------------------------------------------------------------------------------------------
多大个事，我还以为抢鸡蛋呢！
来自：保密
发帖：198＋1883
遇到同样问题。
我是播放接在路由器上的移动硬盘中的电影，字幕无法自动加载。
-------------------------------------------------------------------------------------------
这个家伙很懒，什么也没留下......
来自：保密
发帖：17＋6390
请用 ES文件管理器+MXplayer 组合试试
android 的网络邻居播放总规有点不舒服。
-------------------------------------------------------------------------------------------
来自：保密
请用 ES文件管理器+MXplayer 组合试试android 的网络邻居播放总规有点不舒服。嗯，本来想直接连接网络盘看片，现在还得考出来，太麻烦。
-------------------------------------------------------------------------------------------
多大个事，我还以为抢鸡蛋呢！
来自：保密
找到一个方法，系统自带的文件管理器，右上角有个网络盘映射，用这个打开nas文件，字幕可加载。
-------------------------------------------------------------------------------------------
多大个事，我还以为抢鸡蛋呢！
...10楼...
来自：保密
发帖：14＋216
dlna这个协议当初就没考虑字幕的问题 lz可以考虑用其他共享协议
-=此贴发送自[wap]=-
-------------------------------------------------------------------------------------------
啊嚏，好大的一个喷嚏啊，哦，原来是你在想我了啊。
...11楼...
来自：保密
发帖：9＋723
DLNA协议 不能加载外挂字幕，改用SMB或NFS协议
-------------------------------------------------------------------------------------------
神即道，道法自然，如來！
...12楼...
首先，请你以一种，团成一个团的姿势，然后，慢慢地比较圆润的方式，离开这座让你讨厌的城市，或者讨厌的人的周围首先，请你以一种，团成一个团的姿势，然后，慢慢地比较圆润的方式，离开这座让你讨厌的城市，或者讨厌的人的周围
[android]高清盒连接nas的片子，无法使用字幕。
数码影像推荐
最新二手发布
扫描关注官方微信
扫描下载客户端
奖励分值：您今日还有 3 点分值可以奖励 [ 20 点奖分可自动换取 1 点PP]
请输入4位有相同表情的数字
&违反国家法律&&&&&&&&&含有色情内容
&对他人进行恶意攻击
&散布广告以及其它商业化的宣传
&干扰或混乱kds宽带山网络服务
&发布任何包含种族、 性别、宗教歧视性和猥亵性的信息内容
&恶意刷屏&&&&&&&&&&&&&&&内容重复&&&&&&&&&&&&&&&攻击管理员
&本人要求删除&&&&&&&&当事人要求删除
&与主题无关&&&&&&&&&&&水贴软文&&&&&&&&&&&涉及敏感政治内容
&被要求删除，你懂的&&&&&&&&&&&盗号并发布违规或广告内容
扣除hp值：
宽带山警务室
&恶意刷屏&&&&&&&&&水贴软文
&违反国家法律
&含有色情内容
&对他人进行恶意攻击
&散布广告以及其它商业化的宣传
&干扰或混乱kds宽带山网络服务
&发布任何包含种族、 性别、宗教歧视性和猥亵性的信息内容
&网页不能打开
&图片不能显示
已报名参加的人员:&figure&&img src=&https://pic2.zhimg.com/v2-44f18e2c2e4abe6d5d14_b.jpg& data-rawwidth=&1618& data-rawheight=&1080& class=&origin_image zh-lightbox-thumb& width=&1618& data-original=&https://pic2.zhimg.com/v2-44f18e2c2e4abe6d5d14_r.jpg&&&/figure&&p&香港的饮食生态多样，但每次去最喜欢的，还是那些经营数十年以上的小食店，享受美食的同时，还可以最直接的体验香港本地风情。&/p&&p&国庆假期又去了一次，惊喜的发现这里慢慢回复到那个没有扫货团满街横飞，去餐厅不用人挤人，出门左转就能吃到美食的迷人城市。以前在知乎写过香港的餐厅推荐，这次重新整理了八家，大部分店我每次去都会光顾，希望你们也会喜欢，以下原文发于我的公众号「味之道」。&br&&/p&&p&&strong&No.1：去香港，总要来一碗清汤腩 &/strong&&/p&&p&&strong&九记牛腩
经营时间：九十年以上&/strong&&/p&&p&在香港提到清汤腩，应该无人不知九记。说是清汤腩，但并不意味着把牛肉丢到水里炖就好，汤头的调味也很重要。九记的汤头，用牛肋筒骨加上陈皮，草果等香料熬成，老板曾在一次采访中提到，&strong&店里还会因季节温度的不同调整香料配比&/strong&。&br&&/p&&p&&figure&&img src=&https://pic2.zhimg.com/v2-3bd0d0bd14ff34355fbe1_b.jpg& data-rawwidth=&2480& data-rawheight=&2479& class=&origin_image zh-lightbox-thumb& width=&2480& data-original=&https://pic2.zhimg.com/v2-3bd0d0bd14ff34355fbe1_r.jpg&&&/figure&他们家的汤头呢，相比别家清汤腩，&strong&牛肉味明显更浓郁&/strong&，余味中有淡淡的香料香，牛腩一般有崩沙腩和爽腩两种，崩沙腩要去的早才有。&br&&/p&&p&&figure&&img src=&https://pic2.zhimg.com/v2-57f534b104db6b33cefebc6fdce72a09_b.jpg& data-rawwidth=&3724& data-rawheight=&2468& class=&origin_image zh-lightbox-thumb& width=&3724& data-original=&https://pic2.zhimg.com/v2-57f534b104db6b33cefebc6fdce72a09_r.jpg&&&/figure&老香港们现在去九记，有不少都是为了另一款咖喱牛腩粉。九记的&strong&咖喱&/strong&熬的非常好，&strong&浓郁醇香&/strong&中略带一点辣，强烈推荐半筋半肉的版本，&strong&牛筋软糯绵滑&/strong&，牛腩吸饱了咖喱的汁水。&br&&/p&&figure&&img src=&https://pic1.zhimg.com/v2-dad8ecd6eb12fefc_b.jpg& data-rawwidth=&3524& data-rawheight=&2335& class=&origin_image zh-lightbox-thumb& width=&3524& data-original=&https://pic1.zhimg.com/v2-dad8ecd6eb12fefc_r.jpg&&&/figure&&p&&strong&小贴士：&/strong&&/p&&p&九记中午十二点半开门，现在依然很多人排队，下午两点左右过去人比较少，我在晚餐时去过一次，但河粉已经卖光，去的时候要把握好时间。&/p&&p&地址：中环歌赋街21号&/p&&p&&strong&No.2：在 TVB 的御用场景，吃最浓郁的茄汁面&/strong&&br&&/p&&p&&strong&胜香园
经营时间：三十年以上&/strong&&/p&&p&胜香园就在九记牛腩对面，记得第一次去九记时，非常惊讶为什么旁边一个看起来不起眼的大排档，排队的人比九记还多，这里还是 TVB 的御用场景地，很多剧集都在此拍摄。&br&&/p&&p&&figure&&img src=&https://pic1.zhimg.com/v2-fba9d656ada4_b.jpg& data-rawwidth=&2608& data-rawheight=&2608& class=&origin_image zh-lightbox-thumb& width=&2608& data-original=&https://pic1.zhimg.com/v2-fba9d656ada4_r.jpg&&&/figure&胜香园的招牌是番茄面，拿到菜单时又吓一跳，整整一页写满了各式番茄面，&strong&浇头和面条可以按照个人喜好自由搭配&/strong&。（纠结星人可能要犯难了 : P）&/p&&figure&&img src=&https://pic4.zhimg.com/v2-aafd4b06b070bf3d9486fb_b.jpg& data-rawwidth=&3302& data-rawheight=&2188& class=&origin_image zh-lightbox-thumb& width=&3302& data-original=&https://pic4.zhimg.com/v2-aafd4b06b070bf3d9486fb_r.jpg&&&/figure&&p&挑了每家茶餐厅都有的番茄通粉，试试看有什么不同。面条一端上来，看见闪着橙红光泽的番茄汤底，就知道差不了，入口&strong&鲜美酸甜，超~浓郁&/strong&！在闷热潮湿的香港，非常开胃，建议搭配一个溏心蛋，流心的状态迷死人。&/p&&figure&&img src=&https://pic2.zhimg.com/v2-7f0ef1e496aa24b25e694fdfab587c7d_b.jpg& data-rawwidth=&3730& data-rawheight=&2471& class=&origin_image zh-lightbox-thumb& width=&3730& data-original=&https://pic2.zhimg.com/v2-7f0ef1e496aa24b25e694fdfab587c7d_r.jpg&&&/figure&&p&另一道奶油脆脆也很受欢迎，抹上黄油和炼乳的猪仔包，客人&strong&即点即烘&/strong&，酥松香脆。&br&&/p&&figure&&img src=&https://pic2.zhimg.com/v2-e79ccbf239bf08f89f45bceac9cd5539_b.jpg& data-rawwidth=&3524& data-rawheight=&2335& class=&origin_image zh-lightbox-thumb& width=&3524& data-original=&https://pic2.zhimg.com/v2-e79ccbf239bf08f89f45bceac9cd5539_r.jpg&&&/figure&&p&地址：中环歌赋街，九记牛腩对面&/p&&p&&strong&No.3：黯然销魂叉烧饭&/strong&&br&&/p&&p&&strong&新桂香烧腊
经营时间：三十年以上&/strong&&/p&&p&&strong&香港最好吃的叉烧，永远在街边的烧腊店，而不在高档米其林星级的餐厅&/strong&。因为只有高流转，才能保证不断有新鲜出炉的烧味。至于刚出炉的和放置一段时间的烧味相比，会差多少呢？嗯，你们懂的！&br&&/p&&p&&figure&&img src=&https://pic2.zhimg.com/v2-f7ca6bd29ded87bf03d4d5_b.jpg& data-rawwidth=&2384& data-rawheight=&2384& class=&origin_image zh-lightbox-thumb& width=&2384& data-original=&https://pic2.zhimg.com/v2-f7ca6bd29ded87bf03d4d5_r.jpg&&&/figure&在中午十一点半到达新桂香，赶上刚出炉正滴着蜜汁的叉烧，一边按下快门，一边吞口水。&br&&/p&&p&&figure&&img src=&https://pic3.zhimg.com/v2-39abaa94a016_b.jpg& data-rawwidth=&2608& data-rawheight=&3478& class=&origin_image zh-lightbox-thumb& width=&2608& data-original=&https://pic3.zhimg.com/v2-39abaa94a016_r.jpg&&&/figure&新桂香的叉烧饭，实在美妙，&strong&厚切的梅头肉&/strong&，旁边还带着老饕们最爱的深色&strong&焦香&/strong&部分，吃起来&strong&软嫩又带一点咬劲&/strong&，蜂蜜的甘甜中有酒香，配上淋过叉烧汁的米饭，暗自销魂。&br&&/p&&p&&figure&&img src=&https://pic1.zhimg.com/v2-c4b46c25bc_b.jpg& data-rawwidth=&3314& data-rawheight=&2196& class=&origin_image zh-lightbox-thumb& width=&3314& data-original=&https://pic1.zhimg.com/v2-c4b46c25bc_r.jpg&&&/figure&店里的切鸡是意料外的惊喜，&strong&鸡肉嫩滑&/strong&，&strong&鸡皮爽弹&/strong&，加上一点用鸡油熬成的油葱汁，姣美动人（写到这里简直想关电脑飞香港）。&br&&/p&&figure&&img src=&https://pic2.zhimg.com/v2-c06c92d6ea4_b.jpg& data-rawwidth=&3538& data-rawheight=&2344& class=&origin_image zh-lightbox-thumb& width=&3538& data-original=&https://pic2.zhimg.com/v2-c06c92d6ea4_r.jpg&&&/figure&&p&&strong&小贴士：&/strong&&/p&&p&香港的叉烧店，都可以挑选肥叉或瘦叉，除非完全不能吃肥肉，强烈建议一定要点肥瘦相间的梅头肉。中午十二点以前，晚餐六点以前，应该都能赶上刚出炉的叉烧。&/p&&p&地址：柴湾道345号金源洋楼地下 17 号&/p&&p&&strong&No.4：最爽弹的云吞面，一斤面粉多加十个鸭蛋&/strong&&br&&/p&&p&&strong&新大光灯
经营时间：四十年以上&/strong&&/p&&p&以前和一位香港朋友聊天，问她离港后最想念的食物是什么，对方毫不犹豫的答道，「云吞面」！第一次去新大光灯时，那天已连吃三家云吞面名店，审美几近疲劳，但咬下他家面条时，瞬间变星星眼，&strong&极富弹性的麵身，是从未有过的体&/strong&&strong&验&/strong&。后来看资料，写他们家的面「一斤麵要比别家多加十个鸭蛋，蛋香浓郁，亦不容易变腍」。&/p&&p&&figure&&img src=&https://pic3.zhimg.com/v2-ce7eed1b93b08f6cfdb6b0ce_b.jpg& data-rawwidth=&3936& data-rawheight=&2608& class=&origin_image zh-lightbox-thumb& width=&3936& data-original=&https://pic3.zhimg.com/v2-ce7eed1b93b08f6cfdb6b0ce_r.jpg&&&/figure&店里的云吞麵，&strong&按照最传统的方式盛放&/strong&，云吞在下面在上，一方面可以让面条保持干身，另一方面也能提醒客人先吃面条，避免面条被汤泡软，汤底有&strong&大地鱼和猪骨的香气&/strong&。&br&&/p&&p&&figure&&img src=&https://pic4.zhimg.com/v2-31b9f2a713a74a392afdebef_b.jpg& data-rawwidth=&3936& data-rawheight=&2608& class=&origin_image zh-lightbox-thumb& width=&3936& data-original=&https://pic4.zhimg.com/v2-31b9f2a713a74a392afdebef_r.jpg&&&/figure&云吞尾部捏合的很漂亮，不会吃到令人讨厌的死结，内馅里虾仁和猪肉的比例也刚刚好。&br&&/p&&figure&&img src=&https://pic2.zhimg.com/v2-9c970f994ac_b.jpg& data-rawwidth=&3019& data-rawheight=&2000& class=&origin_image zh-lightbox-thumb& width=&3019& data-original=&https://pic2.zhimg.com/v2-9c970f994ac_r.jpg&&&/figure&&p&除了云吞面，另一道&strong&瑶柱牛腩面&/strong&，也是每次必点。上好的瑶柱与牛腩同煮，鲜味自然比单独炖煮牛腩，高出数个台阶，推荐。&br&&/p&&figure&&img src=&https://pic4.zhimg.com/v2-dda098e009a39af5a0d42bf_b.jpg& data-rawwidth=&2913& data-rawheight=&1930& class=&origin_image zh-lightbox-thumb& width=&2913& data-original=&https://pic4.zhimg.com/v2-dda098e009a39af5a0d42bf_r.jpg&&&/figure&&p&地址：红磡必嘉街 69 号 E 铺&/p&&p&&strong&No.5：去丝袜奶茶的创始店，喝杯下午茶&/strong&&br&&/p&&p&&strong&兰芳园茶餐厅
经营时间：六十年以上&/strong&&/p&&p&香港奶茶的鼻祖兰芳园以大排档起家，首创了鸳鸯奶茶和丝袜奶茶。店铺现已在原址后面拓展了新门店，但同时也保留了原来大排档的门脸。&br&&/p&&p&&figure&&img src=&https://pic1.zhimg.com/v2-b66aaae08ce_b.jpg& data-rawwidth=&3631& data-rawheight=&2406& class=&origin_image zh-lightbox-thumb& width=&3631& data-original=&https://pic1.zhimg.com/v2-b66aaae08ce_r.jpg&&&/figure&&strong&奶茶得丝袜之名，倒不是真的用丝袜过滤，而是因茶胆常年被茶叶浸泡，呈现出类似丝袜的颜色，从而有了这个性感的名字&/strong&。&br&&/p&&p&&figure&&img src=&https://pic1.zhimg.com/v2-52c3ebcc01b314c3e5ef423a770deb3c_b.jpg& data-rawwidth=&3936& data-rawheight=&2608& class=&origin_image zh-lightbox-thumb& width=&3936& data-original=&https://pic1.zhimg.com/v2-52c3ebcc01b314c3e5ef423a770deb3c_r.jpg&&&/figure&兰芳园的冰冻丝袜奶茶，茶香醇厚，茶体细滑，实在是烈日灼人香港的消暑圣品。&br&&/p&&figure&&img src=&https://pic2.zhimg.com/v2-de9a5a5b675b242cac038d_b.jpg& data-rawwidth=&2490& data-rawheight=&3112& class=&origin_image zh-lightbox-thumb& width=&2490& data-original=&https://pic2.zhimg.com/v2-de9a5a5b675b242cac038d_r.jpg&&&/figure&&p&再配一碟西多士，就是一份美好下午茶，这里的西多士，馅料没有用常见的花生酱，改用了&strong&南洋风十足的咖椰酱&/strong&，蛮特别的。&/p&&figure&&img src=&https://pic1.zhimg.com/v2-cc7ac24cfe16322eadb168aecc3f358c_b.jpg& data-rawwidth=&2048& data-rawheight=&1536& class=&origin_image zh-lightbox-thumb& width=&2048& data-original=&https://pic1.zhimg.com/v2-cc7ac24cfe16322eadb168aecc3f358c_r.jpg&&&/figure&&p&地址：中环结志街2号地下&/p&&p&&strong&No.6：全香港最好的菠萝油&/strong&&strong&，酥脆咸香冻&/strong&&br&&/p&&p&&strong&金华冰室
经营时间：四十年以上&/strong&&/p&&p&金华冰室的菠萝油，满足一只高品质菠萝油应有的品质，「酥香咸脆咸冻」。为了让客人能吃到状态最佳的菠萝油，金华冰室的菠萝油采用&strong&少量分批烤制&/strong&。&br&&/p&&p&&figure&&img src=&https://pic1.zhimg.com/v2-e728bf0dab0cf98a88a74_b.jpg& data-rawwidth=&2435& data-rawheight=&2436& class=&origin_image zh-lightbox-thumb& width=&2435& data-original=&https://pic1.zhimg.com/v2-e728bf0dab0cf98a88a74_r.jpg&&&/figure&端上来时还带着腾腾热气，&strong&外皮酥脆到咬下去能听到声音&/strong&，热面包和冰凉黄油之间保持了完美的温度差，无懈可击的一只。&br&&/p&&p&&figure&&img src=&https://pic3.zhimg.com/v2-a4aedcc4551bfe26b14cc0a381b95376_b.jpg& data-rawwidth=&3647& data-rawheight=&2417& class=&origin_image zh-lightbox-thumb& width=&3647& data-original=&https://pic3.zhimg.com/v2-a4aedcc4551bfe26b14cc0a381b95376_r.jpg&&&/figure&香港朋友还强烈推荐了咖喱系列，试了用咖喱炒成的星洲米粉，米粉干爽，鸡蛋滑的足够嫩，咖喱层次感也很好，喜欢。&br&&/p&&figure&&img src=&https://pic1.zhimg.com/v2-664f34fb49cfe078af293d8_b.jpg& data-rawwidth=&3149& data-rawheight=&2087& class=&origin_image zh-lightbox-thumb& width=&3149& data-original=&https://pic1.zhimg.com/v2-664f34fb49cfe078af293d8_r.jpg&&&/figure&&p&&strong&小贴士：&/strong&&/p&&p&建议尽量在午餐时间去，去完了很可能就木有菠萝包了，店里的热奶茶也很好喝，可以点一杯做饮品。&/p&&p&地址：太子弼街47号&/p&&p&&strong&No.7：最嫩的滑蛋，最独特的茶室文化&/strong&&/p&&p&&strong&澳洲牛奶公司
经营时间：四十年以上&/strong&&/p&&p&香港的冰室和茶餐厅，应该是体验港味的最佳场所之一。追求高效率的香港，在这间店可谓得到淋漓尽致的体现，&strong&「&/strong&&strong&光速餐」从点菜到吃完最快只需十分钟。如果你点菜犹豫拖拖拉拉，马上会收到服务员的白眼，&/strong&现在很多人去澳牛，还就是为感受这一特别的用餐氛围。&/p&&p&&figure&&img src=&https://pic3.zhimg.com/v2-056a59e436c8a_b.jpg& data-rawwidth=&1024& data-rawheight=&768& class=&origin_image zh-lightbox-thumb& width=&1024& data-original=&https://pic3.zhimg.com/v2-056a59e436c8a_r.jpg&&&/figure&店里最出名的炒蛋多士，因加入大量的鲜奶，炒的松软细嫩，配上烤的香脆的多士，很好吃，有次陪朋友去，对方连点了三份......&br&&/p&&p&&figure&&img src=&https://pic1.zhimg.com/v2-262ae3ca3c833cb9bed60_b.jpg& data-rawwidth=&1910& data-rawheight=&1273& class=&origin_image zh-lightbox-thumb& width=&1910& data-original=&https://pic1.zhimg.com/v2-262ae3ca3c833cb9bed60_r.jpg&&&/figure&甜品里推荐蛋白炖鲜奶和杏汁燉蛋两款，传统港式的做法，足够滑嫩，但免不了有一点偏甜。&br&&/p&&figure&&img src=&https://pic4.zhimg.com/v2-0f9dfdbcf2b7_b.jpg& data-rawwidth=&2048& data-rawheight=&1536& class=&origin_image zh-lightbox-thumb& width=&2048& data-original=&https://pic4.zhimg.com/v2-0f9dfdbcf2b7_r.jpg&&&/figure&&p&&strong&小贴士：&/strong&&br&&/p&&p&澳牛现在正餐时间排队非常厉害，建议下午三四点的时候去，几乎不用排队，还可以解决下午茶。&/p&&p&地址：佐敦白加士街47-49号&br&&/p&&p&&strong&No.8：宵夜里一碗热粥落肚，才能睡个好觉&/strong&&/p&&p&&strong&生记粥品专家
经营时间：四十年以上&/strong&&/p&&p&生滚粥不仅要粥底好，还要料好且烹饪得当。生记煲粥底的汤底，据说是用干贝、猪骨和瘦肉熬成，加米后用大火熬一小时，再用文火煲四个小时完成。&br&&/p&&p&&figure&&img src=&https://pic2.zhimg.com/v2-f5d143c6cf779d_b.jpg& data-rawwidth=&3681& data-rawheight=&2439& class=&origin_image zh-lightbox-thumb& width=&3681& data-original=&https://pic2.zhimg.com/v2-f5d143c6cf779d_r.jpg&&&/figure&店里粥品选择非常多，我最喜欢点招牌的鲜皖鱼腩粥，上粥之前，老板会先送来一碟放有姜丝和葱末的酱油碟，用来蘸食鱼腩。&br&&/p&&p&&figure&&img src=&https://pic3.zhimg.com/v2-e6fd8ca3daaabe_b.jpg& data-rawwidth=&3689& data-rawheight=&2444& class=&origin_image zh-lightbox-thumb& width=&3689& data-original=&https://pic3.zhimg.com/v2-e6fd8ca3daaabe_r.jpg&&&/figure&香港人吃粥，还喜欢配上老油条，挑一小块浸入粥底，暖意满满。&br&&/p&&p&&figure&&img src=&https://pic3.zhimg.com/v2-d16befdbf0ee2a_b.jpg& data-rawwidth=&3716& data-rawheight=&2462& class=&origin_image zh-lightbox-thumb& width=&3716& data-original=&https://pic3.zhimg.com/v2-d16befdbf0ee2a_r.jpg&&&/figure&鱼腩粥端上来，简单洁白，只用鱼腩加上姜片在粥底里烫熟，鱼腩鲜甜有弹性，米花煲的极细，宵夜里一碗热粥落肚，会睡个好觉。&br&&/p&&p&&figure&&img src=&https://pic3.zhimg.com/v2-1ead780ca10df1d7f03f2_b.jpg& data-rawwidth=&3045& data-rawheight=&2018& class=&origin_image zh-lightbox-thumb& width=&3045& data-original=&https://pic3.zhimg.com/v2-1ead780ca10df1d7f03f2_r.jpg&&&/figure&地址：上环毕街7号地下&br&&/p&&br&&p&&u&&b&原文发于微信公众号：味之道。更多餐厅和食谱在公众号更新，欢迎关注。&/b&&/u&&/p&
香港的饮食生态多样，但每次去最喜欢的，还是那些经营数十年以上的小食店，享受美食的同时，还可以最直接的体验香港本地风情。国庆假期又去了一次，惊喜的发现这里慢慢回复到那个没有扫货团满街横飞，去餐厅不用人挤人，出门左转就能吃到美食的迷人城市。以…
&p&&b&EXCEL常见技巧锦集&/b&&/p&&figure&&img src=&https://pic3.zhimg.com/50/v2-0b2ceb61a2f7bb551410ee_b.jpg& data-caption=&& data-size=&normal& data-rawwidth=&640& data-rawheight=&20& class=&origin_image zh-lightbox-thumb& width=&640& data-original=&https://pic3.zhimg.com/50/v2-0b2ceb61a2f7bb551410ee_r.jpg&&&/figure&&p&&br&&/p&&p&&b&一、基础操作部分：&/b&&/p&&p&001、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3Dee3c4a601d4fe26ed7d45%26chksm%3Deca1a4d55acaee6bb64fdcc2dc337370beescene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&基础环境介绍&/a&&/p&&p&002、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3D7def3f08b74549dbe1c196ecddc1a595%26chksm%3Decaf593cece7fa402e040dc934cd9c8d09a5%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&录入技巧（光标跳转设置、重复上面单元格的内容、填充、分数录入、输入当前日期）&/a&&/p&&p&003、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3D61f964be1c%26chksm%3Deca139dbdfbadc1df81e64bdec788c33f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&基本操作技巧（多个单元格内容复制到一个单元格中、CTRL+D填充、快速做序列号）&/a&&/p&&p&004、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3Dd7fbd13a87d3dchksm%3Decaa2af8d94ff83d5e17b0ebff4fb762e2f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&实时预览、双击格式刷、微调字体大小&/a&&/p&&p&005、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3D663ec1a2c73a199a192f96fb%26chksm%3Dec41286fdb36a89bcc87fd0e7d229baa83ddfa63bedb41fascene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&快速移动、复制、互换位置、凹凸边框制作、给文字添加拼音、斜对齐&/a&&/p&&p&006、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3Db6c2d3c130cb853%26chksm%3Deca16fa3f429bce987d8b96%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&跨列居中、快速选定内容、斜线表头的制作&/a&&/p&&p&007、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3Ddff6e77de%26chksm%3Dec41287edb36aaabcecdaa558b024b6e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&自定义数字格式1&/a&&/p&&p&008、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Db4a0acfb2ad13df0c2c0af%26chksm%3Dec412f30db36aedcdc43bbaef9aa9c85acbc45208ca5eee17e7d7c10909%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&自定义数字格式2&/a&&/p&&p&009、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D93fbf9c7db0a894707cfd877bae6d661%26chksm%3Dec412cdcdb36a5ca142e245b81ac507db7efb5c98b0c9301dc1bbe8eef%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&表格样式（单元格格式、表格样式、一次性编辑多表）&/a&&/p&&p&010、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D67b666a97e4b493abf4da7%26chksm%3Dec412c8cdb36a59ab20a37a8dc2b8ad7c460fdebde26524facff993%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&不完全重复的项如何删除&/a&&/p&&p&011、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbade06c4e13bc34df37c3ad%26chksm%3Dec412c8fdb36a2ca08cc0d08a0f880fbb8030fd41acebf51%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&剪贴板的用处你了解吗？（多列合并一列、复制多个单元格内容到一个单元格、多表合并到一个表）&/a&&/p&&p&012、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D05b4ceef1b%26chksm%3Dec412c81db36abc6ee880f3e5aa27aa935b8acd10b83b43d17b722e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&初识条件格式&/a&&/p&&p&013、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D19cf2e8d64e3b99e50aa%26chksm%3Dec412c9ddb36a58bf8fec0e4cabffdb4b168a94b1a845bescene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&快速隔行或者隔列插入&/a&&/p&&p&014、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcae3b750f018ce792965fbcfchksm%3Dec412c64db36af6a789f82a8cde4f6a81192defa2ca6cb8b81d8cbce3e27b4d3ea9%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&强大的CTRL+E（仅限13版本以上的excel）&/a&&/p&&p&015、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dffadcb1f2aeb71a2f9d2524aef46aefd%26chksm%3Dec412c74db36a562e2af897e166bdfa47a1a2f11ascene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&你真的懂查找和替换吗？&/a&&/p&&p&016、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D00a084bfab07a603ae89%26chksm%3Dec412c40db36a556e11eacc44cdbb427e81fd99afdb10b9e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&全面了解选择性粘贴&/a&&/p&&p&017、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc56b60f1a6a0e1f10bc7c0efa1a924bc%26chksm%3Dec412c5bdb36a54d4cd1607efd41c74fc83ac518baf210f467a29fef4fdc38898b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&保护工作表的N种方法&/a&&/p&&p&018、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D2ff85cd154e%26chksm%3Dec412a89db36a39fca820f2a0a54c8911aff187eae3f3f6c602b1c247cfc7e89%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数据透视表基础&/a&&/p&&p&019、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddd2210aaa85a30e3bcad5b7%26chksm%3Dec412c3cdb36a52a55f21aa7f6632b3fdbcecb92a7ea304ff5beb8e26e1ccfa3e23%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&你该熟练掌握的数据透视表技巧&/a&&/p&&p&020、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D450b10cb6ae4ff66dd396dfchksm%3Deca1b06efb603da1aa71cf7f4e469a788a52bdd9696a%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&多重合并数据透视&/a&&/p&&p&021、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D31ada109cf70a3a8b4bb8aec42b5e9cd%26chksm%3Dec412c0fdb36aec7d66e503f8dc7fc8bf328ce93ec9c9dc29affde3e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&破解工作表保护密码的黑科技&/a&&/p&&p&022、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Db9aa2fb369ccb%26chksm%3Dec412deddb36a4fb38ec2b3f723522dfc6b907b0d3a2e91cffdfca%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&让你更快一点（F2、CTRL+TAB、ALT+TAB）&/a&&/p&&p&023、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dde7ad64230af4eebf83f64a60e5a232e%26chksm%3Dec412ddcdb36a4caad3c73e29bda67224ae0bde589cb%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&提取实战（CTRL+E）&/a&&/p&&p&024、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D8e65cdeec5c687dab3d75%26chksm%3Dec412ddfdb36a4c92e8cec843e7dd24f9be8f991e0cdd4dcc5bea964ab2aee516%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&你可曾遇见这样的烦恼（被超链接、对齐之缩进）&/a&&/p&&p&025、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbdbb3bce9%26chksm%3Dec412d24db36a4325cfee1bdea19ff977f8b5a11a10e0c1b56c38e9%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&合并单元格筛选查看技巧&/a&&/p&&p&026、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Df27ffb85b4ba2f134d60af277fa92a5f%26chksm%3Dec412a6cdb36a37ae856f35c0edacd274c55338fca83d785f3cabad17ef940bb922%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&多个工作表快速合并&/a&&/p&&p&027、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D43e039e34a51fc32526b%26chksm%3Dec412a5fdb36aad2ce5688014aaacebbeb2cddafd20e272e607ef9a8bddf02b13%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&E表打印技巧&/a&&/p&&p&028、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcaea18f671b0a%26chksm%3Dec412bbddb36a2abfcee1b9ef52dbdf7eed7e49bscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数据验证不允许输入不符合条件的值怎么破？&/a&&/p&&p&029、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7c57a554dd%26chksm%3Dec412bb4db36a2ad2b3beebbefbec751cbe07afcaaa%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&输入法里深藏的技巧&/a&&/p&&p&030、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D6d584ed6c22c35%26chksm%3Deca1f4e2b29cca30b3b7b4bacb%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&用查找法快速查看工作表&/a&&/p&&p&031、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D8fc42bd53795c69cbe6a2%26chksm%3Deca1f6bae523e21a07cc5cda1cc39afec543%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&快速制作工资条的三种办法&/a&&/p&&p&032、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1bb06eba8%26chksm%3Dec4128ccdb36a1da5f0cf00b03edfedb4c0c300dfeb1218%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&高级筛选&/a&&/p&&p&033、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbb982b21f9c11f87f97fd32db7ef7e12%26chksm%3Dec412d18db36a40ee6fc34b62b0537fea5f207ec44c934d223e3cee321ce3fb5e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&浏览长表的技巧（冻结行列、单元格、快速返回表头）&/a&&/p&&p&034、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3De5d1ebba18a6b52c383d8f%26chksm%3Dec4128afdb36a1b9fcdd56d02b0a49a94affe17a815fdb16333afb1e7%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&让你爽翻了的邮件合并功能&/a&&/p&&p&035、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4f9ec5cef9a611ba907f%26chksm%3Deca1b71c49a69f87b69bbfa75fd32a68ae822%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&2016版excel新增的几个功能&/a&&/p&&p&036、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddc96e934fb2ed5a509c709%26chksm%3Deca0c648b6c553a0b5b60eecb9fa6de820df%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&EXCEL中按方向键光标居然不动了&/a&&/p&&p&037、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D64eeb2a452a5d226a626%26chksm%3Deca0c7cd7a8da923ed81faf8ef9d9b9c0fc69691f7fbdb7bff8d331f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&基本操作练习题（分列，定位）&/a&&/p&&p&038、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D9b860ffbbc56e7%26chksm%3Dec4129acdb36a0ba2abf179eb536bd1bdf980b5c605cedbc89c6ad9091a7abeed%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&一次性复制格式同时去掉数据中的公式&/a&&/p&&p&039、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddd361bc188f310ec831a9f%26chksm%3Deca0b691cc018d5edbb3cd3a21faea10bdf3%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&一招让以科学计数法显示的数据恢复本来的面貌&/a&&/p&&p&040、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dede318d9facc%26chksm%3Dec4129bfdb36a0a94260c6cbc94ef29b6de610d5af9a8cdea8ee9368cfb299cff5%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&给你的Excel设定个允许填写日期（数据验证）&/a&&/p&&p&041、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7db94b894d1%26chksm%3Dec4129bbdb36a0ad7adc8c0d73c6667c8ddd7e55af444d1e3fb3dc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&口内打对?或者?怎么弄&/a&&/p&&p&042、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7db94b894d1%26chksm%3Dec4129bbdb36a0ad7adc8c0d73c6667c8ddd7e55af444d1e3fb3dc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&没保存的文件意外关闭该怎么办&/a&&/p&&p&043、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D20f0aed870e67c73c035f0f%26chksm%3Decafe3129d93ddafd87caceaf438b5d38c505d14d704a83%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&批量获取文件名&/a&&/p&&p&044、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D361f9016dbe6cb5baaeb%26chksm%3Decafe61859f9ddfd16fcfc2a56551f74dcfbe81aa3142c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&批量在Excel中插入照片&/a&&/p&&p&045、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7acc2edbe4d892e19cd650da7d78e054%26chksm%3Decafaeddf36c454308cdaa8a1dfscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&邮件合并批量生成N个文档&/a&&/p&&p&046、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D2f07e6f1453%26chksm%3Decafa051a4136ea9adfbafc85580ad7fbfd54818cbc2141e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&邮件合并批量插入对应的照片&/a&&/p&&p&047、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc5eab594dc7e4d1d431b%26chksm%3Decaf8ef4e54c49d8d60a57b68d5cfde585b7e271d35f4bfc82ef0f787%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&批量修改文件名&/a&&/p&&p&048、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4a2c31d8103edc486eafb%26chksm%3Decaf3fbca2af5a96a500aac3fb5ec3c5c5781a3eafcdd%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&跨列、跨越居中&/a&&/p&&p&049、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3De68db87a55d32a7e6609e%26chksm%3Decafaeacd1ad2ebbefab49f7cfaceb578a6%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&在Excel中插入截图的技巧&/a&&/p&&p&050、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7d684da85dab0b23a1cad0%26chksm%3Dec41269bdb36af8df28ed0ecd3b9eb4fa51f7890acb2ec22d9e89%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&分列功能里的技巧&/a&&/p&&p&051、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dfce900d419c686b89b5aeda97ad738c9%26chksm%3Decaed282c152b0eeb44443efe1cfb34fefff137a2e11ffc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&Excel中的创建组&/a&&/p&&p&052、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcf05acf7c%26chksm%3Decaee1d461fb81d8dbae3bbf84bd604a40a03f98f5b6ebf20f7fce%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&根据相同的内容批量合并单元格&/a&&/p&&p&053、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4d5dcb3eb2f341f0b356da869d51d291%26chksm%3Decaea4e6d3c3fa8df5eb012871ecc2a4a%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&账期提醒表&/a&&/p&&p&054、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddf913b463e21bdaed1c12a5fbchksm%3Decae13b79ed33bed54b2efa335e3a8d19fe51f436e209ff4db979cb5%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&一分钟恢复损毁的EXCEL文件&/a&&/p&&p&055、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dfb503fe05f0f317be125bc%26chksm%3Decae15fde6d2044cdac2f52ccba0fcf49f3aa44c104%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&13个必学的Excel技巧&/a&&/p&&p&056、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D95db0cd20baf85%26chksm%3Dec41258adb36ac9cfd0b37749bce119cb33a18cdefd3a220c00e127a15fcaffa69%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&给excel打印文件添加水印&/a&&/p&&p&&b&二、函数部分：&/b&&/p&&p&001、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Df4aee3e11%26chksm%3Dec412dd6db36a4cdfdbf8b5ad11c3b29fe99ffc93ef30b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&来自一个护士的烦恼（列与矩阵互转）&/a&&/p&&p&002、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D2%26sn%3D8e2025cedd3ec3f3564fbf%26chksm%3Decae557e5b3da6c4ee107dc5af3fdfa70cddea5ce5dc19e9%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&sum函数经典用法&/a&&/p&&p&003、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D68d3a96a32be75e9ccddec8%26chksm%3Dec412d79db36a46fda92cb12ddcfef1c76e69e1daae98ed0f1ca4a%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&sumif函数（条件表达方式）&/a&&/p&&p&004、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Daf2b4f0bf382b46f146ceac%26chksm%3Dec412d76db36a460d80cfc67b765c772f32da1b63c8d028bcea3d218acscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&sumifs函数（多条件求和）&/a&&/p&&p&005、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1ae939e4b27b4f2d92bf%26chksm%3Dec412d44db36ade54c68fc2bb72e4f901a24e7ad12cd06cdb9db0672ee2ccd117%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数组思维下的sumifs&/a&&/p&&p&006、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D8e0df1dec%26chksm%3Dec412d5edb36a448e9107d8ace18cb43caf99a2a33f83bd094ca977ee80d14ebe8c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&强大的sumproduct函数&/a&&/p&&p&007、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Deac9da1dac%26chksm%3Dec412d57db36aace2a515ae77aeb3d1b4cfb9cdcc882b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&多条件求和练习题（sumproduct、sumifs、sumif、sum）&/a&&/p&&p&008、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Deac9da1dac%26chksm%3Dec412d57db36aace2a515ae77aeb3d1b4cfb9cdcc882b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&if、iferror普及课&/a&&/p&&p&009、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D8f48b86d595b84a6c9e8d88echksm%3Dec412d2cdb36a43a381f06d22eaebac8c7a73291ed%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&工作中需要的不仅仅是四舍五入（round、roundup、rounddown、int）&/a&&/p&&p&010、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbdbb3bce9%26chksm%3Dec412d24db36a4325cfee1bdea19ff977f8b5a11a10e0c1b56c38e9%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&舍入函数（floor、ceiling）&/a&&/p&&p&011、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbb982b21f9c11f87f97fd32db7ef7e12%26chksm%3Dec412d18db36a40ee6fc34b62b0537fea5f207ec44c934d223e3cee321ce3fb5e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&计数函数大合集&/a&&/p&&p&012、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1834c2bad9fcachksm%3Dec412af9db36a3eff7afe6d5a3b3a5ba7b116c562a422ef8b73cd9c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&女神（vlookup）驾到，快来迎接&/a&&/p&&p&013、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dd8d387ec188ea%26chksm%3Dec412af3db36a3e5e9e06c0c3bbf6b1d1ecc9f71e284e6b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&经典的查找函数lookup&/a&&/p&&p&014、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da464bc2c49b8c29ab43b2b%26chksm%3Dec412acbdb36a3ddea024bacfd24b5f95f25dec5cc21770dabf4fe9d96%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&lookup的查找原理&/a&&/p&&p&015、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcb6d06df948cf485abbb3%26chksm%3Dec412ac2db36a3d46f402f9ab5feacb8979abad%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&字符串中的数字提取（isnumber、match）&/a&&/p&&p&016、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D08fec1a60ba6f80fdaf221c9e27eef24%26chksm%3Dec412ad1db36a3c78ca7eb362fdbc746be330ee94296c0bffdcba8b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&字符串中的数字提取进阶！（N^0=1）&/a&&/p&&p&017、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc078070dcfcc8a1c7f1b82b8e9b570b6%26chksm%3Dec412ad0db36a3c6cfac21a4e61ba1f35efad51cad%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&求区域中最后一个数字（max、min、mod、indirect、text）&/a&&/p&&p&018、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D79ab0f40ca69%26chksm%3Dec412aa6db36a3b07d34adc5dcd7dbb21f06a50dbacac37f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&检验下你的水平（区间判断if、lookup、len、lenb）&/a&&/p&&p&019、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dacdd53c728f619%26chksm%3Dec412aa0db36a3b6f59e01eac32dec0a30a028e2cff19c7c70a3ca56fd3ed5d94c4fdfa359ee%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&温故而知新（前面所学函数汇总）&/a&&/p&&p&020、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddcacb86cf992bb8%26chksm%3Dec412ab6db36a3ab1f4ea94b56544cdf24af3f943fadd6fdb7362dd%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&在多表中查询数据（函数中引用工作表的办法）&/a&&/p&&p&021、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D72a2518bfabe3ee6b04f784fdd6e47a5%26chksm%3Dec412a9ddb36a38bdd9e5bc2f45a99b658a3549f0bbc324a6d21a44bd2d%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&连续编号的技巧（合并单元格编号，筛选、隐藏行后的编号）&/a&&/p&&p&022、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D72a2518bfabe3ee6b04f784fdd6e47a5%26chksm%3Dec412a9ddb36a38bdd9e5bc2f45a99b658a3549f0bbc324a6d21a44bd2d%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&把一列中大分类相同的小分类放到一行的方法&/a&&/p&&p&023、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dd41fef317da%26chksm%3Dec412b30db36a226ee6c61e3a78fc6c04efb7a075f2cae1cb5f668ab6f7c07b5810c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&把一列中大分类相同的小分类放到一个单元格中的方法&/a&&/p&&p&024、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da106e9c18c864dc2c8e9%26chksm%3Dec412a94db36a382a55cd04e195d1f2fa5efba0dscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&银行账号间自动加空格&/a&&/p&&p&025、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da106e9c18c864dc2c8e9%26chksm%3Dec412a94db36a382a55cd04e195d1f2fa5efba0dscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&两列中互相重复的数字提醒&/a&&/p&&p&026、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc44063e8edd1a41aa4739e%26chksm%3Dec412a69db36a37fb947beef04398af8cac631bef406df158c6cc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&时间日期函数（datedif）&/a&&/p&&p&027、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D020e3a3dd3c05d51d3808aeedbc863c8%26chksm%3Dec412a67db36af8f0f8d9dddab7c71b02%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&人民币小写金额转换大写&/a&&/p&&p&028、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D272e48cfaa092bdcd224d%26chksm%3Dec412a7edb36aaaa275aa6a8cd0e1e7b8bc6a29d0c844%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&练练你的基本功（每个分类编序号、合并单元格求和）&/a&&/p&&p&029、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1c22fc8fd0a71be85e6e%26chksm%3Dec412a5adb36a34c3f6a7c68d9fa10ef4f56e0e529e8a01ef34657f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&rept、trim函数&/a&&/p&&p&030、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D4ea823f1c5e735b8ae4e51%26chksm%3Dec412a51db36a347e86a08acede69805ddac4d819ecf4b32ff6c7c64c9ac3df68%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&知其然也知其所以然（把一行字按照分隔符拆分成一列）&/a&&/p&&p&031、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3De81b99baccc6be%26chksm%3Dec412a2cdb36a33adb2d00add7b7acf0abd107b14cbab6dce7d0ff8ad%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&三个简单的一看就会的函数（large、rank、phonetic）&/a&&/p&&p&032、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D3fb792b68ba93db0e5a94dc%26chksm%3Dec412a2bdb36a33dbb8a387b9bc236f4fc9fea3aa507%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&必学的技巧（累计求和、带单位的数字求和、small）&/a&&/p&&p&033、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da2bdd1f9631afe8d77262%26chksm%3Dec412a20db36a336bb5d6cb1d0cf7d6eaece0da3aa10eb49%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&综合练习（从身份证号码中提取生日、性别）&/a&&/p&&p&034、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D3b3b9e25dde3bf1de7b88040daacfea3%26chksm%3Dec412a35db36a32396abcf2f15a91bc8a35e87fa3c25cabe5de343cc94e74bcf%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&根据填充颜色求和（get.cell、formulatext）&/a&&/p&&p&035、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D0ebb8aa81cd311a8d66a191%26chksm%3Dec412a0fdb36ad4cba7ce5f04e9901fcc75439cbab785fc19d69a4%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&获取演讲比赛成绩的前三名（综合练习）&/a&&/p&&p&036、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D5dc410a22c17c0769ef5bfaaeea058b6%26chksm%3Dec412a08db36a31ef84d57d695bb1e107cc16b38ede7%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&逆向查询（vlookup、lookup、index+match）&/a&&/p&&p&037、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dceda07d7d7b9f05b83c51a1%26chksm%3Dec412a05db36a31316bcdf3cf82afc9fad7af68c785b7c865eb0be7ee%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&统计区间个数的专属函数（frequency）&/a&&/p&&p&038、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D3febae76f347ae587a25e%26chksm%3Dec412a1cdb36a30a3ccb2fc16b82e13c29c11c4af8debc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&循环引用的妙处&/a&&/p&&p&040、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D61c5f526070adbb361acf44532dde89d%26chksm%3Dec412a1adb36a30c43c89b78acb6eb0260b8ddf0a76b7db12c3006%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&高手的玩法（查找综合练习）&/a&&/p&&p&041、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1b5c2a47b85ee68ef4e0a5e%26chksm%3Dec412a10db36ae02d10a7d0ffc6afa9f4ec35edscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&隔行隔列求和&/a&&/p&&p&042、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1dc363ca4af8d%26chksm%3Dec412beedb36a2f831c4cf12eed75eb80a7fb2692dcb822f642b1d72%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&提取不重复的值&/a&&/p&&p&043、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D5d67b53fcd1cb400d49d4e%26chksm%3Dec412beadb36a2fcdadbf6e935b6f73c52be44cecbfcfdb883e3e707%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&数据库函数dcount、dcounta&/a&&/p&&p&044、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D1d2c3ea5aa2f822d0319bd7fad38f7f1%26chksm%3Dec412bfddb36a2eb54fdeb089f5cf2b83e5ce4bfff1dafa%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&时间函数大全&/a&&/p&&p&045、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Db462b7fdad7%26chksm%3Dec412bfcdb36a2ea392a65d812de1de59fe4a85ac91b26beca45c9d4cea4ebed2fc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&日期函数大全1&/a&&/p&&p&046、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D537acdee441e8dc20d27e9b2%26chksm%3Dec412bf6db36a2e0a619badc24cadcea16ed2ceb4a87e6%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&日期函数大全2&/a&&/p&&p&047、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D60f83deef3db939ce69d075%26chksm%3Dec412bc1db36a2d69f454b946a36f9ab8d1bd9442ca3cbda92af69e51af55f6f80%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&条件排名的四种思路&/a&&/p&&p&048、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D6e4fc2a070%26chksm%3Dec412bc0db36a2d6ec9ffa8cf8dbff7bc1db6b0d681e3c0fb2e67c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&transpose函数&/a&&/p&&p&049、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D174fc579f0bbda71a9c6902%26chksm%3Dec412bc3db36a2d58a20f21b5670821aba404e0d749b2c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&hlookup函数&/a&&/p&&p&050、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D6ce386d1d514b5182f9ed%26chksm%3Dec412bc2db36a2d49baf32cbbfeb95da815cbb8e74dc4700%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&address函数&/a&&/p&&p&051、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D9cce3aff2e07d71dbdb0c7d%26chksm%3Dec412bdbdb36a2cda23e6ebb8b3eff96ebd3b2e84c45e1ad%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&打印表中某个单元格按次序引用一列的内容&/a&&/p&&p&052、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D59beb8dc363f45baefac9b3%26chksm%3Dec412bd3db36a2c5faf0c4a76de6fccba986bf3981dfbascene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&文本运算式求值&/a&&/p&&p&053、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D57dd86fa21ba0e0b2fcef6%26chksm%3Dec412bbcdb36a2aae9b92a470da8ec2d4ee5f94db8dcbb8ca4c6666%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&多级下拉菜单的制作&/a&&/p&&p&054、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D96b6fa23e7c7cchksm%3Dec412bb5db36a2a3be9d42eab2d2f5b49d9d5a785bec084abbd0e0bc%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&联想式下拉菜单的制作&/a&&/p&&p&055、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D7eefa1fcbf2%26chksm%3Dec412b84db36a0b214e886d7fb38cb22c572a81f5d88c2ad91bb8b45fbscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&用excel做个九九乘法表&/a&&/p&&p&056、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da101eb7ac79%26chksm%3Dec412b92db36af221707bec0ea413b8af65b17eb6e797cdd21a8edb%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&给你的工作簿做个目录&/a&&/p&&p&057、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Ddb5232fdca0a16da153ed%26chksm%3Dec412b6ddb36a27bf1efbdfb42baf994escene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&hyperlink函数&/a&&/p&&p&058、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D71ae92fb2a297c5a5b36d8a6f27bb296%26chksm%3Dec412b65db36a273ad22a157cf902ef843053dfcedba821f54db1814%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&最大公约数函数GCD&/a&&/p&&p&059、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Db361aa72a9a%26chksm%3Dec412b64db36a272d38a378e725c45ff752cd98ea3a04a1a87adf993a5b0240ecd%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&最小公倍数函数LCM&/a&&/p&&p&060、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc77eeaf29d575f803c076ddea29d89b3%26chksm%3Dec412b67db36ada050bfeabd8d2eab4eed%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&去掉一个最高分，去掉一个最低分求平均值(trimmean)&/a&&/p&&p&061、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da72a727b991ca72cb10fee2d12c06430%26chksm%3Dec412b66db36accae952afb2debaadaca185%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&没学quotient之前你是怎么求商数的&/a&&/p&&p&062、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D9bc016be1cf95d1e215fd%26chksm%3Dec412b7bdb36a26d4f801e02e99f3e4ef152fe081c34a4f8a074e963e15a333e4%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&检测是否完成任务还可以这样(sign)&/a&&/p&&p&063、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dceaff6cb7bcb54%26chksm%3Dec412b4edb36a80e8fa9b24c3c9cede5a3%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&int与trunc的区别&/a&&/p&&p&064、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D75fdc22f12a38ecbbf03d10cchksm%3Dec412b49db36a25fa10dccdda1d6d4495228ebf9f1b5cc704fec080c7bf95f87b%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&求企业连续几年业绩的平均增长率（geomean）&/a&&/p&&p&065、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D92b6bf7382bafc6de1a72322efa375ec%26chksm%3Dec412b4adb36a25c73eb5ccd73c1d8e87f5628fed69e8f1c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&英文字母大小写转化，阿拉伯数字转罗马数字（upper、lower、roman）&/a&&/p&&p&066、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Daeb1dbfb58fc7f27e61922%26chksm%3Dec412b45db36a8572ddc17e2dad71ff66a7efa698f381e2bdba7ac%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&product，可曾听说过&/a&&/p&&p&067、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dc0ae658cc0ffa7f49ec12f%26chksm%3Dec412b44db36a6c777d8837edb76e9f334c04a5c3ba8%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&随机函数rand、randbetween&/a&&/p&&p&068、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dcf8aacc1903ef2daf4c98df4fec826cb%26chksm%3Dec412b5ddb36a24b6f333d0fd3cfeefc84b4dffscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&用excel做个抽奖器&/a&&/p&&p&069、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbc2a8f802a47f7e1ebd45d%26chksm%3Dec412b27db36a231ee776ee2862aecd4a557d340c85e6a13b633f71cefscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&根据进货、出货求库存（综合练习）&/a&&/p&&p&070、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D624daed982aae58e4df5b2%26chksm%3Dec412b39db36a22fb0f1dad72cbfc203fd054ce0e238e%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&中文数字转化成阿拉伯数字&/a&&/p&&p&071、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D6ea38b4ecafc244b02699%26chksm%3Dec412b38db36a22e98b543d0a8dca4f561fbbc2e796aa95e686a2a92ac7c9f28dff0%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&这就是我为啥老推荐你使用2016版excel的原因（新增的几个函数）&/a&&/p&&p&072、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D250a9c25bf9a5dc7fd42b00f3efa0358%26chksm%3Dec412b07db36a2112b9dfeda456de5e42fe0ac0d39d4bascene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&综合练习题（表格自动化）&/a&&/p&&p&073、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D6b2737204cbb58bchksm%3Dec412b15db36a203ce2a77d3fa1d9d7d2ce163e8ebaa5c6ed97e5e3150c%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&跨表求和&/a&&/p&&p&074、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dbe26fb236ab3f9a6b45bc%26chksm%3Dec412b11db36a2073dfbdd14d244f7d72f5b6314bfa981a403f5c8ab6f099f1b3e6430c2beb4%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&跨表条件求和&/a&&/p&&p&075、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Df4142cfe3faed5echksm%3Deca1fd11a75d16aac247c24ae2e3b3982%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&自动在很多表中同时提取该表的表名&/a&&/p&&p&076、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D92892aeb3e9ec9419fcecfc36abcf569%26chksm%3Dec4128cbdb36a1dd440b7b26ddc94c17c4d6310add7de315c308b50a2%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&函数综合练习（一道可以考考你函数掌握水平的题目）&/a&&/p&&p&077、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dce8da47e%26chksm%3Dec4128aadb36a1bc3b9bd6fbafaf2c16efc5bed42120ebde1b0b4c0%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&动态表格的制作&/a&&/p&&p&078、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3De7ffdc1b9ec06fdchksm%3Decaed51aa4ac2710eba5a3d21ad20d52e2b0fscene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&HR常用的Excel技巧&/a&&/p&&p&079、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D2b4ace1df51da6b10cc24f7%26chksm%3Deca16f4162dfbc8fae94c0aa43f680d21d79f4df1f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&从有重复客户记录的数据源里直接提取排名&/a&&/p&&p&080、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3D07cd1e31f9cabdaafd6afc42b3e4f73d%26chksm%3Deca1546fe47cce73d2e2d6d0f73c28860a62bda23c0c78fcf1eab66fe95d1ee47f%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&按条件从有重复记录的数据中按名次提取数据&/a&&/p&&p&081、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Da1d05fd034da608a0c45%26chksm%3Deca0a7f655cf1c84c685fb3e340a16%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_blank& rel=&nofollow noreferrer&&显示一行中出现次数最多的字符（code、char、mode）&/a&&/p&&p&082、&a href=&//link.zhihu.com/?target=http%3A//mp.weixin.qq.com/s%3F__biz%3DMzI5NjY5NjcwNg%3D%3D%26mid%3D%26idx%3D1%26sn%3Dd092fc15c3f26fefbad4e35fchksm%3Dec4129bedb36a0a8cdd0cc0b047d868e44eb07860fad8271cac7956%26scene%3D21%23wechat_redirect& class=& wrap external& target=&_bl}