如何将数据过滤器仅应用于表范围而不应用于整个行? [英] How do I apply data filter to only the table range and not the whole row?

问题描述

我有两个相邻的桌子.当我在第一个表上应用数据过滤器时，它也会过滤整个行，并隐藏第二个表中的行.如何将过滤器限制为仅第一个表格范围?

I have got two adjacent tables. When I apply data filter on first table, it filters the whole row hiding rows from 2nd table as well. How do I restrict filter to only the first table range?

推荐答案

要回答您的直接问题如何将过滤器仅限制在第一个表范围内?答案是-您不能.

To answer your direct question How do I restrict filter to only the first table range? the answer is - you can't.

阅读注释，似乎您需要的是在图表和另一个表格旁边显示过滤后的表格数据. Excel中有一个鲜为人知的工具- Camera 工具.使用此工具，您可以创建范围的动态图像并将其放置在所需的位置.在将滤镜应用于源范围时，图像会更新，而不会影响仪表板"图纸上的行.

Reading the comments it seems what you need is to display the filtered table data next to a chart and another table. There is a little know tool in Excel that you can use to achieve this - the Camera Tool. With this you can create a dynamic image of a range and place it where you want. The image updates when a filter is applied to the source range, without affecting the rows on the Dashboard sheet.

屏幕截图以演示: 在单独的工作表上设置表格，并在仪表板工作表上的图表旁边设置摄像机图像

Screenshots to demonstrate: Setup with tables on seperate sheets, and camera images beside chart on dashboard sheet

将过滤器应用于表A

With Filter applied to Table A

摄影机"工具不在功能区(Excel 2010)或标准工具栏(Excel 2003)上.您需要使用自定义"添加它. (在2010年添加到Qucik Access工具栏，在2003年添加到工具/自定义菜单")

The Camera tool is not on the Ribbon (Excel 2010) or the standard toolbars (Excel 2003). You need to add it using Customisation. (Add to Qucik Access Toolbar in 2010 or Tools/Customisation Menu in 2003)

这篇关于如何将数据过滤器仅应用于表范围而不应用于整个行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！