Excel Shortcuts - AutoSum

Learn Excel From MrExcel, Podcast Episode 2123: ALT+= Is The AutoSum Function.

Alright. The very first formula that anyone ever learns to do in Excel is the AUTOSUM. So, you come up here to the HOME tab, click the AUTOSUM, they propose a formula for you, and you press ENTER, but you don't have to reach up there to the HOME tab at all.

Just press ALT+=, ALT+=, and that will propose the formula, and then, the awesome, awesome trick: if you need a TOTAL row and a TOTAL column -- of course the TOTAL column works, right, that's no hassle, so you could enter that and copy that down -- but beautiful, beautiful trick. Select all your numbers, one extra row, one extra column, then hit AUTOSUM or ALT+=, and they will put TOTALS all the way around. TOTALS across there, even a TOTAL across there, people seem to care, and then these are all TOTALS down. Fast, fast way to go.

Well, hey. I want to thank you for stopping by. We’ll see you next time for another netcast from MrExcel.