Enter formulae into multiple cells
If a formula is to be used in a series of cells, select the cells first. Now type in your formula and hold the Ctrl key while you press Enter. This enters the formula in each selected cell.
Just be careful with your absolute and relative cell references.
Added by Martin on 10th October 2011
More Excel hints and tips, like: