Autosum shortcut key in Microsoft Excel |
Auto sum shortcut key in Microsoft Excel. Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you want to know the value of and pressing Alt and = together.
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 =.
Mon
|
Tue
|
Wed
|
Total
|
|
Jan
|
10
|
20
|
30
|
60
|
Feb
|
20
|
30
|
40
|
90
|
Mar
|
30
|
40
|
50
|
120
|
Apr
|
40
|
50
|
60
|
150
|
Total
|
100
|
140
|
180
|
No comments:
Post a Comment