How to Add (or Subtract) in a Spreadsheet like Excel

Microsoft Excel 2010 can quickly calculate a row or column of numeric values. Simple operations, such as adding and subtracting, can calculate on the worksheet. The "Home" tab includes an "AutoSum" button in the "Editing" group. This sum function contains a formula that adds the values and inserts the total or sum in an adjacent cell.

...
Excel's "AutoSum" can calculate the sum of positive and negative values.

Video of the Day

Step

Open the Excel worksheet.

Step

Enter the values in a row or column.

Step

Click a cell to the right of the row of values or click a cell below the column of values. The selected cell displays a black outline.

Step

Click the "Home" tab.

Step

Click the "AutoSum" button in the "Editing" group. This summation button displays the uppercase Sigma. A formula appears with the range of cells.

Step

Press the "Enter" key. The total appears in the selected cell.

Show Comments