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.