怎么样才可将 Excel 数据透视表的所有归类汇总行单独筛选出来？-天涯论坛

4lqedz 发表于 2024-10-1 09:07:11

怎么样才可将 Excel 数据透视表的所有归类汇总行单独筛选出来？

<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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;">教育</span>，从最<span style="color: black;">基本</span>的概念<span style="color: black;">起始</span>，一步步由简入繁、从入门到精通，系统化地讲解 Excel 的各个知识点。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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> Excel <span style="color: black;">能手</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">解答读者问题：<span style="color: black;">怎样</span>只筛选出数据透视表中的<span style="color: black;">归类</span>汇总行？</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">案例：</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">将下图 1 的数据表制作成数据透视表，<span style="color: black;">而后</span>仅筛选出所有<span style="color: black;">归类</span>汇总项。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">效果如下图 2 所示。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/6581697ba90b4f9a949baa52bd84a727~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=x1kBMgsNcxEWI328%2FC0xsjMwVRs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/632e2bd3773847b8a508b672d07022ba~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=aLRvNOgNkhz2tP2OhMrXlSPjfSg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><span style="color: black;">处理</span><span style="color: black;">方法</span>：</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1. 选中数据表的任意单元格 --> <span style="color: black;">选取</span>工具栏的“<span style="color: black;">插进</span>”-->“数据透视表”</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b9f5dec1bae4492d841c55fd31c5eb9c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=RZo0ZZsU5e%2BuXnf%2BrTF914BS8QA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2. 在弹出的对话框中<span style="color: black;">选取</span>“现有工作表”及所需上传至的位置 --> 点击“确定”</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2fb1c3a0ea804afbb2a9be07681e8eee~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=NM3vEpuUzhUcAzfGzOlLyxOWUlk%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3. 在右侧的“数据透视表字段”区域按以下方式拖动字段：</p>行：“月份”、“<span style="color: black;">分部</span>”列：“数值”值：“获客数”、“流失数”<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b1795de38dd64f2dab30abb5df56a783~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=tb%2B8LgLF9xrrMBJXwR1cfQ6Cqz8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/453bbb629adc4a359d9bd7a481cdbe83~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=1bPVkgJZK9jJKYq1aKlR3QSUO%2Bo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4. 选中数据透视表的任意单元格 --> <span style="color: black;">选取</span>工具栏的“设计”-->“<span style="color: black;">归类</span>汇总”-->“在组的底部<span style="color: black;">表示</span>所有<span style="color: black;">归类</span>汇总”</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5b696973cac84e788be464a2a377563d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=MYYCx9zPD%2BHYLz1B8Y0pB%2F%2BEQtU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/9ff9efce15b3422a829951a5619df306~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=gi%2BxWBGcM1gvWHA4OGdxnHAZ9CU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">此刻</span>试着<span style="color: black;">这般</span>筛选一下。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">5. 点开“行标签”的筛选钮 --> 在弹出的菜单中<span style="color: black;">选取</span>“标签筛选”-->“结尾是”</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/17ba9a7b2c2d48ed9a28783e32363e79~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=B3dj0YvxT6xEVQWKbmnXbeC53pE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">6. 在弹出的对话框中输入“汇总”--> 点击“确定”</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/10ce8e82f0c54b288f8ed737909b3012~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=qVVaeG1XTGBvTPLL71ynOmCBIwM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">然则</span>什么都没筛选出来，<span style="color: black;">为何</span>呢？<span style="color: black;">由于</span>这种方式只能筛选出值字段本身所<span style="color: black;">包括</span>的数据，而不是系统生成的文字。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/b782f92f16ee4a70ad48c4f18f8ce2c7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=gpGnhulVb645W45%2FO7wMz7Ul7qo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">下面是两种正确的筛选方式。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1. 先清除刚才的筛选。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/1ab274d08f7442eab7e355ed7536aa88~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=3jfQkpNHgHf8NgbZnrugu7R%2FLK0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2. 选中数据透视表标题右边的空单元格 --> <span style="color: black;">选取</span>工具栏的“数据”-->“筛选”</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/62a5942d072f48dfad1ccff268d87def~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=zrR5lQ27uQeF%2Fxt%2FXqT%2FleG3jEg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c906a4ceefe4444fb417e9911477b29b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=oKRL2J1I7NciOJmGCrGfiZ8wS3s%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3. 点开“行标签”的筛选钮 --> 在文本区域输入“汇总”--> 点击“确定”</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/cf3465bf65ba484398edae927daf899c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=sZDrMIa48I2nqMIkQX8CzxtrAzs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">成功。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/243a8484d8554589928538fac4c57675~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=YrRTP3YRZ2ioSbai7t8AAIQ9ziU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">下面是第二种<span style="color: black;">办法</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1. <span style="color: black;">选取</span>“行标签”列的任意单元格 --> <span style="color: black;">选取</span>工具栏的“数据透视表分析”-->“折叠字段”</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4f826c63711e40429c73d540f6e963e2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=3rzslYxD%2FucOfGTDI9qsc0RUOTY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">以略微<span style="color: black;">区别</span>的形式筛选出来了。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/fba2b0a452254022a1e4ccb9b5ad22a8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=AtTS12wYrUbdmGArvJ0IMkUi7%2Fs%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2. <span style="color: black;">倘若</span>要取消筛选，<span style="color: black;">能够</span>再次选中“行标签”的任意单元格 --> <span style="color: black;">选取</span>工具栏的“数据透视表分析”-->“展开字段”</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/9bf455532c724021bd93f9e1b020d3b3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=foGn4vhJfnyyL01Ry4ffOppdnrU%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4f5860638c554d9082305855e2aa3bbf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=CjZeZEG8s2IYhiSMKIstzL3lrlo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/1f15886cdb004549a7630ed3b42015b0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727954461&x-signature=UTjAQRYGuTMJU9fHbN2rSSab1SY%3D" style="width: 50%; margin-bottom: 20px;"></div>

1fy07h 发表于 2024-10-1 13:47:03

你的见解独到，让我受益匪浅，非常感谢。

1fy07h 发表于 2024-10-19 16:42:03

外贸B2B平台有哪些？

b1gc8v 发表于 2024-11-3 02:00:11

一看到楼主的气势，我就觉得楼主同在社区里灌水。

1fy07h 发表于 2024-11-13 20:35:50

seo常来的论坛，希望我的网站快点收录。

页: [1]

天涯论坛's Archiver

怎么样才可将 Excel 数据透视表的所有归类汇总行单独筛选出来？