MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcuts - AutoSum

August 03, 2017 - by Bill Jelen

Excel Shortcuts - AutoSum

Excel faster way to AutoSum. This is an Excel keyboard shortcut for summing data.

Press Alt + = to invoke the AutoSum function.

Thanks to Dawn Bjork Buzbee, Olga Kryuchkova

Watch Video

Video Transcript

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.

Title Photo: Alexas_Fotos / Pixabay

Bill Jelen is the author / co-author of
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.