If you want a fast and quick sum of figures in a column or row, simply using the following keyboard combination: ALT= (Equal sign).
Notice that after doing the ALT= the forumula range appears, so just hit the Enter key to execute. For example, type in the following numbers in the appropriate cells:
- A1 - 5
- A2 - 5
- A3 - 6
- A4 - 4
- A5 - 2
- Go to A7 and hit the ALT= keys, and hit the Enter key. The addition or sum will be correctly placed without using the formula or the SUM() command.
This also works for rows and columns. But for different range combinations, you will have to use the formula.
Just click on the button for the Tiproom's Home Page.