Click the AutoSum button on the Standard toolbar, then press ENTER.
In Excel, nobody wants to add multiple columns and rows on their calculator and to re-add them if the numbers change. Then, what's the simplest and fastest solution? What should they do at that time? Simply, they should useAutoSum button!
Steps to use AutoSum button:
Initially, to add up a row or column of numbers, you need to highlight all of the cells that you want to add up (vertically in a columnandhorizontally in a row). Then tapAutoSumon the Ribbon in theEditinggroup. This will quickly add all the cells which you have selected.