Monday, September 19, 2011

Auto Sum Shortcut Key Formula


Instead of using the AutoSum button from the toolbar,
you can press Alt and = to achieve the same result.


Click on the image to enlarge...











Instead of using the AutoSum button from the toolbar,



you can press Alt and = to achieve the same result.










Try it here :





Move to a blank cell in the Total row or column, then press Alt and =.


or






Select a row, column or all cells and then press Alt and =.











Jan
Feb
Mar
Total


North
10
50
90
150


South
20
60
100
180


East
30
70
200
330


West
40
80
300
420


Total
100
260
690
1050