EXCEL高级筛选使用步骤如下:
1、打开电脑桌面上的excel工作簿。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/35a85edf8db1cb1383c7ce8ad354564e93584bf9?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、系统默认进入开始后,单击开始右侧的数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bf096b63f6246b607fe540ede5f81a4c500fa244?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、单击排序和筛选组中的筛选。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd3eb13533fa828b40da147af31f4134960a5aaa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、在不包含数据的区域内输入一个筛选条件,例如在单元格I19中输入总销售额,在单元格I20中输入>500000。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c8177f3e6709c93d840b876e913df8dcd00054aa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、将光标定位在数据区域的任意一个的单元格中,单击排序和筛选组中的高级。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9e3df8dcd100baa137d5ce224910b912c9fc2eaa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、弹出高级筛选对话框,选择方式为在原有区域显示筛选结果,然后单击条件区域文本框右侧的折叠按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2fdfc039245d688d0fa3b3daac27d1ed31b24aa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、弹出高级筛选—条件区域,然后在工作表中选择条件区域I19:I20。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/241f95cad1c8a7862c8fb8976909c93d71cf5086?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、单击确定,返回工作表中,筛选效果就出来了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/aa18972bd40735fafe08c72090510fb30e2408aa?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)