A few arrows have appeared in my Excel workbook while using a Pivot Table. When there is data visible in the table the filters lay on top of the data. Is there any way you can hide these arrows?
使用数据透视表时,我的Excel工作簿中出现了一些箭头。当表中可见数据时,过滤器位于数据之上。有什么方法可以隐藏这些箭头吗?
2 个解决方案
#1
3
Go to Data tab and click on filter icon
转到数据选项卡,然后单击过滤器图标
**And another way to do is by using shortcut**
Just select the range and Press
(1) ctrl + shift+ L in your excel.
#2
0
Removing these was actually quite simple:
删除这些实际上非常简单:
Select and delete the entire row.
选择并删除整行。
#1
3
Go to Data tab and click on filter icon
转到数据选项卡,然后单击过滤器图标
**And another way to do is by using shortcut**
Just select the range and Press
(1) ctrl + shift+ L in your excel.
#2
0
Removing these was actually quite simple:
删除这些实际上非常简单:
Select and delete the entire row.
选择并删除整行。