• 欢迎访问速搜资源吧，如果在网站上找不到你需要的资源，可以在留言板上留言，管理员会尽量满足你！

# 【速搜问答】Excel筛选怎么用

3年前 (2020-05-25) 519次浏览

Chinese-English Translation:

Excel 表格筛选功能的用法就是排序数据、文本筛选和数字筛选。首先打开 excel 表格，选择需要筛选的数据，然后点击主菜单中的“数据”菜单，选择筛选工具，然后就可以根据自己的需要对数据进行筛选或排序了。

The usage of Excel table filtering function is sorting data, text filtering and number filtering. First, open the excel table, select the data to be filtered, then click the “data” menu in the main menu, select the filter tool, and then you can filter or sort the data according to your own needs.

Excel 表格筛选功能的用法就是排序数据、文本筛选和数字筛选。首先打开 excel 表格，选择需要筛选的数据，然后点击主菜单中的“数据”菜单，选择筛选工具，然后就可以根据自己的需要对数据进行筛选或排序了。

The usage of Excel table filtering function is sorting data, text filtering and number filtering. First, open the excel table, select the data to be filtered, then click the “data” menu in the main menu, select the filter tool, and then you can filter or sort the data according to your own needs.

When we just use Excel, we may not know how to use the filtering function. Then we will share the use method and steps of the excel table filtering function with you.

step

1、打开 excel，全选第一行的标题，点击主菜单中的“数据”菜单，然后选择筛选工具。

1. Open excel, select all the titles of the first row, click the “data” menu in the main menu, and then select the filter tool.

2、对筛选的数据进行排序，比如点击 D 列中对话数的下拉按钮，选择排序功能，让对话数列中的数字进行降序排列，可以看到数据是按从大到小的方式进行排列展示的。

2. Sort the filtered data. For example, click the drop-down button of the number of conversations in column D, select the sorting function, and let the numbers in the conversation column be sorted in descending order. You can see that the data is arranged and displayed in a large to small way.

3、也可以单独选择其中一个条件，比如在 A 列中输入“你好”，仅勾选“你好”，点击确定。接着在表格中就全部显示 A 列中包含“你好”的所有数列，而其他的数列会隐藏。

3. You can also select one of the conditions separately, for example, enter “hello” in column a, check “hello” only, and click OK. Then all the columns with “hello” in column a will be displayed in the table, while other columns will be hidden.

4、还可以进行文本的筛选，比如点击 C 列关键词下拉框，选择文本筛选，然后再选择“包含”条件，输入包含的关键词，然后点击确定。excel 表格中就会显示在 C 列关键词列中包含有“你好”的数据，其他的数据也隐藏了。

4. You can also filter the text, for example, click the keyword drop-down box in column C, select the text filter, then select the “include” condition, enter the included keywords, and then click OK. The excel table will show that there is “hello” data in the keyword column of column C, and other data is hidden.

5、最后还可以进行数字的筛选，比如打开 D 列对话数列的下拉框，选择数字筛选，然后选择“大于或等于”条件。在弹出来的自定义筛选方式窗口下的“大于或等于”右侧的输入框中，填写数字 5，然后点击确定。在 excel 表格数据中，根据 D 列对话数列的条件，只显示大于或等于 5 的数据，其他的数据也隐藏了。

5. Finally, you can filter the numbers. For example, you can open the drop-down box of column D dialog, select the number filter, and then select the condition “greater than or equal to”. Fill in the number 5 in the input box to the right of “greater than or equal to” in the pop-up custom filter method window, and then click OK. In Excel table data, only data greater than or equal to 5 is displayed according to the condition of d-column dialog data column, and other data is also hidden.

The usage of filtering function is sorting data, text filtering and number filtering. Have you learned? Learning to screen not only improves our work efficiency, but also makes our data more accurate. We don’t have to worry about working late at night.

[361009623@qq.com]

• 版权声明

本站的文章和资源来自互联网或者站长
的原创，按照 CC BY -NC -SA 3.0 CN
协议发布和共享，转载或引用本站文章
应遵循相同协议。如果有侵犯版权的资
源请尽快联系站长，我们会在24h内删
除有争议的资源。
• 网站驱动

• 友情链接

• 支持主题