Quick Analysis in Excel

I'm often asked if Microsoft Excel is able to place a 'sum' total to the side of a column, instead of at the bottom of a column. The Quick Analysis tool can help you do that.

(1) Select the cells you want to sum, and (2) left-click the Quick Analysis icon (bottom right-corner of selection) or keyboard shortcut is Ctrl + Q.

From (3) the Quick Analysis dialog box, select Totals, next select the 'Sum' totals feature that will place it to the side not at the bottom.

Please note: the Quick Analysis tool is only available in Excel 2013 & 2016 version only.

Write a comment

Comments: 0