Sum It Up With Two Keys
I’m sure many of you are familiar with the AutoSum button in MS Excel, right?
It’s a handy little feature that, with a single click, inserts the formula for the sum of a column of data located just above whatever cell you currently have selected.
Now, those of you who prefer to use the keyboard for everything may be wondering if there’s an equivalent shortcut for you. So, the next time the keyboard enthusiast in you wants to use the AutoSum feature, give this a try!
Select the cell below your column of data.
Then simply use Alt + =.
Voila! The formula needed to sum up the column of data is inserted with the cell references in place, just as if you’d actually clicked the AutoSum button. It just doesn’t get any easier than that!