天气预报15天查询> 科技> excel技巧大全

excel技巧大全

更新时间: 2021-01-21 09:57:26     

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

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

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

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

关键词: excel 技巧 大全

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

电话:
邮箱:

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

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

页面:/news/view-2057917/ | 耗时:0.5741 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
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)