EXCEL表格里创建数据透视表，经过筛选标签多维度查看打印数据
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">在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>从<span style="color: black;">分部</span>查看或打印数据，又<span style="color: black;">期盼</span>能从<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;">全选<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-axegupay5k/ea0e618b09f341e2a44cb6cdf3f741e2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953616&x-signature=EcafsKwXwAHN2DU08hPSaf6xpx0%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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/28706a55496e4f88bf89e8cf434f997d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953616&x-signature=5rgy0mDoLXBozQwd%2B3zaNVX8DK0%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/9df200ad286f4a13b008217293ae6b64~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953616&x-signature=1BveaqD1Lpj9XgVm4bDbTFLS%2FMc%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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/87bfcbfa07eb4b63b2a10b48b40510b8~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953616&x-signature=XZS2FJv3SpEOVMOpw7xP3G5lT6E%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/47c66543e4e845ca83ee841c136fc9b0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953616&x-signature=LHl0SBj6XBTtHpVPewHkjFQPZR8%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>汇总数量和金额。<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/02e000f0c6cf42c4bb70edafdb18130e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953616&x-signature=wvT2ore16IcOCxN%2Fqzj55CCRsZ4%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>字段拖动到筛选窗口。</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>，点击B1单元格，<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://p26-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/3a20443569dc47ef9a8338ccc4ddf6f3~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953616&x-signature=%2BfZQLCLcNMdit7SaDpggfI1FwTE%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>编号查阅或打印，打开右侧的“数据透视表字段”，移动原来的<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>编号进行查阅或打印。</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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/49df4a6bf2b048529215a318386b2807~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727953616&x-signature=zznDgZlWc33uHYK0R1Sq42sNlpg%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>
网站建设seio论坛http://www.fok120.com/
页:
[1]