如何使用通配符进行表格模糊查找？
<p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">使用</span>WPS Office<span style="font-family:微软雅黑">打开表格</span></span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">，</span></span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">全选整个区域。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: Calibri;font-size: 16px"><span style="font-family:微软雅黑">依次点击</span>“<span style="font-family:微软雅黑">开始</span><span style="font-family:Calibri">”--->“</span><span style="font-family:微软雅黑">查找</span><span style="font-family:Calibri">”</span><span style="font-family:微软雅黑">或使用快捷键</span><span style="font-family:Calibri">“Ctrl+F”</span><span style="font-family:微软雅黑">打开查找功能</span></span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: Calibri;font-size: 16px"><span style="font-family:微软雅黑">通配符</span>“*”<span style="font-family:微软雅黑">代表任意多个字符，这里在查找框输入</span><span style="font-family:Calibri">“</span><span style="font-family:微软雅黑">可乐</span><span style="font-family:Calibri">***”</span><span style="font-family:微软雅黑">，点击</span><span style="font-family:Calibri">“</span><span style="font-family:微软雅黑">查找全部</span><span style="font-family:Calibri">”</span></span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: Calibri;font-size: 16px"><span style="font-family:微软雅黑">（注意：通配符</span>“*”<span style="font-family:微软雅黑">需要在英文状态下输入）</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">即</span></span><span style="font-family: Calibri;font-size: 16px"><span style="font-family:微软雅黑">可查找出所有包含</span>“<span style="font-family:微软雅黑">可乐</span><span style="font-family:Calibri">”</span><span style="font-family:微软雅黑">的单元格。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: Calibri;font-size: 16px"> </span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: Calibri;font-size: 16px"><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/03132552bf35b18dfe20524cb81b7616.gif" title="如何使用通配符进行表格模糊查找？1.gif" alt="如何使用通配符进行表格模糊查找？1.gif"></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: Calibri;font-size: 16px"><br></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: Calibri;font-size: 16px"><span style="font-family:微软雅黑">通配符</span>“<span style="font-family:微软雅黑">？</span><span style="font-family:Calibri">”</span><span style="font-family:微软雅黑">代表一个字符，在查找内容中输入</span><span style="font-family:Calibri">“</span><span style="font-family:微软雅黑">可乐</span><span style="font-family:Calibri">???”</span><span style="font-family:微软雅黑">，点击</span><span style="font-family:Calibri">“</span><span style="font-family:微软雅黑">查找全部</span><span style="font-family:Calibri">”</span></span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: Calibri;font-size: 16px"><span style="font-family:微软雅黑">（注意：通配符</span>“*”<span style="font-family:微软雅黑">需要在英文状态下输入）</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: Calibri;font-size: 16px"><span style="font-family:微软雅黑">即可查找</span>“<span style="font-family:微软雅黑">可乐</span><span style="font-family:Calibri">”</span><span style="font-family:微软雅黑">后有三个字符的单元格</span></span><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">。</span></span></p><p><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">（注意：通配符也可放在前面使用）</span></span></p><p><br></p><p><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/bd403a56283a74cb069ea0c6ddfd3372.gif" title="如何使用通配符进行表格模糊查找？2.gif" alt="如何使用通配符进行表格模糊查找？2.gif"></p><p><br></p>
頁:
[1]