![How enable adding columns in excel 2016](https://kumkoniak.com/73.jpg)
![how enable adding columns in excel 2016 how enable adding columns in excel 2016](https://cdn.ablebits.com/_img-blog/excel-solver/excel-options.png)
Below I have given an example of adding the cells using the add operator.Īfter typing the formula press enter to obtain the result.
![how enable adding columns in excel 2016 how enable adding columns in excel 2016](https://cdn.ablebits.com/_img-blog/add-column/excel-column-letter-button.png)
In the cell type the formula for adding the desired cells or numbers.Īs you will go on typing the formula, the cells you have mentioned in formula will get highlighted. Here, you have to select a cell where you want the result of the addition to be stored. We can simply add the values in several cells using the sum operator ( +). So let us start with the steps to add or sum in MS Excel 2016. We will discuss how we can simply add numbers in the cells using the operator? How we can add using AutoSum, using SUMIF formula? We will also discuss how we can add only selected cells using Filter?
![how enable adding columns in excel 2016 how enable adding columns in excel 2016](https://www.techonthenet.com/excel/columns/images/insert2013_002.gif)
In this section, we will discuss the other options which can also be used to add the cells in excel 2016. It generates the sum of two or more cells in a sheet quickly. One of the popular method to add in excel is AutoSum. You have a variety of method to add or sum in Excel. Adding is a basic mathematical operation, and is often used during the mathematical calculations.
![How enable adding columns in excel 2016](https://kumkoniak.com/73.jpg)