可能是操作方法不对,可以参考下面处理看下:
1、首先如本例,要求筛选出A列中包含内容[女士]的所有人员信息。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/58ee3d6d55fbb2fb8e45346c5f4a20a44623dc66?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、点击选中标题所在单元格,本例为A1单元格,然后依次点击【数据】-【筛选】选项按钮,这样,在A1单元格的右下角就出现了一个小按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0b7b02087bf40ad1d98aab9d472c11dfa9ecce66?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、点击A1单元格内的小按钮,在弹出的菜单选项中依次点击[文本筛选]-【包含】选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4b90f603738da977a741ea55a051f8198618e366?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、通过上一步骤,在系统中弹出了【自定义自动筛选方式】对话框,在对话框中的人员信息中按照要求设置,如下图所示,完成后点击【确定】按钮。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/faedab64034f78f07a65f68d69310a55b3191c65?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、返回到表格中,通过以上操作步骤,A列中包含[女士]的人员信息就全部筛选了出来,结果如下图所示:
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d1160924ab18972ba3546cb4f6cd7b899e510a65?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)