天气预报15天查询> 其他> wps表格中如何一次筛选多列

wps表格中如何一次筛选多列

更新时间: 2020-10-02 00:00:00     

1、打开软件的的表格,找见首行工具栏里的筛选功能项;

2、选中要筛选的项目栏行列,点击筛选功能下的筛选项;

3、选中的项目栏行列自动添加筛选按钮;

4、点击任何一个筛选按钮,自动出现可筛选框;

5、在要筛选的项目前打钩,点击确定,筛选项目自动显示;

6、要取消筛选设置,选中有筛选按钮的行列,重新点击筛选功能下的筛选项即可。

关键词: wps 表格 如何 筛选

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-3091452/ | 耗时:0.9762 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3091452 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3091452 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3091452 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1125101,971076,1103273,1127187,1066404,1046963,3188624,1123092,1066334,1111458,1126098,320637,1093316,1082363,1086095,2239062,1130444,1061424,1083995,399018,1105785,1064819,1084585,1065795,1125107,1096837,905945,1122204,1117606,1119512) ORDER BY field (ArticleID,1125101,971076,1103273,1127187,1066404,1046963,3188624,1123092,1066334,1111458,1126098,320637,1093316,1082363,1086095,2239062,1130444,1061424,1083995,399018,1105785,1064819,1084585,1065795,1125107,1096837,905945,1122204,1117606,1119512)