Turn the AutoFilter off, or create the list using the'My list has headers'option. 关闭“自动筛选”命令,或者使用“我的列表有标题”选项创建列表。
To show only rows that match specific criteria, point to Filter on the Data menu, and then click AutoFilter. 单击数据菜单中的筛选,并选择自动筛选命令,可以显示所有符合指定条件的数据行。
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). 我们尝试做的第一件事就是让自动筛选功能成为工具栏按钮中“排序筛选”命令的一部分。
Cannot create this list while the AutoFilter command is turned on. 当“自动筛选”命令打开时,无法创建此列表。
To remove the filter arrows from a range or list, point to filter on the data menu, and then click autofilter. 若要删区域或列表中的筛选箭头,请指向“数据”菜单中的“筛选”,再单击“自动筛选”。
Select a single cell within your list, and then use the AutoFilter command again. 请选择单一单元格或清除该选项的选定。
There is no AutoFilter range on the worksheet. 在工作表中无自动筛选区域。
AutoFilter cannot be used on list with no header. autofilter无法在没有标题的列表上使用。
Cannot insert or delete a column in an area in which the AutoFilter command is turned on. 无法在自动筛选命令处于打开状态的区域中插入或删除列。
In the skills field heading, click the AutoFilter arrow, and then click the skill you want to filter for. 在技能域标题上,单击“自动筛选”箭头,再单击要筛选的技能。
An Autofilter range cannot contain merged cells. 自动筛选区域不能含有合并的单元格。