如下图所示
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_3","w":"553.73","h":"546.88","dataType":"png","c":"word/media/image1.png","imgOriW":727,"imgOriH":718})
问题描述：要查看更多数据，需要频繁的上下移动滚动条
数据组合后，处理结果如下图所示：
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_8","w":"553.73","h":"546.88","dataType":"png","c":"word/media/image2.png","imgOriW":727,"imgOriH":718})
选择要隐藏的数据，如下图：
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_8","w":"553.73","h":"546.88","dataType":"png","c":"word/media/image3.png","imgOriW":727,"imgOriH":718})
选择Excel菜单栏的“数据”项，如下图
![](https://wkrtcs.bdimg.com/rtcs/image?w=470.00&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_8","w":"470.00","h":"138.00","dataType":"png","c":"word/media/image4.png","imgOriW":470,"imgOriH":138})
点击右边面板中的“组合”，如下图
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_8","w":"553.73","h":"318.07","dataType":"png","c":"word/media/image5.png","imgOriW":719,"imgOriH":413})
问题描述：折叠的![](https://wkrtcs.bdimg.com/rtcs/image?w=20.00&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_18","w":"20.00","h":"17.00","dataType":"png","c":"word/media/image6.png","imgOriW":20,"imgOriH":17})
按钮处于下方，没有良好用户体验，该按钮应在上方
解决方法：需要进行显示设置，如何进行设置如下图
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_8","w":"553.73","h":"120.31","dataType":"png","c":"word/media/image7.png","imgOriW":718,"imgOriH":156})
点击图中箭头指示的按钮，弹出设置框，如下图
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_8","w":"553.73","h":"267.32","dataType":"png","c":"word/media/image8.png","imgOriW":696,"imgOriH":336})
取消“明细数据的下方”前面的勾选，如下图
![](https://wkrtcs.bdimg.com/rtcs/image?w=553.73&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_3","w":"553.73","h":"234.24","dataType":"png","c":"word/media/image9.png","imgOriW":669,"imgOriH":283})
点击确定按钮，显示结果如下图
![](https://wkrtcs.bdimg.com/rtcs/image?w=470.00&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_8","w":"470.00","h":"356.00","dataType":"png","c":"word/media/image10.png","imgOriW":470,"imgOriH":356})
点击![](https://wkrtcs.bdimg.com/rtcs/image?w=20.00&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_3","w":"20.00","h":"17.00","dataType":"png","c":"word/media/image6.png","imgOriW":20,"imgOriH":17})
按钮，显示结果如下图
![](https://wkrtcs.bdimg.com/rtcs/image?w=210.00&md5sum=53e07094f2064592ca95fb2ea58bead8&sign=ef4ffda762&rtcs_flag=2&rtcs_ver=3.1&l=webapp&bucketNum=23&ipr={"t":"img","r":"r_8","w":"210.00","h":"118.00","dataType":"png","c":"word/media/image11.png","imgOriW":210,"imgOriH":118})
PS：操作步骤就这样，跟着做一遍其实也很简单了，呵呵
本文来源：https://www.2haoxitong.net/k/doc/ffa919718e9951e79b8927e4.html
文档为doc格式