Excel数据透视表之六【数据透视表基本操作】
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1、重命名数据透视表</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（1）<span style="color: black;">经过</span>【数据透视表分析】>【数据透视表】直接修改名<span style="color: black;">叫作</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（2）<span style="color: black;">经过</span>打开数据透视表选项对话框修改，<span style="color: black;">而后</span>确定。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/1d7feb24b0914667b55a485019717867~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=%2FX35vD0JUwzxcU2VdiSI8rAcIRY%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2、数据透视表选项设置</h1>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（1）两种数据透视表选项对话框的打开方式</h1>
<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>【数据透视表分析】>【数据透视表】->【选项】</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7ec2c81dde5545509d304ace3cc96dfd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=uzO6EbJzKXu%2BBynkxZGRitPvtko%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 style="color: black;">亦</span>可打开选项对话框。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/9acbd73b52a8445c80529245ef91ac35~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=Ej%2BlpIuh6arHQKNTlWfOqm6%2By%2FA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（2）合并切居中<span style="color: black;">摆列</span>带标签的单元格</h1>
<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>字段会居中对齐。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2574239985db4315b028be7e66c6c39e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=TdpKgdlbsxf52dTMw4S4TFKwkYg%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;"><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/3c542b494d1d485482a19d5b7b5413eb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=UoFyckeXylpQKwUaRmMb7gNqydw%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/9cfa17a85adf4cfab190e7c84ef6afcd~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=3b47eXQuhj6Aa1%2FeO1DlQSwmjLc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（3）空单元格值和错误值的处理</h1>
<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>对错误值和空单元格设置默认0<span style="color: black;">表示</span>，美化透视表。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/59d53ba7792340d8966f3dd10ce799f5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=cTUAZR8xSIwikqNmAyh4xQRHyE4%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/f38887fb6f3b4adc8605daba0d6bf9f0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=ZwfTVA3KNYirrxlKxN7X%2Bm53%2F9s%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">3、删除数据透视表</h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">（1）<span style="color: black;">经过</span>【数据透视表分析】>【操作】->【清除】->【<span style="color: black;">所有</span>清除】</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/e43cf09366704f18a6aafbd1c64571a1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=1heIxRMWh5efdlnYxsud8QIUd8Y%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;">（2）鼠标左键框选中<span style="color: black;">全部</span>数据透视表，<span style="color: black;">而后</span>按delete键<span style="color: black;">就可</span>删除对应的数据透视表。</span></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">4、<span style="color: black;">选取</span>数据透视表及表中标签，值</h1>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（1）选中<span style="color: black;">全部</span>数据透视表</h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/d4c47f5f109e4118b781e245db2319eb~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=yEao0l6t9Asb%2FTjhglC%2FwJpwqlE%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（2）选中值<span style="color: black;">表示</span>区</h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8f62e87e2f2f47b7adc87b5f64415056~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=TCfdMj6C7fnLc17AMus7bl37E80%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（3）选中标签区</h1>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/0fda10be6bbb418ba711a1417a4b8fc8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=xt196msII2WPrgT6rymdVguKefo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（4）启用选定内容</h1>
<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>快速<span style="color: black;">选择</span><span style="color: black;">拥有</span>相同属性的标签、值行、字段列.用于批量修改所选区域的属性。</span></p>
<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>在行，列标签的签名进行点击尝试。<span style="color: black;">显现</span>黑色箭头点击后<span style="color: black;">能够</span>选中。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">例1：为各<span style="color: black;">分部</span>的汇总项添加蓝色背景，并对各<span style="color: black;">分部</span>汇总值字体颜色改为红色。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">①在K15单元格前<span style="color: black;">显现</span>黑色</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/ea3716fdccd7485eb9ca4b6fe2d49a47~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=fB9ChOzNIFfOaKgpgEICC3zE6n4%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 style="color: black;">就可</span>选中。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/faa080d2b48247c19d127191a1a6a1b9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=W1%2Bs3v2wEfe7ZuTXC%2BVcaitMrLc%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 style="color: black;">起始</span>】->【字体】->填充颜色，<span style="color: black;">选取</span>框选颜色<span style="color: black;">就可</span>。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/69e34e56589641faa1b1ae2b6fd4ffd5~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=UdmOQIMYhAnEv0BQ9AQAyks4QhU%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 style="color: black;">经过</span>【数据透视表分析】->【操作】->【<span style="color: black;">选取</span>】->【值】，对汇总行进行“值”选中。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8fb1bc5d47794b748f838eeb59d11e07~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=cpRGgVBDKq%2F1oRR6v9WxsOmurR0%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://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7f89b9774844449ab4e1f60852ad9ef2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=Ngl69a44385fVUSx9YQaHlugoYc%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 style="color: black;">起始</span>】->【字体】->字体颜色，<span style="color: black;">选取</span>框选颜色<span style="color: black;">就可</span>。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a9c80b39bcbe4c35944a28a423a19819~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=0KhCiedCfBlmAqskTvPTjVzFjj4%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 style="color: black;">最后</span>效果如下：</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/f5f538cc7803400abfaa41bdc495fde1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=YSs5OStMItCg3gvCF0Yaq1PYRxI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">6、移动数据透视表</h1>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（1）打开移动透视表对话框</h1>
<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>【数据透视表分析】>【操作】->【移动数据透视表】，打开对话框。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/2a729d5113a14b2ab325083c53ae82a6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=RjRQoiV9aHZa5ERkfczcv0IfsjA%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（2）选定移动后的新位置</h1>
<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>鼠标点选新位置，<span style="color: black;">而后</span>确认<span style="color: black;">就可</span>。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/9adb0e033de644df8d837af6c6f0d03c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=lgMmGLOLlbEbWAqfkemyIODsqDI%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;"><span style="color: black;">数据透视表的左上角<span style="color: black;">初始</span>单元格从原来的K6移动到K3。</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a144e49028bf48eda568fbe80860ad40~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=fIE6BNSKsJf3X5JCcYxHE1giD0A%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">6、数据透视表转为普通静态表格数据</h1>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（1）选中<span style="color: black;">全部</span>数据透视图</h1>
<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>右键->【复制】。</span></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">（2）粘贴为值</h1>
<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>合适的目的单元格位置，右键->【粘贴选项】->【值】</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7d49299926a649ff91a05d6ecaf3b6d9~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=bBaKBSJwXpKWICwNFRkMhynwuoQ%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/ba66e051d660411089079daa20fc37c2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727950433&x-signature=gFcUdYTG1nwMPkkTZFppubC0kSM%3D" style="width: 50%; margin-bottom: 20px;"></div>
谷歌外链发布 http://www.fok120.com/ 回顾历史，我们不难发现：无数先辈用鲜血和生命铺就了中华民族复兴的康庄大道。 你的话语如春风拂面，让我感到无比温暖。 我深感你的理解与共鸣，愿对话长流。
页:
[1]