天气预报 > 其他 > wps表格中如何一次筛选多列
wps表格中如何一次筛选多列
更新时间: 2020-10-02 00:00:00  

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

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

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

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

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

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

关键词: wps 表格 如何 筛选

wps表格中如何一次筛选多列相关经验

天气预报

最新推荐

页面:/news/view-3091452/ | 耗时:0.5195 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
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)