excel两表数据过滤_在Excel表中关闭过滤器

excel两表数据过滤

在Excel表中关闭过滤器 (Turn Off Filters in Excel Table)

Now that the 30 Excel Functions in 30 Days challenge has ended, it's time to look at a few other features. On the Contextures page on Facebook, Lee suggested AutoFilters as a topic for some February posts. Thanks Lee! Here's how to turn off filters in Excel table headings.

既然30天之内的30种Excel函数挑战已经结束，现在是时候看看其他一些功能了。 在Facebook的Contextures页面上 ，Lee建议将AutoFilters作为2月一些帖子的主题。 谢谢李！ 这是关闭Excel表标题中的过滤器的方法。

Excel表格中的过滤器 (Filters in Excel Tables)

When you create an Excel Table in Excel 2007 or Excel 2010, autofilter arrows are automatically added to the heading cells. Most of the time, this is a welcome feature, and the arrows make it easy to sort and filter the columns.

在Excel 2007或Excel 2010中创建Excel表时，自动过滤器箭头会自动添加到标题单元格。 在大多数情况下，这是一个受欢迎的功能，使用箭头可以轻松地对列进行排序和过滤。

You can even create more than one Excel table on a worksheet, and have a separate filter on each table. I use this feature occasionally, when creating small tables on a summary sheet. Just remember to stack the tables, instead of placing them side by side. That way, the filtered rows in one table won't affect the others.

您甚至可以在一个工作表上创建多个Excel表，并且在每个表上都有一个单独的过滤器。 在摘要表上创建小表时，有时会使用此功能。 只要记住要堆叠桌子，而不是将它们并排放置。 这样，一个表中的筛选行将不会影响其他表。

Note: If you don't use the Excel Table feature, you're limited to a single AutoFilter (or Advanced Filter) per worksheet.

注意：如果不使用Excel Table功能，则每个工作表只能使用一个AutoFilter (或Advanced Filter )。

关闭自动过滤器 (Turn Off the Automatic Filters)

Sometimes, though, you don't want to have those filter arrows available. For example, you might set up tables because they're a quick and easy way to create a dynamic range. Or, maybe you like the pretty colours and automatic total row.

但是，有时您不希望这些过滤器箭头可用。 例如，您可能要设置表格，因为它们是创建动态范围的快速简便的方法。 或者，也许您喜欢漂亮的颜色和自动总行。

But, you don't want to encourage users to filter the data -- all the rows should always be visible. And you know those pesky users will click the arrows, if they're temptingly available.

但是，您不想鼓励用户过滤数据-所有行都应始终可见。 而且您知道那些讨厌的用户会点击箭头(如果它们很诱人的话)。

要关闭过滤器： (To turn off the filters:)

1. Select a cell in the Excel Table
   在Excel表格中选择一个单元格
2. On the Ribbon's Data tab, click the Filter command, to turn off the filter.
   在功能区的“数据”选项卡上，单击“筛选器”命令，以关闭筛选器。

保留Excel表格功能 (Keep the Excel Table Features)

After you turn off the filters, the Excel Table is still recognized as a table, so you can continue to use all its other features. Even though the filter arrows are gone, you can add a Table Style, and show Banded Rows.

关闭筛选器后，Excel表格仍被识别为表格，因此您可以继续使用其所有其他功能。 即使过滤器箭头消失了，您也可以添加表格样式并显示带区的行。

Or, create formulas that use structured referencing, instead of cell references.

或者，创建使用结构化引用而不是单元格引用的公式。

翻译自: https://contexturesblog.com/archives/2011/02/02/turn-off-filters-in-excel-table/

excel两表数据过滤