If you one of those Excel users that prefer working with the keyboard rather than the mouse, you can use the following Excel AutoSum keyboard shortcut to total cells: Now, you can see the calculated total in the cell, and the SUM formula in the formula bar: Press the Enter key to complete the formula.For more details, please see How to use AutoSum on more than one cell at a time. To sum multiple columns or rows at a time, select several cells at the bottom or to the right of your table, respectively, and then click the AutoSum button. In a rare case when a wrong range is selected, you can correct it manually by typing the desired range in the formula or by dragging the cursor through the cells you want to sum. In most cases, Excel selects the correct range to total. Click the AutoSum button on either the Home or Formulas tab.Ī Sum formula appears in the selected cell, and a range of cells you're adding gets highlighted (B2:B6 in this example):.To sum a row, select the cell to the right of the last number in the row.To sum a column, select the cell immediately below the last value in the column.
No wonder they decided to add a special button to the Excel ribbon that inserts the SUM function automatically. You will see how to automatically sum columns or rows with the Sum shortcut, sum only visible cells, total a selected range vertically and horizontally in one go, and learn the most common reason for Excel AutoSum not working.ĭid you know that Excel SUM is the function that people read about most? To make sure, just check out Microsoft's list of 10 most popular Excel functions. This short tutorial explains what AutoSum is and shows the most efficient ways to use AutoSum in Excel.
0 kommentar(er)
