To perform an auto sum in Excel for the values you have in the cells above the active cell or the values in the cells from the left, you can use the shortcut key Alt + =. When you press this shortcut key it inserts the sum function in the active cell by referring to the range that’s above or on the left.
Alt + =
Now as I said, you can also insert an auto-sum for the values that we have on the left side.
But if you have values on the left side as well as above the active cell, it will insert an autosum further about values. There’s one more thing when you press the shortcut key, it inserts the function, but you need to press enter to get the result.