Co-Authored By:

##### Asked by: Dejan Agranenko

technology and computing databases# How do I sum horizontal cells in Excel?

Last Updated: 24th May, 2020

**cell**directly belowa

**column**of data. Then on the Formula tab, click AutoSum>

**Sum**.

**Excel**will automatically sense the range tobesummed. (AutoSum can also work

**horizontally**if you selectanempty

**cell**to the right of the

**cells**tobesummed.)

Click to see full answer.

Consequently, how do I do a horizontal sum in Excel?

**To use AutoSum in Excel, just follow these 3easysteps:**

- Select a cell next to the numbers you want to sum: To sumacolumn, select the cell immediately below the last value inthecolumn.
- Click the AutoSum button on either the Home orFormulastab.
- Press the Enter key to complete the formula.

Beside above, how do you insert a Total row in Excel? **Total the data in an Excel table**

- Click anywhere inside the table.
- Go to Table Tools > Design, and select the check boxforTotal Row.
- The Total Row is inserted at the bottom of your table.
- Select the column you want to total, then select an optionfromthe drop-down list.

Similarly, how do you sum up cells in Excel?

If you need to **sum** a **column** or rowofnumbers, let **Excel** do the math for you. Select a**cell**next to the numbers you want to **sum**, clickAutoSum on theHome tab, press Enter, and you're done. When youclick AutoSum,**Excel** automatically enters a formula (thatuses the**SUM** function) to **sum** thenumbers.

How do I add a whole column in Excel?

**Enter the SUM function manually to sum a columnInExcel**

- Click on the cell in your table where you want to see thetotalof the selected cells.
- Enter =sum( to this selected cell.
- Now select the range with the numbers you want to totalandpress Enter on your keyboard. Tip.