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).
我们尝试做的第一件事就是让自动筛选功能成为工具栏按钮中「排序筛选」命令的一部分。
Turn the AutoFilter off, or create the list using the 「My list has headers」 option.
关闭「自动筛选」命令,或者使用「我的列表有标题」选项创建列表。
There is no AutoFilter range on the worksheet.
在工作表中无「 自动筛选」区域。
Allows or prohibits the use of the AutoFilter feature.
允许或禁止在电子表格中排序数据。
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.
虽然工作表只能有一个自动筛选,但是每个列表都可以有自己的自动筛选。所以当你在工作表中需要不止一个数据集时,列表是你唯一的选择。
Gets or sets a value that indicates whether the AutoFilter is displayed.
获取或设置一个值,该值指示是否显示自动筛选。
Allows or prohibits the use of the AutoFilter feature.
允许或禁止使用自动筛选功能。
No list was found. Select a single cell within your list, and then use the AutoFilter command again.
未发现列表。请在列表中选择单一单元格,然后再用「自动筛选」命令。
This property returns the Filters collection for the current AutoFilter range.
该属性返回当前自动过滤区域的过滤器集合。
Gets or sets a value that indicates whether AutoFilter arrows are enabled when user-interface-only protection is turned on.
获取或设置一个值,该值指示当打开仅限用户界面保护时是否启用「自动筛选」箭头。
Cannot create this list while the AutoFilter command is turned on.
当「自动筛选」命令打开时,无法创建此列表。