Why not use the name box?
This tip doesn't work for more complicated formulas. A better way for me is to copy the original formula, type where you want it to go in the name box and then paste it. For example if my formula is in cell M1 I select that cell and press Ctrl+C. Then if I want to copy it to M2 to M15 I put M2:M15 in the name box and press Ctrl+V. Also only three steps and much more flexible than the original tip.
Keep Up with TechRepublic