To show only rows that match specific criteria, point to Filter on the Data menu, and then click AutoFilter.

单击“数据”菜单中的“筛选”，并选择“自动筛选”命令，可以显示所有符合指定条件的数据行。

youdao

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.

日积月累：若要筛选数据库或数据清单中的数据，可选择“数据”菜单中的“筛选”命令。

youdao

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.

日积月累：若要筛选数据库或数据清单中的数据，可选择“数据”菜单中的“筛选”命令。

youdao