Excel shortcut for copying formulas

I found another quick Excel shortcut the other day.  (Courtesy of LifeHacker) When you want to copy a formula down a column, I typically grab the bottom right corner of a cell, and drag the mouse down through all the cells I want to copy the formula too.  This is pretty easy and fast, which is probably why I never found this new shortcut before.  An even quicker way is to simply double click on the bottom right corner of a cell, and it will automagically fill all the cells downward in the column until the last one with data in the column to the left.  Example:

Screen Shot 2013-06-28 at 6.45.04 AM

Here I have a column on the left with data, and the column on the right with a simple formula that I want to apply to that data.  Typically I would just grab the bottom right corner and drag down to copy the cell.

IMG_20130628_064555

An even faster way is to double click when the cursor changes to the black cross, and it will automagically copy the formula for you.

Screen Shot 2013-06-28 at 7.22.28 AM

Hope you found this useful and time saving!