If you need to sum a column or row of data, we can use AutoSum in Excel which utilizes the SUM function to sum the numbers quickly. You may use AutoSum in Excel in three different ways:
Also read: Calculate age in Excel
3 ways to use Autosum in Excel
Let’s take a look at the different ways to use autosum in Excel.
1. Keyboard shortcut for autosum in Excel
- Select the cell where you want the autosum results to populate. Make sure that the cell is near the data so Excel knows which data you want to add up. Look at the screenshot below for an example.
![How to use AutoSum in Excel? [Step-By-Step] 3 autosum in Excel](https://quickexcel.com/wp-content/uploads/2021/06/marks-for-autosum.jpg)
- Press the ‘Alt‘ + ‘=‘ keys to highlight the selection of cells to be used for calculation. You can modify the automatically selected data here.
![How to use AutoSum in Excel? [Step-By-Step] 4 autosum in Excel](https://quickexcel.com/wp-content/uploads/2021/06/selection-for-autosum.jpg)
- Press Enter to quickly sum a column or row of numbers.
![How to use AutoSum in Excel? [Step-By-Step] 5 AutoSum by shortcut](https://quickexcel.com/wp-content/uploads/2021/06/AutoSum-by-shortcut.jpg)
2. AutoSum on the Home tab
- Select the cell where you want to populate the Autosum data as we did in the 1st example.
- Click AutoSum in the Editing section of the Home tab.
![How to use AutoSum in Excel? [Step-By-Step] 6 AutoSum on Home tab](https://quickexcel.com/wp-content/uploads/2021/06/AutoSum-on-Home-tab.jpg)
- It highlights the selection of cells to be used for calculation.
![How to use AutoSum in Excel? [Step-By-Step] 7 selection for autosum 1](https://quickexcel.com/wp-content/uploads/2021/06/selection-for-autosum-1.jpg)
- Press Enter to quickly sum a column or row of numbers.
![How to use AutoSum in Excel? [Step-By-Step] 8 AutoSum result](https://quickexcel.com/wp-content/uploads/2021/06/AutoSum-result.jpg)
3. AutoSum on the Formulas tab
- Select the cell adjacent to the column or row of numbers you want to sum.
- Go to the Formulas tab.
- Click AutoSum in the Function Library section of the Formulas tab.
![How to use AutoSum in Excel? [Step-By-Step] 9 Formulas tab](https://quickexcel.com/wp-content/uploads/2021/06/Formulas-tab.jpg)
- It highlights the selection of cells to be used for calculation. Modify the selection according to the requirement.
![How to use AutoSum in Excel? [Step-By-Step] 10 selection for autosum 2](https://quickexcel.com/wp-content/uploads/2021/06/selection-for-autosum-2.jpg)
- Press Enter to quickly sum a column or row of numbers.
![How to use AutoSum in Excel? [Step-By-Step] 11 AutoSum result 1](https://quickexcel.com/wp-content/uploads/2021/06/AutoSum-result-1.jpg)
Conclusion
In this article, you go to know how to use the AutoSum in Excel with the help of multiple examples. I hope you were able to understand this function better.