How to Add [SUM()] Automatically in Excel

Quickly add an entire column or row by clicking in the first empty cell in the column. Then enter ALT + ‘=’ (equals key) to add up the numbers in every cell above. Press Enter to accept the answer.

Click on the picture below for more details.