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.
- Press the ‘Alt‘ + ‘=‘ keys to highlight the selection of cells to be used for calculation. You can modify the automatically selected data here.
- Press Enter to quickly sum a column or row of numbers.
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.
- It highlights the selection of cells to be used for calculation.
- Press Enter to quickly sum a column or row of numbers.
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.
- It highlights the selection of cells to be used for calculation. Modify the selection according to the requirement.
- Press Enter to quickly sum a column or row of numbers.
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.