King Web Design and Computer Services Pty Ltd

Two quick ways to sum Excel data

There are two easier ways to sum values:

Highlight the row or column, plus one blank cell for the result
* press [Alt]++ OR
* click AutoSum on the Standard toolbar.

For example, if you want to sum the values in cells B2:B5, you selecte cells B2:B6, and then press [Alt]++ or click AutoSum. Excel will display the sum in cell B6. You don’t have to enter a thing — just highlight and click or press.

Obviously, AutoSum is the easiest route, but the Standard toolbar isn’t always available, so knowing the [Alt]++ combination might come in handy. Most methods work with multiple columns and rows and noncontiguous blocks of values.

posted by King Web Design And Computer Services Pty Ltd @ 11/18/2009 10:28:00 PM