天气预报15天查询> 其他> excel如何跳行求和

excel如何跳行求和

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

选中A1:A3范围单元格,右击设置单元格格式;选择对齐,勾选自动换行,点击确定;点击A4单元格,按键盘等于号键,单击AI单元格,出现闪动边框表示求和操作正在进行;按键盘加号键,闪动边框自动跳到下一行,直到到达最后一个单元格;到最后一个单元格按下回车键,自动显示结果。

关键词: excel 如何 求和

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

电话:
邮箱:

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

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

页面:/news/view-1384681/ | 耗时:0.1188 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1384681 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1384681 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1384681 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(110247,2474364,249130,110440,1107052,291010,1127529,109434,2172794,107724,113215,1070262,2683582,1132159,3282585,111301,2916582,109637,1112839,111651,916438,112250,1069557,108083,2045181,2919797,112024,1607401,1819759,2683505) ORDER BY field (ArticleID,110247,2474364,249130,110440,1107052,291010,1127529,109434,2172794,107724,113215,1070262,2683582,1132159,3282585,111301,2916582,109637,1112839,111651,916438,112250,1069557,108083,2045181,2919797,112024,1607401,1819759,2683505)