天气预报 > 其他 > excel如何设置下拉筛选
excel如何设置下拉筛选
更新时间: 2020-09-29 00:00:00  

excel设置下拉筛选步骤如下:

1、首先打开Excel表格,框选一列表格,点击左上角的数据按钮。

2、选择数据验证,点击数据验证,在允许一栏中选择序列。

3、在来源一栏输入想要设置的选项,点击确定,在表格右边点击就可以看到下拉筛选了。

关键词: excel 如何 设置 筛选

excel如何设置下拉筛选相关经验

天气预报

最新推荐

页面:/news/view-2162749/ | 耗时:0.7219 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=2162749 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2162749 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2162749 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1593408,1095928,550096,511188,132871,338728,1093062,1079952,247135,1074819,594735,1069557,690772,1127435,616845,150065,130103,334756,619770,1083146,614098,340453,207978,1048224,1113724,274587,1070058,1050623,1065393,621807) ORDER BY field (ArticleID,1593408,1095928,550096,511188,132871,338728,1093062,1079952,247135,1074819,594735,1069557,690772,1127435,616845,150065,130103,334756,619770,1083146,614098,340453,207978,1048224,1113724,274587,1070058,1050623,1065393,621807)