# How to add cells in Excel

Microsoft Excel is one of the largest numeric data manipulation software in the world. We can perform all the mathematical operations in Excel. It provides us with the built-in tools and functions to sum up numeric data.

In this tutorial we’ll learn how to add a cell’s value in MS Excel. We have two different ways to add/sum up the cell’s numeric data.

## Method 1 – Using sum formula

Microsoft Excel provides us a built-in formula to sum data  in specific data range

To sum we have given formula

=SUM(number1 , number 2 , …..)

We can add more than 1 number by using the above-mentioned formula. In most cases we have a big data range with thousands of data cells that we need to get summed up. This formula really helps. Below are the steps to follow.

## Step 1 – Select the cell and use formula

• Select any empty cell.
• Type the formula. In this case, we have 1020 cells in the G column. We will type =SUM(G2:G1021). It will select all data ranges starting from cell G2 and ending at  G1021.
• Close the bracket and press enter key.
• As soon as you press the enter key, it will sum all the selected data range.

## Method 2 – Use auto sum function

This method allows us to add numeric data automatically by a single click.

Below are the steps to follow.