透视表没法筛选，怎么办？Excel数据透视表行标签字段值筛选选项操作教程。
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></p><span style="color: black;">Excel数据透视表行标签字段值筛选选项操作教程</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">想要对数据透视表区域进行筛选，结果<span style="color: black;">发掘</span>筛选功能未灰色，<span style="color: black;">没法</span><span style="color: black;">运用</span>，难不成做了数据透视表就<span style="color: black;">没法</span>筛选了吗？当然不是，<span style="color: black;">由于</span>Excel还给<span style="color: black;">咱们</span><span style="color: black;">供给</span>了一个更棒的功能，跟着<span style="color: black;">博主</span><span style="color: black;">excel小课堂(ID：excel-xiaoketang 长按复制)</span><span style="color: black;">一块</span>来<span style="color: black;">瞧瞧</span><span style="color: black;">怎样</span>借助行标签值筛选功能来实现透视表区域数据筛选吧！</span></span></p><span style="color: black;"><strong style="color: blue;"><span style="color: black;">案例</span></strong></span><span style="color: black;">数据表格如图中所示，想要对求和项:金额做数据筛选，结果工具栏数据-筛选选项居然为灰色，<span style="color: black;">没法</span><span style="color: black;">运用</span>，该肿么破？</span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">StepA</span></strong></span><span style="color: black;"><span style="color: black;">凡事都有利<span style="color: black;">坏处</span>，<span style="color: black;">没法</span>直接对该数值列筛选，<span style="color: black;">咱们</span><span style="color: black;">能够</span>试试曲线救国的<span style="color: black;">办法</span>。打开行标签三角按钮，<span style="color: black;">选取</span>值筛选选项，本例中<span style="color: black;">咱们</span><span style="color: black;">选取</span>“大于”。</span></span><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">StepB</span></strong></span><span style="color: black;">在弹出的“值筛选”选项卡中，<span style="color: black;">选取</span>筛选数值列“求和项：金额”，<span style="color: black;">要求</span>为“大于”，数值为“100”，点击确定按钮，就<span style="color: black;">能够</span>筛选出<span style="color: black;">咱们</span>需要的<span style="color: black;">营销</span>额大于100的<span style="color: black;">制品</span><span style="color: black;">营销</span>记录了。</span><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span><span style="color: black;"><img src="data:image/svg+xml,%3C%3Fxml version=1.0 encoding=UTF-8%3F%3E%3Csvg width=1px height=1px viewBox=0 0 1 1 version=1.1 xmlns=http://www.w3.org/2000/svg xmlns:xlink=http://www.w3.org/1999/xlink%3E%3Ctitle%3E%3C/title%3E%3Cg stroke=none stroke-width=1 fill=none fill-rule=evenodd fill-opacity=0%3E%3Cg transform=translate(-249.000000, -126.000000) fill=%23FFFFFF%3E%3Crect x=249 y=126 width=1 height=1%3E%3C/rect%3E%3C/g%3E%3C/g%3E%3C/svg%3E" style="width: 50%; margin-bottom: 20px;"></span><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">StepC</span></strong></span><span style="color: black;">除了对数值字段进行筛选，还<span style="color: black;">能够</span>对行标签<span style="color: black;">自己</span>进行筛选。<span style="color: black;">选取</span>行标签三角按钮-标签筛选，设置筛选<span style="color: black;">要求</span>为“<span style="color: black;">开头不是</span>”</span></span><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/GCEv3IwJAIGChbQWa6bzODibLexXekztU1udic3JSrgjyPRMsia307oWFibEFRTQQAib5DCg7ia0gHnicEdgic92qJxX2Q/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">StepD</span></strong></span>在弹出的标签筛选选项框中，设置<span style="color: black;">要求</span>为“陶瓷”，就<span style="color: black;">能够</span>筛选出前两个字不是“陶瓷”的<span style="color: black;">制品</span>的销量纪录了。</span><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/GCEv3IwJAIGChbQWa6bzODibLexXekztU9AOW0bibZNYbHJu4IKmdeNVv9j70QEL1z0Rj7ibPHibFPOicu5WYsNSsHg/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/GCEv3IwJAIGChbQWa6bzODibLexXekztUeYRzcqAWCBQ9Lp4FUlRC8HDAIRPzWpp9O6vlwzv2lVuSib4KWtzoawA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span><span style="color: black;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">StepE</span></strong></span><span style="color: black;">一不小心，筛选<span style="color: black;">要求</span>写错了，该怎么办呢？<span style="color: black;">能够</span><span style="color: black;">选取</span>行标签三角按钮-从“宝贝名<span style="color: black;">叫作</span>(行标签字段名)”中清楚筛选来删除。</span></span><span style="color: black;"><img src="http://mmbiz.qpic.cn/mmbiz_jpg/GCEv3IwJAIGChbQWa6bzODibLexXekztU6OKdYmyouSLG3G1v5WkKia0B50qPgUNevicMGplyibCic97bywTbarm1FA/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></span><span style="color: black;">关注</span><span style="color: black;">excel小课堂(ID：excel-xiaoketang 长按复制)</span><span style="color: black;"><span style="color: black;">微X</span>号，</span><span style="color: black;">学好excel，<span style="color: black;">加强</span>职业素养，<span style="color: black;">提高</span>职场竞争力，升职加薪<span style="color: black;">再也不</span>是梦！</span><img src="http://mmbiz.qpic.cn/mmbiz/iaGswicCbWm69Z6SNia7MWIAVvMkvMlMO4TLQ4klf25y4M63aGdCNwSazxPH37vmB7R1cCUa9GDCdlCH49MhHLxsQ/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><img src="http://mmbiz.qpic.cn/mmbiz/GCEv3IwJAIFr8Yr5dbZC0S1I1n6HkuOKuR82opuWxoLRuDqKyG1P82CA3VDCoGYucBPricJJMeCqelb1rUC8o6Q/640?wx_fmt=jpeg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">
你的努力一定会被看见，相信自己，加油。 你的见解真是独到，让我受益良多。
页:
[1]