Tuesday, July 06, 2004

Here is a great Excel shortcut. The most used function, at least for me, is the AutoSum. With it Excel creates a formula using =SUM() to add up a series of cells vertically or horizontally. Simply click on the cell beneath or to the right of the series you wish to add up, then click the AutoSum button on the toolbar -- instant formula!

But there is an even easier way! Click on the cell to contain the =SUM() and using the keyboard, press Alt+= and the =SUM() is generated as if you had clicked the button on the toolbar. Try it.