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 Unsplash.com.

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 Unsplash.com

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