Excel教程：WPS透视表和Excel的区别
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrNLgYP93SiczibW2ibu2fibd6Via7NYQv1XTOh7Uib6zs4abehXSiamECXF5QWzgY5IBpQhic5MqGgo5oSjpQ/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrNLgYP93SiczibW2ibu2fibd6Via7NYQv1XTOh7Uib6zs4abehXSiamECXF5QWzgY5IBpQhic5MqGgo5oSjpQ/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><strong style="color: blue;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYeBmEAeXJQN9kQzh6YHxQZ5mlWyPcMIrMRF6gxW7XRP60lr3vJl7Aiaw/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></strong></a></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>WPS的透视表和Excel的<span style="color: black;">有些</span><span style="color: black;">区别</span></span></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">1）透视表字段列表<span style="color: black;">不可</span>关闭</span></strong></h1><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrPYupwr5Gnqlo0UJTJ2phJU4HYhPdJluv31CicKV2sibzFfrrRxryT5hNFVlmjib05SOdHO0jcfsDkTA/640?wx_fmt=gif&tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">如上图所示，每次关闭了，再重新点到数据透视表里，字段窗口又弹出来</span><span style="color: black;">这种问题<span style="color: black;">怎样</span>处理呢？</span><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrPYupwr5Gnqlo0UJTJ2phJUoM2BZKiaQibaPcHA1iaOFJGxbs0FvcYjIRiaHH7wgFJW1nLKEia6TSHtscQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">点击「分析」选项卡，点击「字段列表」从<span style="color: black;">这儿</span>关闭就不会再弹出来了</span>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">2）<span style="color: black;">要求</span>格式<span style="color: black;">不可</span>自动<span style="color: black;">转</span>范围</span></strong></h1><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrPYupwr5Gnqlo0UJTJ2phJUGsPwmR7YUJppuI1ogTib3yph4FQUiauVHt0hjx9HWutxtaEyzC4fEG5g/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;">咱们</span>做了一个很好看的<span style="color: black;">要求</span>格式</span><span style="color: black;">在原来老版本，<span style="color: black;">倘若</span>我们刷新，这个<span style="color: black;">要求</span>格式会自动消失</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><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrPYupwr5Gnqlo0UJTJ2phJU6Q9nEhpltFf57aWFlaCTNLExKTWUugLQRGcBUuwbKAicD1UIpVuueog/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">刷新后你会<span style="color: black;">发掘</span>，范围不会跟着变化</span><span style="color: black;">这种<span style="color: black;">状况</span>怎么处理？</span><span style="color: black;">躺平吧，别用<span style="color: black;">要求</span>格式了，在透视表里</span><span style="color: black;">Excel里<span style="color: black;">倘若</span>你做了<span style="color: black;">要求</span>格式</span><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrPYupwr5Gnqlo0UJTJ2phJUiavBOm0fOOIhSH88ibibibvXeuiayCNeGRrwo8PeQDW2ZDoVXWFiahRnAKHw/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">会有一个设置选项，改成第三个</span><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrPYupwr5Gnqlo0UJTJ2phJUNpypicAGCkn0fSgIm3cIibhGSEBzFVavh9wqibVicRYzTHHd9O2jSnHo0Q/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">就会自动<span style="color: black;">按照</span>透视表范围<span style="color: black;">调节</span>了，不<span style="color: black;">晓得</span>WPS什么时候能跟进</span>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">3）<span style="color: black;">不可</span>替换求和项</span></strong></h1><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrPYupwr5Gnqlo0UJTJ2phJUxQOBeAAwMfrwAjMFibxibDvbHLcibvUOFy1LhNDdibvEH5C7266BoTWEqQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><span style="color: black;">这般</span>的数据，我不想要「求和项:」怎么办？</span><span style="color: black;"><span style="color: black;">根据</span>Excel的办法，按Ctrl+H调出替换窗口</span><img src="https://mmbiz.qpic.cn/mmbiz_png/XVayrImXFrPYupwr5Gnqlo0UJTJ2phJUUm5RmQXOSM0hlmgbQb5lYueglJVSfricOcOzyRvPryGwMjnWjoEp0SQ/640?wx_fmt=png&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">下面输入空格，替换就搞定了</span><span style="color: black;"><span style="color: black;">然则</span>，WPS里没反应。。。真的没反应</span><span style="color: black;">咋办？<span style="color: black;">好似</span>只能一个一个改为空格</span><span style="color: black;"><span style="color: black;">倘若</span>有小伙伴<span style="color: black;">晓得</span>其他好办法，欢迎下面留言</span>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/gC0ymMIMUyFcxicmE8ibcxGaibCx4zKbZaAkecPFqGXvjkgNNibdycJp9rrI57ozZOg6OoC0da9fJTx9YuialSjzVbw/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYeZBg49eW4OBN8pSRNvjemjq1h6Hd2HX6yib6iceUm74BWTWnN9oJJgZQ/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYn0R0X3F7GFRZSm1e7Da4V6DpPvgSUTxia4Sgib65Y345FDI6eXhNCoPQ/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1E0WNKTSF0wICRHBmuy34VYjibT1yuxWM3lOibxE6pX1mYdSYZia2iapHXurduQbw4RBB942ThFf8kgSQ/640?wx_fmt=png&from=appmsg&tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/0jZ2JWHnNSlcJ8Y7GkHCPjrDJITwmtI8iaUHOft6Ez8licKpk2YrLrtz89RZHWpebo5E9guekDbJNHibWBY35xfYw/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" style="width: 50%; margin-bottom: 20px;"><strong style="color: blue;"><span style="color: black;">倘若</span>还有什么需要咨询的，联系<span style="color: black;">微X</span>客服18074746783</strong></p>
<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;"><img src="https://mmbiz.qpic.cn/sz_mmbiz_png/bePCGbRich1GXRE1YeOr3zQjYyaH5Q9B6Jwq25D1dWAPwSc0RVZFHCq9mX8L5MppkEbDKD3iaShZkudT9FFTC9fw/640?wx_fmt=png&wxfrom=5&wx_lazy=1&wx_co=1&tp=webp" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/XVayrImXFrOJKwvDg8o6XkaMLSCqp9nia2x0EmTJavf1ORsQbRr3GDicoCuib6y0gAYhic1glSgDjYmcX1Dz7xkZXA/640?wx_fmt=gif&wxfrom=5&wx_lazy=1&tp=webp" style="width: 50%; margin-bottom: 20px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">点击阅读原文<span style="color: black;"><strong style="color: blue;"><span style="color: black;">一键登录官网，海量视频vip任意学！(可试看)</span></strong></span></span></strong></span></p>
楼主的文章非常有意义，提升了我的知识水平。
页:
[1]