Excel+multiple+cells+with+same+formulae

There is a way in which you can enter data into many cells at one go, ( Even non-adjacent ones ).
 * Excel multiple cells with same formulae **

Hold down **Ctrl** and select the cells you wish to have the same data ( i.e. Formulae ) When you have selected all, and whilst they are still high-lighted type in your data.

__ Do not press **Enter** to change a line use the arrow keys, or the mouse. __
 * Caution ** :

Now for the clever bit when you have typed in all the data:-

Hold down **Ctrl** and press **Enter**

Voila!