Excel - How to add a column/row of numbers easily?

You want to total the numbers from A1 to A10 and display the answer in cell A11.

• Place the pointer in cell A11.
• Press ALT + = . Excel will display =SUM(A1:A10) automatically.
• Press Enter.

This feature can also be used to add a row of numbers say A1 to F1.

Place the pointer in G1 and Press ALT + =



View EasyElearn video on Microsoft Excel - AutoSum