Updated: 11/12/2023 by Computer Hope
Autosum option and drop-down menu in Microsoft Excel

AutoSum is a Microsoft Excel and other spreadsheet program function that adds together a range of cells and displays the total in the cell below the selected range. The AutoSum feature makes entering formulas easy without needing to type or memorize the syntax for each one.

Where is AutoSum in Excel?

In Excel 2010 and later, the AutoSum feature is on the Home tab, in the Editing section.

How to AutoSum in a spreadsheet

First, if you're using Excel, make sure you're in the Home tab. Next, assuming you wanted to add the values of cells between A1 and A5, highlight cells A1 through A5 and click the AutoSum button (pictured). Clicking this button after highlighting the cells creates the formula =SUM(A1:A5) in cell A6 (first cell after last highlighted cell) and gives you the total of all those cells.

Auto, Formula, Spreadsheet terms, Sum