Monday, 12 December 2016

How do use autosum shortcut key in Excel


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