It just takes a double click - copying a formula in Excel

So, assuming you've already created formulae in MS Excel, you've no doubt realised you can copy this formula.  Perhaps this is a quicker way you are not already familiar with...

• Click onto the cell that contains the formula you want to copy
• Notice how the cell has a dark border around it?   And also that it doesn't quite join up properly in the bottom right hand corner?  That little blobby shape in the corner is called the Fill Handle - I think it's OK to call it the blobby thing though ;)

• Place your mouse pointer right over the "blobby" Fill Handle
• Now you'll see that your mouse pointer changes shape to a thin black cross
• At this point you probably think... yeah, yeah... I know... click and drag.  But nope, that's not my next step... why don't you try...
•  Double click

Cool huh?  Sadly, as with many things... there are caveats

The double click method only works for copying a formula down, not in any other direction.  It also requires that there is information in the column immediately to the left of the copy location.