Thursday, June 2, 2011

Tip 1




Type Shortcut
Implementation Alt + =
Description 1> ALT + = is used to do the AutoSum. This tip comes very handy if most of your daily
calculations depend on addition of values. (Image 1)

2> AutoSum can be used not only when the values are adjacent to the result cells, but
even if it's randomly displayed. All that you have to do is, press ALT + = in the cell where
you want the result to be displayed and while holding the CTRL key click all the cells that
you want to be included in the result. (Image 2)
Additional Info / Attachment                     Image 1                                                                  Image 2
           


No comments:

Post a Comment