Thursday, 27 July 2017

Microsoft Excel 2016 – AutoSum and Quick Sum with the Status Bar

To quickly get the Sum of a range of cells, all you need to do is select the range, and click AutoSum. Even quicker, select the range and look in the lower right-hand side of the Excel window, the Status Bar.

AutoSum from the Ribbon:
Select the cell to the right or below the numbers you want to add, then click AutoSum on the Home tab.


Note: Click the drop-down link to the right of the AutoSum button for more options besides Sum.
Quick Sum with the Status Bar:

If you want to quickly get the Sum of a range of cells, all you need to do is select the range and look in the lower right-hand side of the Excel window.



No comments:

Post a Comment