Thursday 22 September 2011

Excel : Keyboard shortcut for AutoSum

Summing (Totaling)  is a frequent task in Excel.

In the picture below, we have a block of values in column H and wish to get the total in a cell  below the last value.

In a cell below the block , press Alt and = keys together followed by Enter.  This is called  AutoSum. This is also available as a Tool button :

Note: We can do this for a block of cells in a row too by using the above keyboard shortcut in a cell to the right of a row block.

How it works? Excel checks if there is a continuous group of cells with numbers above (column block) , it then checks to the left (row block) and displays the formula. Before pressing Enter, we can check the displayed formula and manually change it in case Excel has not guessed it right.

No comments:

Post a Comment