# Way combination in excel program ## Contents

• 1 Use a combination coefficient in Excel
• 2 Use automatic combination in Excel
• 3 combination in Excel using cell references
• 4 References

## Use a combination coefficient in Excel

Users can perform a combination process within the cell (Cell) per program in Excel (Excel), by following the following steps: 

• Excel software installed on the device open.
• Click on any blank cell, and then type an equal sign (=).
• Writing the required combination process of finding its output after the equal sign to be formed as follows, for example, (+ 1 = 1).
• Pressing the enter key (Enter) from the keyboard, to appear as a result of the combination process in the cell.

## Use automatic combination in Excel

Users can perform automatic combined operation (AutoSum) on the entire row (row), or column (column) in the Excel program a MS Office (Office) programs, by following the following steps: 

• Excel program to open the installer on your desktop.
• Select a cell under the desired column calculate the sum of the values ​​within it, or select a cell on the right to find the desired row total values ​​within it.
• Pressure on the automatic combination (AutoSum) option located in the Home tab (Home), or pressure on the equations (Formulas), then the option of pressing the automatic combination option (AutoSum).
• Pressing the enter key (Enter) from the keyboard, to appear as a result of the combination process in the cell, the cells that have been combined by the process of shading.

## In combination with Excel cell references

Users can perform a combination process by using the equations on the cell references (Cell References) in the tables for the program Excel, by following the following steps: 

• Cell identification is required to show the result of combining them, and then typing equality signal (=) where.
• Determine the first reference cell that contains the first value of the combined operation, to be inserted into the equation, for example (A3).
• Writing a combination (on +) after the first reference cell.
• Determine the second reference cell that contains the second value of the combined operation, to be inserted into the equation, for example (B3), becomes the form of the equation as follows: (A3 + B3 =).
• Pressing the enter key (Enter) from the keyboard, to appear as a result of the combination process in the cell.

## References

• ↑ wikiHow Staff (28-3-2019), "How to Add in Excel"، www.wikihow.com, Retrieved 14-5-2019. Edited.
• ↑ "Use AutoSum to sum numbers", support.office.com, Retrieved 14-5-2019. Edited.
• ↑ "How to Add Numbers in Excel Using a Formula", www.lifewire.com,23-1-2019، Retrieved 14-5-2019. Edited.

### We regret it!

Successfully sent, thank you!