MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: Add a Total Row and a Total Column with One AutoSum

January 30, 2020 - by Bill Jelen

Add a Total Row and a Total Column with One AutoSum. Photo credit: Tim Mossholder at

Say that you want to add a total row and a total column to a data set. Select all the numbers plus one extra row and one extra column. Click the AutoSum icon or press Alt+=.

Numbers are in B4:E7. You want totals in row 8 and column F. Select B4:F8 and press Alt Equals.

Excel adds SUM functions to the total row and the total column as shown in the figure below.

After pressing Alt Equals, the blank cells in the Total row and Total column are filled with =SUM formulas.

Title Photo: Tim Mossholder at

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.

Bill Jelen is the author / co-author of
MrExcel 2020 - Seeing Excel Clearly

This is a 4th edition of MrExcel LX. Updates for 2020 include: Ask a question about your data, XLOOKUP, Power Query's Data Profiling tools, How Geography Data Types decide which Madison, A SEQUENCE example for descending 52 weeks, Exchange Rates support in Stock Data Types, How to collapse the Search box, How to leave effective feedback for Microsoft, How to post your worksheet to the MrExcel Board using XL2BB.