问题已解决
如果我在一张EXCEL表中用了Alt+=这个公式,但是现在要撤销,怎么操作
![](https://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
新年好。撤销上一步操作的组合键是ctrl+z
2019 02/13 14:32
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784996 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 02/13 14:40
我基础工资那一列还没加底薪进去,以前我是拉一列下来在最后一个单元格求和,然后并排那一行直接拉就自动求和了,用了ALT+=它只能出来有数字的列,第一列就不出来
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784996 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 02/13 14:40
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
Excel刘老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 02/13 14:41
ALT+=那只是求和函数SUM函数一个快捷方式罢了,跟在单元格里输入=SUM(区域)是一样的东西,觉得区域它自动选的不对,就手动改一下就好了。在编辑栏改一下。
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784996 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 02/13 14:44
我选中整一列空白单元格在最后一个点自动求和,它结果在第一个单元格里出现下图
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784996 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 02/13 14:44
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784996 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 02/13 14:45
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784996 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 02/13 14:45
我点的右上角那个
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
Excel刘老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 02/13 14:45
在B122单元格输入公式=SUM(B4:B111)
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784996 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 02/13 14:51
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
Excel刘老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 02/13 14:53
输入=SUM(B4:B111),不是输入=B4:B11,SUM函数和括号呢?
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784996 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2019 02/13 14:53
好了
![](https://pic1.acc5.cn/009/13/30/65_avatar_middle.jpg?t=1651203215)
Excel刘老师 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2019 02/13 14:58
嗯请点右下角的结束问题