天气预报 > 其他 > excel如何跳行求和
excel如何跳行求和
更新时间: 2020-10-03 00:00:00  

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

关键词: excel 如何 求和

excel如何跳行求和相关经验

天气预报

最新推荐

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