There is no AutoFilter range on the worksheet.
在工作表中无“ 自动筛选”区域。
Allows or prohibits the use of the AutoFilter feature.
允许或禁止使用自动筛选功能。
Allows or prohibits the use of the AutoFilter feature.
允许或禁止在电子表格中排序数据。
Cannot create this list while the AutoFilter command is turned on.
当“自动筛选”命令打开时，无法创建此列表。
Gets or sets a value that indicates whether the AutoFilter is displayed.
获取或设置一个值，该值指示是否显示自动筛选。
This property returns the Filters collection for the current AutoFilter range.
该属性返回当前自动过滤区域的过滤器集合。
Turn the AutoFilter off, or create the list using the 'My list has headers' option.
关闭“自动筛选”命令，或者使用“我的列表有标题”选项创建列表。
No list was found. Select a single cell within your list, and then use the AutoFilter command again.
未发现列表。请在列表中选择单一单元格，然后再用“自动筛选”命令。
To show only rows that match specific criteria, point to Filter on the Data menu, and then click AutoFilter.
单击“数据”菜单中的“筛选”，并选择“自动筛选”命令，可以显示所有符合指定条件的数据行。
Gets or sets a value that indicates whether AutoFilter arrows are enabled when user-interface-only protection is turned on.
获取或设置一个值，该值指示当打开仅限用户界面保护时是否启用“自动筛选”箭头。
(we have also added the ability to sort by colour or cell icon to our in-grid filter capabilities (nee autofilter). say i started with the following table …
我们也在表格内置的筛选功能（又称自动筛选）中加入了对颜色或单元格图标进行排序的能力我将用下面表格演示…
Tip of the Day: To filter your list to show important subsets of the data, select a cell in the list, choose Filter from the Data menu, and then choose AutoFilter.
日积月累：若要筛选数据库或数据清单中的数据，可选择“数据”菜单中的“筛选”命令。
Each table has its own AutoFilter whereas the sheet can only have a single AutoFilter, so if you need to filter more than one dataset on a sheet, than tables are your only option.
虽然工作表只能有一个自动筛选，但是每个列表都可以有自己的自动筛选。所以当你在工作表中需要不止一个数据集时，列表是你唯一的选择。
The first thing we tried to do was to make it easier to turn on AutoFilter by making it part of the "Sort & Filter" commands on the Sheet tab in the Excel ribbon (the tab that is shown by default).
我们尝试做的第一件事就是让自动筛选功能成为工具栏按钮中“排序筛选”命令的一部分。
The first thing we tried to do was to make it easier to turn on AutoFilter by making it part of the "Sort & Filter" commands on the Sheet tab in the Excel ribbon (the tab that is shown by default).
我们尝试做的第一件事就是让自动筛选功能成为工具栏按钮中“排序筛选”命令的一部分。
应用推荐