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

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

问答 admin 2个月前 (09-08) 44次浏览 已收录 0个评论

汉英对照:
Chinese-English Translation:

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

Excel table filtering function is used to sort data, text filter and number filter. First of all, open the excel table, select the data to be filtered, and 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 表格,选择需要筛选的数据,然后点击主菜单中的“数据”菜单,选择筛选工具,然后就可以根据自己的需要对数据进行筛选或排序了。

Excel table filtering function is used to sort data, text filter and number filter. First of all, open the excel table, select the data to be filtered, and 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 表格筛选功能的使用方法和步骤吧。

When we first used Excel, we may not know how to use the filtering function, so let’s share with you the use methods and steps of Excel table filtering function.

步骤

step

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

1. Open excel, select all the titles of the first line, 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 dialogue number in column D and select the sorting function to arrange the numbers in the Dialogue Series in descending order. You can see that the data is arranged and displayed in a way from large to small.

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

3. You can also select one of the conditions separately, for example, enter “hello” in column a, just check “hello” and click OK. Then in the table, all the columns containing “hello” in column a will be displayed, while the others 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, and then select the “include” condition, enter the included keywords, and then click OK. Excel table will show that there are “hello” data in the keyword column of column C, and other data are also hidden.

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

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

筛选功能的用法就是排序数据、文本筛选和数字筛选啦,你学会了吗?学会筛选,不但提高了我们的工作效率,而且也让我们得出的数据更加准确,再也不用担心加班到深夜啦。

The usage of the filter function is to sort data, text filter and number filter. Have you learned it? Learn to screen, not only improve our work efficiency, but also let us get more accurate data, no longer need to worry about working late into the night.


速搜资源网 , 版权所有丨如未注明 , 均为原创丨转载请注明原文链接:【速搜问答】Excel筛选怎么用
喜欢 (0)
[361009623@qq.com]
分享 (0)
发表我的评论
取消评论
表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址