O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required