Sum It Up In Excel With Just 2 Keys?
Many of us are familiar with the AutoSum button in MS Excel.
It’s a handy little guy who will, with a single click, insert the formula for the sum of a column of data located just above whatever cell you currently have selected.
Those of you who prefer to use the keyboard for everything may be wondering if there’s an equivalent shortcut for you. 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.
Now simply use Alt + =.
Voila! The formula to sum 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!