天气预报 > 科技 > excel技巧大全
excel技巧大全
更新时间: 2021-01-21 09:57:26  

1、在圈选区域后使用快捷键ALT+=即可进行一键求和。

2、圈选需要隐藏的行按快捷键CTRL+9即可快速隐藏,按CTRL+SHIFT+9即可取消隐藏。

3、在数值混乱的时候点击右上方的排序和筛选,即可对数据进行升序降序的排序。

4、在右上方的排序和筛选中打开筛选功能,即可在列表中筛选出需要的数据。

关键词: excel 技巧 大全

excel技巧大全相关经验

天气预报

最新推荐

页面:/news/view-2057917/ | 耗时:0.8520 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=2057917 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=2057917 LIMIT 0,1
select * from tbl_Articles_sphinx where id=2057917 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(538536,1069995,1693792,606082,2046525,1215865,494651,3195409,1903385,1483156,1191801,81595,626726,2894657,417852,753789,2238033,1099324,1212912,610828,2130170,3493680,543262,459580,1207632,1164883,1531243,2852216,1388210,830830) ORDER BY field (ArticleID,538536,1069995,1693792,606082,2046525,1215865,494651,3195409,1903385,1483156,1191801,81595,626726,2894657,417852,753789,2238033,1099324,1212912,610828,2130170,3493680,543262,459580,1207632,1164883,1531243,2852216,1388210,830830)