• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using AutoSum

The AutoSum button on the Standard toolbar is one of the most useful tools in Excel. AutoSum automatically totals a range of values. Click into the cell where you want the total to appear and click the AutoSum button. The SUM formula appears in the cell and a marquee surrounds the range of values in the column. Click the AutoSum button again. A total of the range in the column directly appears in the last cell.

AutoSum can total cells in a row, as well as a column. Click the first empty cell in a row that contains values and click AutoSum, as illustrated in Figure 5.8. The SUM formula appears in the cell and a marquee surrounds the range of values in the row. Click the AutoSum button again. The total of the preceding cells appears in the last cell.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint