id: e642bd4e83d641238d49972a412e3bdb
parent_id: 
item_type: 1
item_id: 92953dd39ce447e7bb294d4d74fceef0
item_updated_time: 1764345480612
title_diff: "[{\"diffs\":[[1,\"Excel大神直播全记录！教你15个效率百倍的技巧\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":25}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>Excel大神直播全记录！教你15个效率百倍的技巧</title>\\\r\\\n  <basefont face=\\\"微软雅黑\\\" size=\\\"2\\\" />\\\r\\\n  <meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html;charset=utf-8\\\" />\\\r\\\n  <meta name=\\\"exporter-version\\\" content=\\\"YXBJ Windows/608924 (zh-CN, DDL); Windows/10.0.0 (Win64); EDAMVersion=V2;\\\"/>\\\r\\\n  <style>\\\r\\\n\\tbody, td {\\\r\\\n\\t  font-family: 微软雅黑;\\\r\\\n\\t  font-size: 12pt;\\\r\\\n\\t}\\\r\\\n  </style>\\\r\\\n</head>\\\r\\\n<body>\\\r\\\n<a name=\\\"16228\\\"></a>\\\r\\\n<h1>Excel大神直播全记录！教你15个效率百倍的技巧</h1>\\\r\\\n\\\r\\\n<div><span style=\\\"margin:0px;\\\"><div style=\\\"padding:8px 0px;margin:8px auto;max-width:700px;\\\"> <div style=\\\"background-color:#fff;padding:20px 16px 12px;margin:0\\\"><div style=\\\"margin:0;padding:0\\\"><h2 style=\\\"font-weight:400;margin:0;padding:0;font-size:22px;line-height:1.4;margin-bottom:14px\\\"> Excel大神直播全记录！教你15个效率百倍的技巧 </h2><div style=\\\"margin:0;padding:0;margin-bottom:22px;line-height:20px;font-size:0;word-wrap:break-word;word-break:break-all\\\"><span style=\\\"padding:0;display:inline-block;vertical-align:middle;margin:0 10px 10px 0;font-size:15px;-webkit-tap-highlight-color:rgba(0,0,0,0);margin-right:0;color:rgba(0,0,0,0.3)\\\">原创：</span><span style=\\\"padding:0;display:inline-block;vertical-align:middle;margin:0 10px 10px 0;font-size:15px;-webkit-tap-highlight-color:rgba(0,0,0,0);color:rgba(0,0,0,0.3)\\\"> 方骥老师 </span><span style=\\\"padding:0;display:inline-block;vertical-align:middle;margin:0 10px 10px 0;font-size:15px;-webkit-tap-highlight-color:rgba(0,0,0,0);position:relative\\\"><a style=\\\"margin:0;padding:0;color:#576b95;text-decoration:none;-webkit-tap-highlight-color:rgba(0,0,0,0)\\\"> 秋叶PPT </a></span><em style=\\\"padding:0;font-style:normal;display:inline-block;vertical-align:middle;margin:0 10px 10px 0;font-size:15px;-webkit-tap-highlight-color:rgba(0,0,0,0);color:rgba(0,0,0,0.3)\\\"></em></div><div lang=\\\"=&quot;en&quot;\\\" style=\\\"margin:0;padding:0;overflow:hidden;color:#333;font-size:17px;word-wrap:break-word;-webkit-hyphens:auto;-ms-hyphens:auto;hyphens:auto;text-align:justify\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><img src=\\\":/7a5da664c9a2446682889023db40a199\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;text-align:justify\\\"/><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">要提高Excel的操作效率，这个话题很大，方法也有很多，但其中有一个套路，它的道理很简单却又在很多地方都普遍适用，那就是：批量化。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">批量化，是提升操作效率的一道捷径，高手都会使用批量化操作，去代替重复的单个操作。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">所以，我们今天主要聊一聊批量化操作中的两个关键套路：批量化的对象选取和批量化的数据处理。</span></p><div style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h1 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px;font-size:28px\\\">/ 1 /</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66);letter-spacing:0.5px;font-size:16px\\\">批量化的对象选取</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p></h1></div><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><img src=\\\":/741f4dc995254580a4e2ca622b5389a3\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" height=\\\"344.25px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"612px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">对象选取有三个常用场景和套路：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em;text-indent:2em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❶ </span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">选取连续相邻的对象，巧用SHIFT键</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em;text-indent:2em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❷ </span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">粗暴直接的全体选取，多用CTRL+A</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em;text-indent:2em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❸ </span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">选取特定条件的对象，利用定位功能</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❶</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">SHIFT键的应用</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">使用场景：选取目标在空间上是连续的，且彼此相邻。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">操作方法：先选中第一个对象，再按住SHIFT键的同时，去选取最后一个对象。这样就可以把这两端当中的所有连续对象一次性全部选中。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">举两个具体案例。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例1】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">表格区域的选取</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(136,136,136)\\\">要求：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">把第900行以后的表格内容复制到另一个工作表中。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(136,136,136)\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(136,136,136)\\\">普通小白操作：</span></strong><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">先找到第901行，选中这一行之后，按住鼠标左键，然后向下拖拽，直到最末一行。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\">            </p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-left:8px;margin-right:8px\\\"><img src=\\\":/50210837465d4ce98356aef37798c5dc\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(136,136,136)\\\">存在的问题：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">这个过程当中必须始终保持按住左键，一旦松开了按键，那就前功尽弃了。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(217,33,66)\\\">高效操作：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①选中第901行；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②拖动右侧的滑动条快速找到最末一行；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③按住SHIFT键的同时，去选取最末这行。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/f4fa1fee2d894cbda705d651e5e24cc4\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"344px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"412px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例2】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">多个工作表的选取</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">要求：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">有一个记录全年销售数据的表格文档，每个月的数据单独存一个工作表，1、2、3三个月的表格都已经填好，现在想要继续添加其他月份。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/f8878b25468c4412b372494419fe98a2\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"331px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"465px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">普通小白操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">老老实实一个一个地插入新的工作表了，然后把表头内容再一个一个的复制粘贴到这些新表上面。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">高效操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①点击第一个工作表的标签；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②按住SHIFT键，去点击最后这个工作表的标签；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③选中了所有中间这些工作表后，单击右键鼠标选择【移动或复制】，直接复制出同样数目的一批工作表。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">如果需要</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">批量修改表头的内容或格式</strong></span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">，也可以借助批量选取：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①点击第一个工作表的标签；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②按住SHIFT键，再去点击最后的标签；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③批量选中所有的工作表，这些工作表形成了一个【组】；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">④在【组】的状态下，想改啥改啥！改单个表，所有选中的表都会改变。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">如果想把</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">12个月份的数据汇总形成全年</strong></span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">的总计，求和公式其实也可以用到神奇的SHIFT键：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①新建全年汇总工作表，表头与月份的表头一致；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②选中全年汇总工作表的单元格，输入求和函数SUM；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③求和公式中，先单击第一个工作表，按住SHIFT，选中最后一个工作表；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">④输入单元格D3名称，完成公式后回车。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-left:8px;margin-right:8px\\\"><img src=\\\":/b5dc6967a5a04abea081d932ddfa7dd7\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">掌握了这个SHIFT批量选取工作表的套路之后，很多操作都可以一次性完成了，比如设置标签颜色、同时删除多个工作表等等。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❷</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">CTRL+A的应用</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">使用场景：把某个范围内的所有对象统统都选中。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">操作方法：简单粗暴，先选取其中一个对象，然后按下CTRL+A组合键，A就是All的意思。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例3】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">表格区域的选取</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">要求：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">把整个数据表的范围给选中。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">高效操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">在数据表的范围内先选中一个单元格对象，然后按下CTRL+A组合键，Excel就会自动判断出整个数据表的边界范围并帮我们选中它。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-left:8px;margin-right:8px;text-align:center\\\"><img src=\\\":/9ff5dd103ac34ccda480f824131ec320\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">这种自动判断边界的功能非常实用，如果同一个工作表当中存放了多个数据表格，只要他们之间留有空间，使用CTRL+A就能非常准确的选中当前的表格范围，不会影响到其他表格。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例4】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">批量设置单元格</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">要求：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">把下面表格里的黄颜色单元格，全部改成蓝色，或把这些单元格里的内容都删掉。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/45604c4731f74dc2a98dec7cd0ec87e1\\\" type=\\\"image/png\\\" data-filename=\\\"640.png\\\" height=\\\"387px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"348px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">小白操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">一个个选中，一一修改。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66);font-size:15px;letter-spacing:0.5px\\\">高效操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">利用【查找】功能找出所有黄色单元格批量处理。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①CTRL+F，调出【查找】选项卡；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②点击【选项】，【格式】下拉列表中选择【从单元格选择格式】；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③光标变成带有一根吸管的图标时，从黄色单元格里吸取它的格式设置；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">④回到查找选项卡，选择【查找全部】，列表上出现了所有这种格式的单元格；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">⑤CTRL+A，即选中所有黄色单元格，接下来想怎么改就怎么改~</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/9a5356cbaaf643dc8b548536e8bddf74\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"473px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"441px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例5】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">全选所有图片</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">要求：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">表格里图片比较多的时候，如何批量选中图片，对图片进行整理？</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(217,33,66)\\\">高效操作：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①先选中一个图片；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②CTRL+A组合键，就会选中所有图片。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;margin-left:8px;margin-right:8px\\\"><img src=\\\":/6a41f4e4fd41418faa9a06e3dd64051e\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">接下来想要修改大小或是调整摆放位置，都会很轻松。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❸</span></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">定位功能的应用</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">使用场景：</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">根据单元格的不同属性特征，有目标的选中其中某一类单元格。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">具体操作：</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">用CTRL+G或F5打开定位功能。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">常用的可以区分不同单元格类型的条件包括：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/fa1eac66d5c54c6db1bc1b45730e9bc1\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" height=\\\"344.25px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"612px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><ul style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;padding-left:2.2em;margin-left:8px;margin-right:8px\\\"><li style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">空值：空白单元格（无内容）</span></p></li></ul><ul style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;padding-left:2.2em;margin-left:8px;margin-right:8px\\\"><li style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">常量：单元格有内容（不含公式）</span></p></li></ul><ul style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;padding-left:2.2em;margin-left:8px;margin-right:8px\\\"><li style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">公式：含公式的单元格</span></p></li></ul><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">一个单元格要么是空值，要么是常量，要么就是公式。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例6】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">批量求和</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">要求：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">下列表格中，每个地区的数据行下方有一行空白的汇总行需要进行求和统计。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/166cd6635f0043df87c07b80be558dd9\\\" type=\\\"image/png\\\" data-filename=\\\"640.png\\\" height=\\\"370px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"374px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">小白操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">每一个汇总行一个一个去做求和运算。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">高效操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">利用定位功能选出所有的空白行，接着再使用快速求和的快捷键。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①用SHIFT键快速选中数据范围；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②CTRL+G，打开定位功能，【定位条件】选择【空值】；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③ALT+=组合键，快速求和！（excel自动判断求和对象）</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-left:8px;margin-right:8px;text-align:center\\\"><img src=\\\":/cadb69ee5f26413c8bbd85ac78770372\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">如果想要把刚才这些求和汇总的行统统标上黄色，也可以用定位功能。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①选中这个表格中的一个单元格，按下CTRL+G，打开定位功能；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②【定位条件】选择【公式】，就能全部选择汇总行；（因为这些汇总行是由公式产生的）</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③修改颜色即可。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/7080b607f3384d0eae2674092b011624\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"485px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"399px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">所以说，在Excel的使用当中，经常是你在全力做到最好，还不如别人随便搞搞！找对思路找对方法才是最快捷的手段。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px;font-size:28px\\\">/ 2 /</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:16px;color:rgb(217,33,66);letter-spacing:0.5px\\\">批量化的数据整理</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/e438f981a1d84bccafeb3e5daf129ae5\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" height=\\\"344.25px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"612px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">数据的整理，通常包括内容的拆分、替换、合并和转换等等，想要进行批量化的整理，最常用的套路也有三个：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em;text-indent:2em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❶ </span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">数据拆分和类型转换：</strong><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">巧用分列功能</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em;text-indent:2em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❷ </span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">数据拆分及合并处理</strong>：<strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">善用快速填充</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em;text-indent:2em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❸ </span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">随心所欲的数据整理：</strong><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">灵活运用公式</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❶</span></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">分列功能</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">使用场景：对文字内容进行拆分，把一列单元格当中的文字内容拆分成几列。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例7】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">分隔符拆分</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(136,136,136)\\\">要求：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">把下面这个表格中的地址信息按照省、市、区三级拆开，放在不同列中。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/ed370c685aec4f8eb54f8f80a1424255\\\" type=\\\"image/png\\\" data-filename=\\\"640.png\\\" height=\\\"404px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"259px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">小白操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">一个个单元格地去处理。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(217,33,66)\\\">高效操作：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">借助分列功能的按照【分隔符号】拆分，本案例中的分隔符是「-」。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①选中要拆分的单元格；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②在【数据】选项卡里打开【分列】；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③选择【分隔符号】的拆分方式；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">④分隔符号填入「-」，点击完成。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/6d6fd71decf04913aba81233419b8dd0\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"458px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"391px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例8】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">证件号码拆分</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">要求：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">从一组身份证号码当中把出生年份分离出来。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">高效操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">借助分列功能的按照【固定宽度】拆分。如果不同数据行需要切割的位置，字符个数相同，就可以用【固定宽度】处理。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①选中需要拆分的单元格；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②【数据】选项卡中打开【分列】；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③选择拆分方式为【固定宽度】，进入下一步；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">④用鼠标点击要拆分的字符位置，确认无误后点击完成。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/e552a166c46b4529b46575fa432837f5\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"462px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"394px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">以上就是分列功能的两种常规用法：按【分隔符号】拆分和按【固定宽度】拆分。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">但它其实还有一个不为人知的隐秘功能，可以用来转换文本型数值和不规范的日期。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例9】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">文本型数值转换</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">要求：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">下图中的单元格的值，看着像数字，实际上是文本，所以不能进行诸如求和的公式运算。如何将它们由文本变成数字呢？</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/c4b1e33ac65e410494b9b2f212c9eca9\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"465px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"386px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">小白操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">一个个单元格去重新输入数字。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">高效操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">通过分列功能，高效地完成批量转换。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①选中要转换的单元格；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②【数据】选项卡选择【分列】；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③点击完成，一键搞定！</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/fab209a7e97549da97f2211432fa1942\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"500px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"415px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例10】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">不规范日期转换</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">要求：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">Excel中除了【年-月-日】和【年/月/日】格式的日期都是不规范的，不规范的日期excel不能使用排序、筛选、统计等日期相关功能，那如何快速把这些不规范日期变规范呢？</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/b165b80fb4a14873b5b18ec65f483493\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"490px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"455px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px\\\">高效操作：</span></strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①选中数据单元格，打开【分列】；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②分列设置的前两步都是默认设置；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③在第三步的【列数据格式】中选择【日期】，点击完成。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/ef4764938bcd414091c7b71c0af32105\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"462px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"429px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❷</span></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">快速填充</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">使用场景</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">：没有分隔符，也不是固定宽度的字符数，需要拆分时使用快速填充。给一个单元格的拆分范例，excel能根据这个范例进行拆分处理。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">具体操作</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">：CTRL+E快捷键。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">说       明：快速填充是Excel 2013及以上版本支持的新功能。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例11】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">联系人电话拆分</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(136,136,136)\\\">要求：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">一组联系人姓名和电话号码的信息，存放在同一列当中，要求把人员姓名和电话拆分成两列。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(217,33,66)\\\">高效操作：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①制作范例，将第一行中的联系人姓名和电话分别复制出来放置在右侧两列中；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②选中姓名这列当中的单元格，按下CRTL+E，自动拆分出所有的姓名；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③选中电话这列当中的某个单元格，然后CTRL+E快速填充，完成！</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/bc6e6ad7bbc7498f9d664c7ddd168313\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"376px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"453px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例12】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">身份证号码提取出生年份</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(217,33,66)\\\">高效操作：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①在第一行，手动填入年份；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②选中年份这列的单元格，CTRL+E快速填充。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/9df11a95dae34d189b2ded5aeca719d1\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"435px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"402px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例13】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">两列合并成一列</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(217,33,66)\\\">高效操作：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①在第一行，手动将联系人和电话合并，并添加一个符号；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②选中合并这一列的单元格，CTRL+E快速填充。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/ffd5a5f4fcf344729b808f99cf4464f2\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"452px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"418px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例14】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">多段内容交换位置</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(217,33,66)\\\">高效操作：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①在第一行，手动填入转换后的值；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②选中转换后这列的单元格，CTRL+E快速填充。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/8d415c5c9afd44c6b223a851b23a0d43\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"334px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"442px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(89,89,89)\\\">❸</span></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">函数公式</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:center;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">使用场景</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">：公式可以自动填充，适合批量处理数据。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">具体操作：</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">LEFT、MID、RIGHT等文本处理函数以及一些常用的日期转换函数的操作使用。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例15】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">证件号码提取内容</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">MID函数法：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①输入函数MID；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②填入MID函数的三个参数，分别是要处理的文字对象、开始提取的字符位数、需要提取的字符数（身份证第7位开始的4位数字是出生年份）；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③双击填充柄，自动填充。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/db6bb0b3cb6f4f6a8b0f42636dd7cc1d\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"361px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"427px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">如果想要从前面得到的年份推算出当前的年龄，只需要在原有公式上增加计算年龄的条件。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">比如输入，“=YEAR(NOW())-MID(C4,7,4)”。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">所以，公式可以根据需求进行扩展，适合一些更加复杂的数据整理工作。</span></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">【案例16】</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">数据显示格式转换</span></p></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(136,136,136)\\\">要求：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">一列数字，将它以万为单位显示。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;letter-spacing:0.5px;color:rgb(217,33,66)\\\">高效操作：</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">借助TEXT函数来实现，TEXT函数的第2个参数可以设置数据显示的具体格式。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">①输入函数TEXT；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">②填入TEXT函数的2个参数：要处理的单元格和数据显示格式，“0!.0000万”；</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">③自动填充。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span><img src=\\\":/84d37753668a4707a738fc2323bd696f\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" height=\\\"auto\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial\\\" width=\\\"414px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">如果想要让数字变成中文大写显示，只需改一下格式代码。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">把“0!.0000万”换成“[dbnum2]”。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">你也可以试试“[dbnum1]”是什么数字格式哦~</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">所以，如果你想让Excel更听话，让它变出更多花样来，那就不妨跟着我们多学点函数吧~</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">批量化的对象选取和数据处理你都学会了吗？</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">怕忘记，没关系！</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">收藏文章，随查随用吧~</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;text-align:justify;margin-left:8px;margin-right:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><h2 style=\\\"font-weight:400;font-size:16px;margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"></h2><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;color:rgb(51,51,51)\\\"><img src=\\\":/f469e2aae77a4341be3335ed179ad62b\\\" type=\\\"image/png\\\" data-filename=\\\"640.png\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;width:auto !important;visibility:visible !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(51,51,51)\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(51,51,51)\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">而工作中，我们需要解决的不仅仅是一个小问题，而是由无数小问题汇成的大问题！</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(51,51,51)\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\">单单掌握几个Excel 技巧远远不够，我们需要系统地学习 Office 办公技巧，才能以不变应万变！</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(51,51,51)\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><div style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(51,51,51)\\\"><div style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px;line-height:1.75\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">我们的课程老师给大家收集整理了168个 Office 小技巧，录制成3-5分钟的小视频，即查即用，秒秒钟帮你解决难题。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66);letter-spacing:0.5px\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;margin-right:2px;margin-left:2px;width:inherit;height:inherit;color:rgb(63,63,63);letter-spacing:0.5px\\\"><img src=\\\":/0db33b606c05459998032c9ea4bcc30d\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" height=\\\"279.114px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial;width:auto !important;visibility:visible !important\\\" width=\\\"612px\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63);letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63)\\\">少侠，你可以顺着学，也可以挑着学，</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63);line-height:1.5em\\\">要的就是 </span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66);line-height:1.5em\\\">快！速！搞！定！</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px;color:rgb(63,63,63)\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(51,51,51)\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63)\\\">经过大量的搜集整理，</span>结合多年的答疑经验，</span>我们的课程开发老师们优选了 20 个能够显著提升效率的办公神器，更新到了这个课程中。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em;text-align:center\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;width:inherit;height:inherit;letter-spacing:0.5px\\\"><img src=\\\":/1fbfa22c9ecd48568a4e5721854e3db1\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" height=\\\"199px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial;box-shadow:none;width:319.766px !important;visibility:visible !important\\\" width=\\\"354px\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63);letter-spacing:0.5px;line-height:1.5em\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em;text-align:center\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">618返场特惠！</strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px;color:rgb(63,63,63);text-decoration:line-through\\\">原价 399 元</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em;text-align:center\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63)\\\">现在</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63);line-height:1.5em\\\">券后只需</span></span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66);letter-spacing:0.5px;line-height:1.5em\\\">329</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px;color:rgb(217,33,66)\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;line-height:1.5em\\\"></span> </span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">元</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63);letter-spacing:0.5px\\\">，扫码直达</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;text-align:center;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">▼</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-left:8px;margin-right:8px\\\"><img src=\\\":/2d9b2e35ab0a476183a16efd97e020f2\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;border-radius:6px\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63);letter-spacing:0.5px\\\">学一门课程，把一众名师请到身边！</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;margin-right:2px;margin-left:2px;width:inherit;height:inherit;color:rgb(63,63,63);letter-spacing:0.5px\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><img src=\\\":/85431ae82e974b39ad8f41c40f2782cb\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;border-radius:8px;box-shadow:rgb(170,170,170) 0 0 14px 0;width:auto !important;visibility:visible !important\\\" width=\\\"auto\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63);text-align:center;letter-spacing:0.5px\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;text-align:center;line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">你还可以加入三合一课程</span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px;color:rgb(217,33,66)\\\">专属微信学员群</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">，由我们的答疑天团帮你解决各种疑难杂症。</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;color:rgb(79,79,79)\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">学完课程，你也能轻松搞定各种文档的排版制作：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">﻿</span><img src=\\\":/75b08b3bd78d4940a4dfcd2d8551522a\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" height=\\\"362.912px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial;width:auto !important;visibility:visible !important\\\" width=\\\"611.989px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;color:rgb(79,79,79)\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">快速处理数据，制作报表：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">﻿</span><img src=\\\":/bffb86b5c32f4d71ac5af14d7d795049\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" height=\\\"402.457px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial;width:auto !important;visibility:visible !important\\\" width=\\\"611.989px\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">让汇报演示更加出彩：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">﻿</span><img src=\\\":/d43ae5d5d4de4177b55c17a850c715cd\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" height=\\\"327.656px\\\" style=\\\"padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;margin:initial;transform:initial;width:auto !important;visibility:visible !important\\\" width=\\\"611.989px\\\"/><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">﻿</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;color:rgb(79,79,79)\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">叠加用券</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px;color:rgb(217,33,66)\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">立减70</strong></span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">！</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">现在购课只需</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px;color:rgb(217,33,66)\\\">329元</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">，还可享有以下<strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">重磅福利</strong>：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79);line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\"></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;margin-right:2px;margin-left:2px;letter-spacing:0.5px;width:inherit;height:inherit\\\"><img src=\\\":/566a7c6d4cb5418a980b56ebf9e85495\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;width:451.438px;border-radius:12px;visibility:visible !important\\\" width=\\\"99%\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;color:rgb(79,79,79)\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-left:8px;margin-right:8px\\\"><img src=\\\":/09503fb213b3437cb7ac2b9840380054\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;border-radius:6px\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">除了以上优惠，今天购课，你还可以获得【三合一课程<strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">独享礼</strong>】：</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\">【独享福利1】</span></strong><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\">额外送课程图书一本</strong></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">从秋叶王牌 Word/Excel/PPT图书中任选一本</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><img src=\\\":/2c338958bddb4e549ffdb156efce1700\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;box-shadow:rgb(170,170,170) 0 0 1em 0;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(217,33,66)\\\">【独享福利2】</span></strong></span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">超值福利大礼包</span></strong></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px\\\">848 套办公范本+110 套精选模板+海量素材包</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><img src=\\\":/573124f67f2c49aaacbcb14e2f0725bf\\\" type=\\\"image/jpeg\\\" data-filename=\\\"640.jpg\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;box-shadow:rgb(170,170,170) 0 0 1em 0;visibility:visible !important;width:auto !important\\\" width=\\\"auto\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px;color:rgb(63,63,63)\\\">福利多多，购课后戳公众号底部【人工客服】，</span><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(63,63,63);letter-spacing:0.5px\\\">联系客服小姐姐，通通一次给足！</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;letter-spacing:0.5px;color:rgb(63,63,63)\\\">一次购买，不限时间，不限次数，随时学习。</span></strong></p><div style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:17px;letter-spacing:0.544px\\\"><div style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"><div style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:14px\\\"><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136)\\\">特别提示： 苹果的 iPhone/iPad 上的 网易云课堂 app 购买课程，不参与实物活动（送书、送鼠标垫）！ 建议从微信公众号进入购买！</span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136);letter-spacing:0.5px\\\">点击【</span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136);letter-spacing:0.5px\\\">阅读原文</strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136);letter-spacing:0.5px\\\">】，立即享特价购买【</span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136);letter-spacing:0.5px;text-align:center\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;font-size:15px\\\">Word+Excel+PPT 三合一</span></strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136);letter-spacing:0.5px\\\">】课程，</span><strong style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136);letter-spacing:0.5px\\\">一共可领两本赠书，</strong><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136);letter-spacing:0.5px\\\">更有多重福利等你来拿！</span></p></div></div></div><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><span style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;color:rgb(136,136,136);font-size:14px;letter-spacing:0.5px\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></span></p><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em;margin-right:8px;margin-left:8px;line-height:1.5em\\\"><img src=\\\":/88e6d32de5144e618b3d5a7de04f54d2\\\" type=\\\"image/gif\\\" data-filename=\\\"640.gif\\\" style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;height:auto !important;font-size:16px;visibility:visible !important;width:640px !important\\\" width=\\\"auto\\\"/></p></div></div><p style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important;clear:both;min-height:1em\\\"><br style=\\\"margin:0;padding:0;max-width:100% !important;box-sizing:border-box !important;-webkit-box-sizing:border-box !important;word-wrap:break-word !important\\\"/></p></div></div><ul style=\\\"margin:0;padding:0\\\"></ul><div style=\\\"padding-top:15px;margin:0;padding:0\\\"><a href=\\\"https://mp.weixin.qq.com/s?__biz=MjM5MDgxNjc0MA==&amp;mid=2651000425&amp;idx=3&amp;sn=0bd1ba2e57cd4d7bdfb8f9bdc97084e3&amp;chksm=bd48aee28a3f27f4437b0adc201d8e25ac3ae4e6f4a8947012c00e7341e69dab4dad5ed68b7e&amp;mpshare=1&amp;scene=1&amp;srcid=0628euJgTLHpXVnwy5H5Enrj##\\\" style=\\\"margin:0;padding:0;color:#576b95;text-decoration:none;-webkit-tap-highlight-color:rgba(0,0,0,0)\\\">阅读原文</a></div></div></div></span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":253423}]"
metadata_diff: {"new":{"id":"92953dd39ce447e7bb294d4d74fceef0","parent_id":"061de1401cfc4cfaadf6e74e015970e9","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin-desktop","source_application":"net.cozic.joplin-desktop","application_data":"","order":1764345719042,"markup_language":2,"is_shared":0,"share_id":"","conflict_original_id":"","master_key_id":"","user_data":"","deleted_time":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2025-11-28T16:12:40.389Z
created_time: 2025-11-28T16:12:40.389Z
type_: 13